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