Browse by Tags

• disk space
• performance
• sql server
• tablesample
• writelog

WRITELOG wait types - what your SQL Server is saying?
12 October 07 05:41 AM | SQL Master | 2 Comments   

Whenever the SQL Server is struggling to write the transactions to the disk, you would observe WRITELOG wait type within SP_WHO2 results. So when you observer such wait types then you should be worried on the disks performance, either you plan for shrinking Read More...

Filed under: performance, sql server, tablesample, disk space, transaction log, wait type, writelog