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.
| Author |
Topic |
|
monty
Posting Yak Master
130 Posts |
 Posted - 2006-11-16 : 02:22:32
|
Hi All,iam aware of various performance counters related to sql server what iam trying to look for is like any articles or links on performance counters which will give an in depth details, also i want to know if any one of you log the counter values? if yes do you you stick to any threshold limits?also can any one tell me any globally accepted threshold limits for various countersall your comments wld be apprecieated... thanks in advanceits me monty |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-16 : 02:36:58
|
| Here is good 4 part article series to start with:[url]http://www.sql-server-performance.com/performance_monitoring_tutor_part1.asp[/url]Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-16 : 04:52:17
|
| "i want to know if any one of you log the counter values?"I log, once a minute, the counters that are exposed through master..sysperfinfo plus @@cpu_busy, and we use this to evaluate how they change over time.For example, we have a client building to their busiest period of the year and their CPU usage is 3x what it was last year, but for the same number of customers. User changes to data have bloated all sorts of things, and we are now having to optimize the client's data.We also the use @@cpu_busy, 'Transactions/sec' and 'User Connections' figures to check if, for a given minute interval, the activity is "too hot" and if so the website stops accepting new sessions - so people already in the store can "finish up" more easily.We also log the elapsed time for our SProcs, and have them recompile if their execution time slows.Kristen |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-11-16 : 22:52:10
|
| thanks alot,harsh and Kristenthe information provided is really helpful..its me monty |
|
|
|
|
|
|
|
|
Performance counters