Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange Performance Issues
Message
De
12/04/2002 12:32:35
 
 
À
12/04/2002 10:20:49
Kenneth Downs
Secure Data Software, Inc.
New York, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00643932
Message ID:
00644395
Vues:
23
The three counters that I provided are the basics for the three main components on the computer: processor, memory, and disk. Disk Queue Length is a measure of the number of IO requests that are required but not yet handled by the IO subsystem. I've seen remarks that anything above 2 signifies a bottleneck in the disk IO subsystem.

If the Interrupts/Sec is really high, there may be a component of the system that is defective and causing a lot of interrupts which distracts the processor(s) from SQL Server.

Unfortunately, in a situation like this, you have to start very wide and narrow the search once you start getting some information.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform