Check the drives for hardware issues (all things being equal and unchanged).

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com


-----Original Message-----
From: Odedeyi, Yomi [mailto:Yomi.[Email Address Removed] Thursday, January 17, 2002 09:57
To: [Email Address Removed] RE: disk IO problems


Is there a stuck background process (e.g. backup) that is consuming I/O? Use
NT Performance Monitor and the SQL Server Profiler to pinpoint where the
bottleneck lies.

Yomi

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] Thursday, January 17, 2002 9:57 AM
To: [Email Address Removed] disk IO problems


Facts: Assume- no system changes, no sql or index changes, only 1 user
on system

A process which normally takes 3 hours to run is on it's 12th hour. The
only clue I have is the process has unusually low disk I/O.
Any ideas?


Kevin J. Sexton
Sr. Database Administrator

AdvanceMed Corporation
11710 Plaza America Drive
Reston, VA 20190-6017
http://www.eadvancemed.com



---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page