Browse by Tags

SQL Server 2008 - Activity Monitor a new key to DBA!

Published 11 March 8 3:14 AM | SSQA.net

Have you looked at the Activity Monitor screen within the Managment Studio? I feel this is somewhat surprise features included from February CTP (or was it there before?). This is more useful to the DBAs to have a look at resource activity and locking...

Filed under: sql server, blocking, dba, version, features, 2008, pages, locks, activity monitor

TSQL to findout blocking and locks on a SQL Server?

Published 7 December 7 1:8 PM | SSQA.net

Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly...

Filed under: sql server, performance, indexes, blocking, security, insert, tsql, locks, deletes

TSQL to identify the transaction with the most locks

Published 31 July 7 9:25 AM | SSQA.net

SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC...( read more ) Read More...

Filed under: sql server, performance, transaction, tsql, locks