Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to decrease same SPID With Multiple ECID
Message
 
 
À
30/09/2009 13:03:01
Stanley Yip
Shun Sang (technology) ltd Hong Kong
Hong Kong, Hong Kong
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01426798
Message ID:
01427087
Vues:
55
>Actually my company sometime the sql server run out of resource and become slowly . Then my head will said those query with Multiple ECIDs must kill the process and it must be the reason of make the sql sever out of resource and become slowly. By your answer is it mean that Multiple ECIDs is usually happen. for those query with Multiple ECIDs dose not mean those query not optimize. IF a query with single ECID if not optimize also will make the sql server run out of resource and become slowly. Am I correct ?

Yes unoptimized queries can severely affect SQL Server performance.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform