Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
- Taking transaction log backup and full back at the same time
- How do I find hidden files taking up space?
Wait Stats
20 January,2018 by Tom Collins
Whether you're troubleshooting sql server waiting tasks, sql server performance troubleshooting , optimization challenges, health check or just curious these links drill down into specifics of sql server waits
Troubleshooting BACKUPTHREAD wait type
SQL Server – LATCH_EX AND how to reduce it (SQL Server DBA)
SQL Server – Pageiolatch_ex and how to reduce it (SQL Server DBA)
SQL Server - Waitstats CXPACKET wait type and how to reduce it ...
SQL Server – LCK_M_IS and how to reduce it - sql wait type (SQL ...
SQL Server – LOGMGR and how to reduce it (SQL Server DBA)
Fix: –NESTING_TRANSACTION_FULL wait type and how to reduce it
SQL WAIT TYPE – DTC and how to reduce it (SQL Server DBA)
SQL WAIT TYPE – RESOURCE SEMAPHORE and how to reduce it ...
SQL Server – SOS_SCHEDULER_YIELD and how to reduce it (SQL ...
SQL Server – LOGBUFFER and how to reduce it (SQL Server DBA)
SQL Server – LCK_M_X and how to reduce it (SQL Server DBA)
SQL Server Async_io_completion and how to reduce it (SQL Server ...
SQL Server –WRITELOG and how to reduce it (SQL Server DBA)
SQL WAIT TYPE – OLEDB and how to reduce it (SQL Server DBA)
SQL WAIT STAT - TRACEWRITE and how to reduce it (SQL Server ...
SQL Server - PREEMPTIVE_OS_WRITEFILEGATHER and how to ...
How to Reduce the WRITE_COMPLETION wait type (SQL Server ...
How to reduce THREADPOOL wait type (SQL Server DBA)
How to reduce DBMIRROR_EVENTS_QUEUE , DBMIRROR_SEND, DBMIRRORING_CMD, DBMIRROR_DBM_MUTEX wait types
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |