Browse by Tags

• disk space
• kill
• kpid
• performance
• processes
• rollback
• sp_who2
• spid
• sysprocesses
• tablesample
• transactions
• wait type
• writelog

SQL Server - Kill a KILLED/ROLLBACK status process without restarting Server or SQL services?
06 May 08 01:02 AM | SQL Master | 2 Comments   

This may be the typical situation within your database environment where the you might have killed a SPID (Process) that has been running for long time, without knowing the ROLLBACK operations for such processes. Say if you are executing a stored procedure Read More...

Filed under: sql server, spid, transactions, transaction log, processes, kill, rollback, sysprocesses, kpid, sp_who2

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