Sunday, February 19, 2012

Bench Mark on Performance

Hi
I'm looking quite heavily at SQL Server Profiler (2000 sp3a).
I understand that the profiler looks at the logical reads and physical
writes.
What I'm trying to understand is what people use as a guide as to
whether something should be dedicated or if it could be shared on an
active/passive clustered environment.
If I'm recieving a million reads per hour, they are logical, hence in
the buffer cache, but does that mean the server is performing well? I
know that it's not always down to just read and writes but that is the
essence of a db system... so that's where I start.
Your thoughts would be most appreciated.
Simon
Hi
I'd also look at Performance Monitor to examine PhysicalDisk Object: Avg.
Disk Queue Length
http://www.sql-server-performance.co...ounters_io.asp
Per a query you can use SET STATISTICS IO command
When looking at individual queries ,the Logical Reads is more interesting
because the ibfo is consistent
Pay close attention as well to chache-hit ratio. (>=98%)
<simonaarons@.yahoo.co.uk> wrote in message
news:1129024856.929599.263150@.o13g2000cwo.googlegr oups.com...
> Hi
> I'm looking quite heavily at SQL Server Profiler (2000 sp3a).
> I understand that the profiler looks at the logical reads and physical
> writes.
> What I'm trying to understand is what people use as a guide as to
> whether something should be dedicated or if it could be shared on an
> active/passive clustered environment.
> If I'm recieving a million reads per hour, they are logical, hence in
> the buffer cache, but does that mean the server is performing well? I
> know that it's not always down to just read and writes but that is the
> essence of a db system... so that's where I start.
> Your thoughts would be most appreciated.
> Simon
>
|||Simon,
This is where a benchmark for your system would help. This would provide
you with how the system operates during normal operations. The performance
values derived from the benchmark can be compared against over time to
establish changes in the environment and to proactively predict future HW
upgrades/additions.
HTH
Jerry
<simonaarons@.yahoo.co.uk> wrote in message
news:1129024856.929599.263150@.o13g2000cwo.googlegr oups.com...
> Hi
> I'm looking quite heavily at SQL Server Profiler (2000 sp3a).
> I understand that the profiler looks at the logical reads and physical
> writes.
> What I'm trying to understand is what people use as a guide as to
> whether something should be dedicated or if it could be shared on an
> active/passive clustered environment.
> If I'm recieving a million reads per hour, they are logical, hence in
> the buffer cache, but does that mean the server is performing well? I
> know that it's not always down to just read and writes but that is the
> essence of a db system... so that's where I start.
> Your thoughts would be most appreciated.
> Simon
>

No comments:

Post a Comment