August 24, 2010 at 8:04 am
Hi,
I have idea about indexing and execution plans, but I don't know how to start with Performance Tuning. Please help me in starting with performance tuning.
August 24, 2010 at 8:15 am
That's a pretty big topic. In fact, books have been written on it...
Basically, you need to start with identifying what is "normal" on your system. Gather metrics on CPU, disk, network and on query performance so that you know what the usual load looks like. This will enable you to identify when the load is abnormal and address issues. Most performance issues come down to TSQL code and indexing. So, spending time identifying which procedures are running slowest or are called most frequently usually pays off. You can do this by gathering the metrics mentioned above using a server-side trace. You can also get snapshots by running queries against the dynamic management views, sys.dm_exec_query_stats.
Past that, there's just tons & tons more information.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 24, 2010 at 10:02 pm
How can I get these CPU, Network & Memory details ? Can you guide me ?
August 24, 2010 at 10:29 pm
beejug1983 (8/24/2010)
How can I get these CPU, Network & Memory details ? Can you guide me ?
You can use a profiler or one of the Set Statistics [time / IO] options, for a start.
Plenty of help available on both of them.
August 24, 2010 at 11:40 pm
pankushmehta (8/24/2010)
beejug1983 (8/24/2010)
How can I get these CPU, Network & Memory details ? Can you guide me ?You can use a profiler or one of the Set Statistics [time / IO] options, for a start.
For CPU, memory, network you'll want performance monitor. Profiler is to see the execution stats of queries.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply