Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

SQL Server Performance Tuning and Monitoring Tutorial

By: Greg Robidoux | Read Comments (4) | Print Greg is the President of Edgewood Solutions and a co-founder of MSSQLTips.com with over 200 contributions. Related Tips: More

Read the tutorial!

SQL Server is a great platform to get your database application up and running fast. The graphical interface of SQL Server Management Studio allows you to create tables, insert data, develop stored procedures, etc... in no time at all.

Initially your application runs great in your production, test and development environments, but as use of the application increases and the size of your database increases you may start to notice some performance degradation or worse yet, user complaints. This is where performance monitoring and tuning come into play.

In this tutorial we cover some of the common issues with performance.

Read the tutorial!

Related Tips: More | Become a paid author

Last Update: 1/18/2012

Share:

Share

Tweet

Free SQL Server Learning Building Blocks for Your SQL Server Career Database development best practices What Are You Waiting For?

Comments and Feedback:

Thursday, January 12, 2012 - 8:55:37 AM - ScottH
Thanks for all of the info on the tools.

Saturday, January 14, 2012 - 9:51:59 AM - IVan
Great tutorial.  Can you add more steps to it in the future? Is there anything in new SQL 2012? --IVan

Monday, January 16, 2012 - 4:08:12 PM - Jeremy Kadlec
Greg, Great tutorial.  Thank you for sharing this with the community. Thank you, Jeremy Kadlec

Thursday, February 09, 2012 - 8:24:02 AM - Dave V
This is a great tutorial. Anytime I have come across something that if a great reference I like to copy it or print it to PDF. This is one of those articles where this is impossible as the print function only prints out the 1st page and you have to click the next on every page making it difficult to grap. I wish the you could provide a link to be able to print out the whole tutorial all at once

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

Try the free performance monitoring tool from Idera! Web-based SQL Server monitoring whenever, wherever. Real solutions for real problems. Get in-depth knowledge of all SQL Server features. Join the over million SQL Server Professionals who get their issues resolved daily. Are you waiting on SQL Server? Learn about these DMV's.