Some resources to draw info on SQL Server memory usage, locks, fragmentation, etc. This is my favorite SQL Server tuning site: http://www.sql-server-performance.com/ SQL Server Perf Mon SQLServer: Access Methods - Page Splits/sec: Number of page splits occurring as the result of index pages overflowing. SQLServer: Databases - Data File Size (KB) SQLServer: Databases - Log File Size (KB) SQLServer: Databases - Log File Used Size (KB) SQLServer: General Statistics - User Connections: Number of users connected to the system. SQLServer: Locks - Average Wait Time (ms): The average amount of wait time (milliseconds) for each lock request that resulted in a wait. SQLServer: Locks - Number of Deadlocks/sec: Number of lock requests that resulted in a deadlock. SQLServer: Memory Manager - Total Server Memory (KB): Total amount of dynamic memory the server is currently consuming Many, many others… Queries View Blocks SELECT spid, blocked, waittype, getdate() AS 'Time' FROM master....