Cool Tips‎ > ‎

Performance Measurement, Analysis and Optimization






Server-Side Profiler Traces

A set of tables and SPs to schedule, run and summarize multiple SQL Server Profiler server-side traces.

2000, 2005, 2008, 2008R2, 2012


Search SQL Server Error Logs    

Programmatically search through one or all  of the SQL Server error log files .

2000, 2005, 2008, 2008R2, 2012 


Get CPU Usage for last 4 hours   

Retrieves SQL Server, Idle, and Other Process processor percentages from the 'System Health' Extended Events Ring Buffer.
2000, 2005, 2008, 2008R2, 2012  


Kill all Processes in a DB

Kill all user processes in a specified database. Will fail if the current connection is in the specified database or if no database is supplied.

2000, 2005, 2008, 2008R2, 2012 


Kill all Orphan Processes

Kills all user processes on a server with last_batch time older than a supplied number of hours.  Defaults to 24 hours

2000, 2005, 2008, 2008R2, 2012


Get Server Uptime

Retrieve the last time the SQL Server service was restarted, calculate uptime, and indicate whether SQLAgent service is running

2000, 2005, 2008, 2008R2, 2012


Get Database Buffer Cache Size    

Retrieves the Number of pages in the buffer pool with database content. 

2000, 2005, 2008, 2008R2, 2012


Retrieve Key Default Trace Information

Several code snippets to  manage and retrieve SQL Server default perfmon trace information

2000, 2005, 2008, 2008R2, 2012