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