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

http://technet.microsoft.com/en-us/library/bb838723.aspx

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

CPU Bottleneck

Memory Bottleneck

IO Bottleneck

Blocking

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.

Thanx.

Vinay

http://rdbmsexperts.com/Blogs/

http://vinay-thakur.spaces.live.com/blog/

http:\www.twitter.com\thakurvinay

Advertisements
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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s