March 26, 2013 at 8:11 am
Hi,
Can any one tell me what these items are total cpu usage,context switches/sec,paging rate,network bandwidth utilization,disk queue length .Under what value ranges they should fall normally .. and how can we say some thing is wrong using these items.
March 26, 2013 at 8:29 am
Google "Brent Ozar", read his articles and watch videos. There are very few counters that have some absolute limits, like cpu queue, disk secs per read, secs per write. All others you have to baseline to see what is normal for your system in order to recognize anomaly or a trend.
March 28, 2013 at 5:00 am
A few other resources that might prove helpful. You can download the free e-book, Troubleshooting for the Accidental DBA[/url]. It covers a lot of what you're asking about. Also, take a look at the query tuning book in my signature. I also cover how to gather performance metrics.
"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
March 28, 2013 at 5:14 am
Thanks for our help....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply