September 24, 2003 at 11:30 am
When I run sp_who2, the disk I/O value is 157369 for msde. Does it mean the Disk I/O is high? How to deal with it?
September 24, 2003 at 12:58 pm
That value is cumlative so may or may not be. If you just restarted your server it is, if has been several months then no. Use the Page Faults in Task Manger or PerfMon instead.
September 24, 2003 at 1:29 pm
Page Faults is the counter for Memory. I've checked the memory usage, it is OK.
September 24, 2003 at 7:33 pm
Hi there
I like to use the read and write queue length counters for each array (divide my disks in the array) when measuring IO, run this for some time though to get a realistic set of figures.
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 25, 2003 at 6:35 am
quote:
Page Faults is the counter for Memory. I've checked the memory usage, it is OK.
High page faults can point to a lot of swap file usage and thus higher HD IO.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply