Our client has two SQL 2K Clustered servers (Srv_A and Srv_B), each running a different application. The applications interact with each other. SQL locks appear intermitently on Srv_B. These locks sometimes clear by themselves, or only after the user logs out of the application. They seem to appear about times of most use. Also, they seem to occur when a request is sent from Srv_A to read data (via Views) on Srv_B. This data is believed to be in the 1-2Mb range when extracted via Query Analyser. CPU usage peaks high, memory usage is constant, about 55%. Have any TechTippers any ideas on what to look for?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locks in SQL server 2k advanced server
- Thread starter grimwyre
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question