Friday
Jan242014

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.



Tuesday
Apr302013

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.

 

Wednesday
Feb272013

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.

Friday
Feb222013

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:

 

 

Thursday
Aug022012

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