I have a SQL server 2000 setup.
When freshly booted it all works very well. But when I work on it for 30
minutes running some small SQL scripts (very basic, nothing fancy) and I
also use the EM the trouble starts. First the EM hangs, ... if I kill the
EM, reconnection gives time outs. When finally I can connect I can't work
with it properly anymore (it hangs!) on the client machine. The EM on the
server itself works at a snail pace and the kill proces command doesn't even
seem to work very well anymore .... Also logging in takes for ever or times
This is very anoying. I have SP1 on both server and on my workstations
client tools. Server is W2K SERVER + SP2 and workstation is W2K PRO + SP2
The QA on the client works but perfomance drops somewhat ...
I see nothing in the logs, event viewer,