February 17, 2010 at 10:29 am
We have recently started running a 3rd-party performance-monitoring tool on our SQL server instances and are observing very high waits due to the TRACEWRITE wait type.
The percentage of time of the wait occurrence is 100%(!).
Is this something to be concerned about?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 11, 2010 at 10:29 am
I'm also seeing the same on one of our servers. There are about 20-35 TRACEWRITE wait types at any given time. The users are complaining of performance issues. I don't see anything else out of place on the server.
Thanks,
John
June 11, 2010 at 11:58 am
Is this helpful? http://technet.microsoft.com/en-us/library/cc293610.aspx
December 7, 2010 at 3:47 pm
Should i turn off the default trace ignite is telling me it is causing a high about of wait during production hours
December 7, 2010 at 3:52 pm
Should i turn off the default trace ignite is telling me it is causing a high amount of wait during production hours
This is the #1 query in terms of total execution time.
•It ran for 15.9 hours (across all executions).
•It took 10.6% of total instance execution time.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply