I recently setup a SQL Server which is used only ot run a sharepoint Server. I love to query my wait stats, just to see what we are waiting on. Most of the wait stats are fine, and I know where they come from and how to improve performance. When I came to the office today, I saw that I have huge waits on "Tracewrite", but I haven't run any Trace or Profiling session. Is any task/app/anything in Sharepoint able to generate this tracewrite wait? Google didn't help me much. Or is Tracewrite also generated by some other task?
I am on SQL Server 2014 / Sharepoint 2013 / Windows 2012
A check on:
SELECT * FROM sys.traces
shows that some log is generated in the following path:
\Program Files\Microsoft SQL Server\MSSQL12.SQLSP2013\MSSQL\Log
event count of 83321 sounds a bit high to me.
This server runs just for some days.