Performance Tunning -Monitoring SQL Server health

I was going through my blog and realize that I have not done much on performance tuning, which is one of my favorite topics. so initialed the new category as performance tuning, Will try to cover most of this stuff on performance tuning.

Long back I blog on performance tuning here, which covers performance consideration for sql server 2000 that will work for newer version of sql server as well like sql server 2005 onwards.

As the first blog on performance tunning, would like to request each individual who want to learn more about performance tunning must read white papers on performance tunning –

Appendix A: Monitoring SQL Server health

here this whitepaper shows the performance issue and how to troubleshoot:

CPU Bottleneck

Memory Bottleneck

IO Bottleneck


Once you go through these links you will get confidence on troubleshooting any performance related problem.

Keep looking for this category, will write very important stuff about performance tunning.

Happy Learning.




This entry was posted in Free Stuff, Performance Tuning, What I learned today, Whitepapers and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.