Does anyone know what are the best statistics to watch in the nt Perf mon.
to tell if SQL is being bogged down by resources?
I have found this site helpful - sorry it will wrap and you'll have to cut
Quote:> Does anyone know what are the best statistics to watch in the nt Perf mon.
> to tell if SQL is being bogged down by resources?
I'm saving some performance data to a binary log to view over time and
compare to a SQL Profiler Trace. When I view the logs in the System Monitor
as View Chart, the graph looks like a stock mkt ticker with the high & low
for that specific point in time. Is there a way to turn off the high & low
so that I get just the single line? If I want to look at several counters
at the same time looking for a correlation, the high & low marks just junk
up the graph. (It may be that these lines are normal, but I'd like to turn
I'm using a 1 second interval. If I run the trace for about one minute, the
high & low lines are not there, much longer than that and the graph has it.