Disk writes/sec value

I picked up the disk writes/sec for a particular physical
disk and noticed it shoot to 2800 at times..
What does that mean ? There are 2800 writes to that array
that may comprise of 6 disks or so..
Jamie,
Check out these for more details on the proper counters:
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
But what exactly is it your trying to determine? The best counter(s) to
view for an overall indication of how busy your disks are is the current
(and average) disk queues.
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a6401c45ecc$d9104d00$a301280a@.phx.gbl...
> I picked up the disk writes/sec for a particular physical
> disk and noticed it shoot to 2800 at times..
> What does that mean ? There are 2800 writes to that array
> that may comprise of 6 disks or so..

Disk writes/sec value

I picked up the disk writes/sec for a particular physical
disk and noticed it shoot to 2800 at times..
What does that mean ? There are 2800 writes to that array
that may comprise of 6 disks or so..Jamie,
Check out these for more details on the proper counters:
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
on_24u1.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
But what exactly is it your trying to determine? The best counter(s) to
view for an overall indication of how busy your disks are is the current
(and average) disk queues.
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a6401c45ecc$d9104d00$a301280a@.phx
.gbl...
> I picked up the disk writes/sec for a particular physical
> disk and noticed it shoot to 2800 at times..
> What does that mean ? There are 2800 writes to that array
> that may comprise of 6 disks or so..

Disk writes/sec value

I picked up the disk writes/sec for a particular physical
disk and noticed it shoot to 2800 at times..
What does that mean ? There are 2800 writes to that array
that may comprise of 6 disks or so..Jamie,
Check out these for more details on the proper counters:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
But what exactly is it your trying to determine? The best counter(s) to
view for an overall indication of how busy your disks are is the current
(and average) disk queues.
--
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a6401c45ecc$d9104d00$a301280a@.phx.gbl...
> I picked up the disk writes/sec for a particular physical
> disk and noticed it shoot to 2800 at times..
> What does that mean ? There are 2800 writes to that array
> that may comprise of 6 disks or so..sql

Disk Reads and writes

I have a performance issue and I'm trying to monitor it
using performance monitor. I came up with the following
disk info :
disk reads 1460
disk writes 193
What is causing the read operation to be so slow? I've
looked at the queries being run and they are fine with
good amount of indexes on the tables - but something must
be wrong somewhere on those disks or I don't know. Any
suggestions on what to look for? Thank you.
JohnYou said the indexes are fine, But have you checked the actual execution
plan of those queries, to make sure the indexes are being used optimally?
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:357d01c47ef9$2758bd20$a301280a@.phx.gbl...
> I have a performance issue and I'm trying to monitor it
> using performance monitor. I came up with the following
> disk info :
> disk reads 1460
> disk writes 193
> What is causing the read operation to be so slow? I've
> looked at the queries being run and they are fine with
> good amount of indexes on the tables - but something must
> be wrong somewhere on those disks or I don't know. Any
> suggestions on what to look for? Thank you.
> John
>
>|||Vyas,
thank you for the suggestion. I'm afraid I haven't done
that. Can you please suggest how? Thanks.
John
>--Original Message--
>You said the indexes are fine, But have you checked the
actual execution
>plan of those queries, to make sure the indexes are being
used optimally?
>--
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"John Bull" <anonymous@.discussions.microsoft.com> wrote
in message
>news:357d01c47ef9$2758bd20$a301280a@.phx.gbl...
>> I have a performance issue and I'm trying to monitor it
>> using performance monitor. I came up with the following
>> disk info :
>> disk reads 1460
>> disk writes 193
>> What is causing the read operation to be so slow? I've
>> looked at the queries being run and they are fine with
>> good amount of indexes on the tables - but something
must
>> be wrong somewhere on those disks or I don't know. Any
>> suggestions on what to look for? Thank you.
>> John
>>
>
>.
>|||enter the query in query analyzer and then click the button for "Estimated
execution plan"
look for table scans and index scans (they are bad) you want Index Seeks.
Greg Jackson
PDX, Oregon|||Start SQL Profiler, filter on queries making > 500000 reads (adjust as
required), and analyze the captured queries.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:3bef01c47f17$7583e510$a601280a@.phx.gbl...
> Vyas,
> thank you for the suggestion. I'm afraid I haven't done
> that. Can you please suggest how? Thanks.
> John
> >--Original Message--
> >You said the indexes are fine, But have you checked the
> actual execution
> >plan of those queries, to make sure the indexes are being
> used optimally?
> >--
> >Vyas, MVP (SQL Server)
> >http://vyaskn.tripod.com/
> >
> >
> >"John Bull" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:357d01c47ef9$2758bd20$a301280a@.phx.gbl...
> >> I have a performance issue and I'm trying to monitor it
> >> using performance monitor. I came up with the following
> >> disk info :
> >> disk reads 1460
> >> disk writes 193
> >>
> >> What is causing the read operation to be so slow? I've
> >> looked at the queries being run and they are fine with
> >> good amount of indexes on the tables - but something
> must
> >> be wrong somewhere on those disks or I don't know. Any
> >> suggestions on what to look for? Thank you.
> >> John
> >>
> >>
> >>
> >
> >
> >.
> >

Disk Reads and writes

I have a performance issue and I'm trying to monitor it
using performance monitor. I came up with the following
disk info :
disk reads 1460
disk writes 193
What is causing the read operation to be so slow? I've
looked at the queries being run and they are fine with
good amount of indexes on the tables - but something must
be wrong somewhere on those disks or I don't know. Any
suggestions on what to look for? Thank you.
John
You said the indexes are fine, But have you checked the actual execution
plan of those queries, to make sure the indexes are being used optimally?
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:357d01c47ef9$2758bd20$a301280a@.phx.gbl...
> I have a performance issue and I'm trying to monitor it
> using performance monitor. I came up with the following
> disk info :
> disk reads 1460
> disk writes 193
> What is causing the read operation to be so slow? I've
> looked at the queries being run and they are fine with
> good amount of indexes on the tables - but something must
> be wrong somewhere on those disks or I don't know. Any
> suggestions on what to look for? Thank you.
> John
>
>
|||Vyas,
thank you for the suggestion. I'm afraid I haven't done
that. Can you please suggest how? Thanks.
John

>--Original Message--
>You said the indexes are fine, But have you checked the
actual execution
>plan of those queries, to make sure the indexes are being
used optimally?
>--
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"John Bull" <anonymous@.discussions.microsoft.com> wrote
in message[vbcol=seagreen]
>news:357d01c47ef9$2758bd20$a301280a@.phx.gbl...
must
>
>.
>
|||enter the query in query analyzer and then click the button for "Estimated
execution plan"
look for table scans and index scans (they are bad) you want Index Seeks.
Greg Jackson
PDX, Oregon
|||Start SQL Profiler, filter on queries making > 500000 reads (adjust as
required), and analyze the captured queries.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:3bef01c47f17$7583e510$a601280a@.phx.gbl...[vbcol=seagreen]
> Vyas,
> thank you for the suggestion. I'm afraid I haven't done
> that. Can you please suggest how? Thanks.
> John
> actual execution
> used optimally?
> in message
> must
sql

Disk Reads and writes

I have a performance issue and I'm trying to monitor it
using performance monitor. I came up with the following
disk info :
disk reads 1460
disk writes 193
What is causing the read operation to be so slow? I've
looked at the queries being run and they are fine with
good amount of indexes on the tables - but something must
be wrong somewhere on those disks or I don't know. Any
suggestions on what to look for? Thank you.
JohnYou said the indexes are fine, But have you checked the actual execution
plan of those queries, to make sure the indexes are being used optimally?
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:357d01c47ef9$2758bd20$a301280a@.phx.gbl...
> I have a performance issue and I'm trying to monitor it
> using performance monitor. I came up with the following
> disk info :
> disk reads 1460
> disk writes 193
> What is causing the read operation to be so slow? I've
> looked at the queries being run and they are fine with
> good amount of indexes on the tables - but something must
> be wrong somewhere on those disks or I don't know. Any
> suggestions on what to look for? Thank you.
> John
>
>|||Vyas,
thank you for the suggestion. I'm afraid I haven't done
that. Can you please suggest how? Thanks.
John

>--Original Message--
>You said the indexes are fine, But have you checked the
actual execution
>plan of those queries, to make sure the indexes are being
used optimally?
>--
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>
>"John Bull" <anonymous@.discussions.microsoft.com> wrote
in message
>news:357d01c47ef9$2758bd20$a301280a@.phx.gbl...
must[vbcol=seagreen]
>
>.
>|||enter the query in query analyzer and then click the button for "Estimated
execution plan"
look for table scans and index scans (they are bad) you want Index Seeks.
Greg Jackson
PDX, Oregon|||Start SQL Profiler, filter on queries making > 500000 reads (adjust as
required), and analyze the captured queries.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"John Bull" <anonymous@.discussions.microsoft.com> wrote in message
news:3bef01c47f17$7583e510$a601280a@.phx.gbl...[vbcol=seagreen]
> Vyas,
> thank you for the suggestion. I'm afraid I haven't done
> that. Can you please suggest how? Thanks.
> John
>
> actual execution
> used optimally?
> in message
> must