Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Application locking during transactions
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00606258
Message ID:
00606316
Vues:
22
It sure sounds like a blocking issue. How are you checking for block connections? SEM? sp_lock? If you're using SEM, try sp_lock instead. You'll probably have to execute the proc a couple of times.

Try using Perfmon and the SQL Server:Lock Object. Look at the Average Wait Time counter.

Did you change the Isolation Level? Is the disk that contains the TLog healthy. When a command query executes, data is modified in SQL Server's cache but a record of those modifications is written to the disk. SQL Server will wait for the ACK from the IO subsystem before considering the query successful.

This is just stuff off the top of my head. These kinds of problems can be very difficult to track down.

Good luck!

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

Click here to load this message in the networking platform