-
Strange Pauses , Cured by Trace ????
I have this strange problem (SQL Related), that I have a few processes trying to use SQL server 6.5 at the same time ...fine
But performance seems to grind to a halt for minutes at a time where nothing is happening.
sysprocesses - shows no cpu usage on any process, or the Task manager in NT shows 99% idle
If I run SQL Trace this problem is rectified straight away and the processes fly along. If I then pause the SQL trace the processes grind to a halt again.
There is no processes blockedLocked. What could possibly be causing this?
Thanks
Noelle
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|