Avg Disk Queue Length at 100% in Graph view

December 28, 2007

We are trying to run a report from an application. The database is sitting on

a different server (SQL Server 2000), we see that the Ave. Disk Queue Length

is shooting up to 100%. Not sure whether this could be SQL Server issue or

the Windows Server issue. Any help would be appreciated.

thanks in advance.

December 28, 2007

Re: Avg Disk Queue Length at 100% in Graph view

In article <27C25FC8-2B97-4EA1-8314-27AF3B0AC030@microsoft.com>,

> We are trying to run a report from an application. The database is sitting on

> a different server (SQL Server 2000), we see that the Ave. Disk Queue Length

> is shooting up to 100%. Not sure whether this could be SQL Server issue or

> the Windows Server issue. Any help would be appreciated.

>

> thanks in advance.

There is no 100% value that means anything - what is the actual DISK

QUEUE AVG Count on the C drive, then the D drive, and since this is a

database, you would also have a E drive?

How many disks in the arrays for C, D, E?

What SQL maintenance are you doing weekly?

What does the application do with the server, other than pull data from

the SQL database?

What type of data?

--

Leythos

- Igitur qui desiderat pacem, praeparet bellum.

- Calling an illegal alien an "undocumented worker" is like calling a

drug dealer an "unlicensed pharmacist"

spam999free@rrohio.com (remove 999 for proper email address)

Recommended Posts