mystery background process?
Posted on 2007-09-28
I am running SQL Server 2005 Developer version 9.00.2050 on a test system. It's a busy little system with 18 databases living under one instance of SQL Server. frequently, when I am working/testing an app, etc, the system seems to grindd to incredibly slow speeds, even when there is nothing else running except SQL. A simple query takes 90 - 120 seconds, even in the Management Studio. I have up to date virus scanner and spyware running and I belive the system is "clean". I look at the windows task manager and see sqlsrvr running, doing something. The hard disk is getting pounded. I can fire up SQL Profiler, and it doesn''t show anything external to my tasks at hand. Yet, I know those tasks are absolutely not resource intense.
I suspect the Engine is doing some sort of background cleanup process. But I can't figure out what, or even how to look to see what irt may be doing. Any ideas what to look for? Any tools I can use to find the culprit?