Hi,
I was asked to test an SQL Server to see if it needs a hardware upgrade. I
run performance monitor and added some counters that I had read in books. My
problem is that the books only mention good counters, but they don't tell
what the good values are!
I would be most grateful if you can write some counters with acceptable
ranges to check:
Disk, Memory and CPU.
I have to decide about the current configuration of this production server.
I need criteria!
Thanks in advance.
Leila
Check out the web site http://www.sql-server-performance.com/
Look down toward the bottom of the page where the sorted list of topics. The
numbers are in the articles PerformanceMonitor Counters()
Two books that have these values are:
SQL Server Performance Tuning Distilled by Sanjay Dam
Start to Finish Guide to SQL Server Performance Monitoring by Brian Kelly
which is an eBook available at http://www.netimpress.com/
"Leila" wrote:
> Hi,
> I was asked to test an SQL Server to see if it needs a hardware upgrade. I
> run performance monitor and added some counters that I had read in books. My
> problem is that the books only mention good counters, but they don't tell
> what the good values are!
> I would be most grateful if you can write some counters with acceptable
> ranges to check:
> Disk, Memory and CPU.
> I have to decide about the current configuration of this production server.
> I need criteria!
> Thanks in advance.
> Leila
>
>
No comments:
Post a Comment