SQL Server Performance

SQL server wait type: SQLTRACE_INCREMENTAL_FLUSH_SLEEP, what is it?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 7, 2010.

  1. Anonymous New Member

    Recently I have been involved in a proof of concept of upgrading a OLTP (24/7) databases from SQL Server 2005 to SQL Server 2008 R2 straight away. During the proof of concept process I found the new wait type called "SQLTRACE_INCREMENTAL_FLUSH_SLEEP" which running the following TSQL to obtain wait types: SELECT TOP 10 wait_type , wait_time_ms FROM sys . dm_os_wait_stats WHERE wait_type NOT IN ( 'LAZYWRITER_SLEEP' , 'SQLTRACE_BUFFER_FLUSH' , 'REQUEST_FOR_DEADLOCK_SEARCH' , 'LOGMGR_QUEUE' , 'CHECKPOINT_QUEUE'...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2010/09/07/9504.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9504" width="1" height="1">

Share This Page