OR ( LIKE '%memory manager%'and = 'Memory Grants Outstanding') OR ( LIKE '%memory manager%'and = 'Maximum Workspace Memory (KB)') OR ( LIKE '%memory manager%'and = 'Lock Owner Blocks') OR ( LIKE '%memory manager%'and = 'Lock Blocks') OR ( LIKE '%memory manager%'and = 'Lock Owner Blocks Allocated') OR ( LIKE '%memory manager%'and = 'Lock Blocks Allocated') OR ( LIKE '%memory manager%'and = 'Lock Memory (KB)') OR ( LIKE '%memory manager%'and = 'Granted Workspace Memory (KB)') ( LIKE '%memory manager%'and = 'Connection Memory (KB)') OR ( LIKE '%Buffer Manager%'and = 'Page life expectancy')

OR ( LIKE '%Buffer Manager%'and = 'Page writes/sec') OR ( LIKE '%Buffer Manager%'and = 'Page reads/sec') OR ( LIKE '%Buffer Manager%'and = 'Readahead pages/sec') OR ( LIKE '%Buffer Manager%'and = 'Total pages') OR ( LIKE '%Buffer Manager%'and = 'Free pages')

OR ( LIKE '%Buffer Manager%'and = 'Page lookups/sec') OR ( LIKE '%Buffer Manager%'and = 'Buffer cache hit ratio base') ( LIKE '%Buffer Manager%'and = 'Buffer cache hit ratio') PRINT ' Displaying statistics of SQL server ' IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'.') AND type in (N'P', N'PC'))ĭROP PROCEDURE. USE - Doesn't have to be in master database. Comments: Code will produce a report with important information about your SQL server (2005/2008) and its processes If you find other information that you want to include, just modify this script to reflect the additional information. I recommend that you look closer to this view for all your statistical needs. This script displays data from the dynamic management view called: sys.dm_os_performance and presents it in a report.

SQL error statistics - SQL statistics (SQL compilations/recompilations) - Wait statistics - SQL Execution statistics TempDB statistics - Totals of Database statistics - Plan Cache statistics - Transactions statistics Buffer statistics - Memory statistics - General statistics - Locks statistics/Totals for Locks statistics

If you need to get information out of your SQL server (2005 or 2008) quickly, execute the stored procedure and you will get a detailed report for the following areas

Sql server process monitor