Some database administration queries you can use for SQL Server 2008 in order to identify possible problems. I have not written all of these queries myself -- Identify all processes that are blocked for more than 10 seconds SELECT * FROM sys.sysprocesses
