Baseline your SQL Servers - PerfMon counters

Finally got around to a daily summary report for key PerfMon counters on my SQL servers to help with establishing a baseline of their performance.  More here.


Baseline your SQL Servers - Wait Stats

I'm working on establishing a baseline of the performance metrics of my SQL Servers for information that I care about.  I'm starting with Wait Statistics and am working to get my servers to send me information based on the Waits they're incurring and when they normally incur them.

More here.



Reporting on SQL Agent jobs that never run

We know exactly when a job fails, but what if it doesn't run at all?

Here's a quick-and-dirty alert for jobs that hadn't ran in an acceptable amout of time.

More info to the right under SQL - Misc Tips.


T-SQL to View Indexes on a Table

Been working on a system stored procedure to quickly give a heads-up display on what indexes are already on a table.  Among other things I like to analyze key columns, key column order, included columns of existing indexes, and what the key columns of the clustered index are before I start thinking about adding any.  This sproc helps me with that.

You can find the DDL here.

I find the display format helpful.  Looks a little something like this:




Just finished reading a great book on SQL Indexing

Expert Performance Indexing For Sql Server 2011Expert Performance Indexing For Sql Server 2011 by Jason Strate
My rating: 5 of 5 stars

This book is excellent. Puts very complex subject matter in easily understood terms. Contains real world examples for improving performance in your environment.

This book is a great read and highly recommended for anyone looking to improve their SQL database's performance.

It raised my understanding of SQL indexing and had several code samples that I was able to immediately apply to my databases.

I will be seeking out more books by this author.

View all my reviews