SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

2
kudos

Kudos

SQL server wait type: SQLTRACE_INCREMENTAL_FLUSH_SLEEP, what is it?

published 614 days, 17 hours, 9 minutes ago posted by

sa 621 days, 18 hours, 31 minutes ago

SQL server wait type: SQLTRACE_INCREMENTAL_FLUSH_SLEEP, what is it?

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'...(read more)

category: News | clicked: 2 | | source: sqlserver-qa.net | show counter code

tags: Best Practices, event, procedure, profiler, SQL Server, sql tracing, table, wait type

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL server wait type: SQLTRACE_INCREMENTAL_FLUSH_SLEEP, what is it?

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up