Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 how to do performance tuning

Author  Topic 

jhunu
Starting Member

18 Posts

Posted - 2011-11-22 : 11:46:15
steps to do performance tuning

vikki.seth
Yak Posting Veteran

66 Posts

Posted - 2011-11-22 : 11:48:41
below may help you to narrow down your performance issue.

http://msdn.microsoft.com/en-us/library/ff647793.aspx
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-22 : 13:10:25
There have been entire books written on that subject:

http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_1?s=books&ie=UTF8&qid=1321985399&sr=1-1

Or, for an introduction:
[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url]
[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -