Post reply

sysprocesses question

  • October 22, 2003 at 11:36 am

    #82452

    Often, when I'm doing a "select * from sysprocesses order by cpu desc", I will see a background process that is using alot of CPU. The cmd column contains TASK MANAGER. I've looked around, and haven't found any documentation describing what the TASK MANAGER background process in SQL Server is. (As opposed to the Windows Task Manager application, which I know it is not.) Can anyone out there enlighten me?

    Thanks!

  • October 22, 2003 at 10:36 pm

    #479211

    Take a look at "SQL Server Task Scheduling" in Books Online.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • October 23, 2003 at 9:18 am

    #479321

    Thanks. I looked all over BOL, but didn't come across this. Since we don't run in fiber mode, it would imply that firing up a worker thread on behalf of a SPID/connection is momentarily a very CPU-intensive operation. Interesting.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply