Post reply

Background Processes

  • November 27, 2006 at 12:56 am

    #69159

    Can anyone tell me what the SPID 5 and SPID 8 does? Everytime I check sp_who output, I always found "Task Manager" written in the command column, and whenever I use DBCC INPUTBUFFER(5) or DBCC INPUTBUFFER(8), I found these processses not handling any event.

    Thanks in advance.

    Pankaj Khanna
    Database Administrator - SQL Server 2000

    Keep hope to keep you intact...

  • November 27, 2006 at 8:02 am

    #674069

    I'm not completely sure, but they're likely background processes that SQL uses. Does it matter? Or are you having some problem? I have a number on my system and they're not using any CPUTime, so I've never worried about them.

  • November 27, 2006 at 5:50 pm

    #674202

    Hi Steve,

    In our production systems, whenever a process keeps on utilizing the CPU, physical IO and/or memory to above a threshold limit, the SQL Server is configured to raise an alert. I oftely get an alert on excessive usage of physical IO or memory from SPID 5 and/or 8. I checked all the Jobs configured. The time of alert never matches with any of the Job schedules. Also, the Event Log or SQL Server Log do not have any suspicious entry around the time of alerts

    Can you guess something?

    Thanks in advance

    Pankaj Khanna
    Database Administrator - SQL Server 2000

    Keep hope to keep you intact...

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

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