2

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

The event count of 83321 sounds a bit high to me.

This server runs just for some days.

  • Do you have any third part tools monitoring your server? – Mark Sinkinson Nov 13 '15 at 11:33
  • It could be the default trace what traces are registered in sys.traces SELECT * FROM sys.traces – Spörri Nov 13 '15 at 11:33
  • no, no 3rd party tools which can enable a trace, besides Sharepoint? I am not sure what sharepoint can do – RayofCommand Nov 13 '15 at 11:42
  • @Spörri I added my trace, there are 3 more with no relevant data – RayofCommand Nov 13 '15 at 11:49
  • You can find out whose traces they are from the default trace (one of them is likely the default trace - did you look at all of the columns in sys.traces?) : sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/29/… – Aaron Bertrand Nov 13 '15 at 12:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.