what are the differenet background processes in ms-sql server

  • help me

     

    can say some of the background processes in sql server

  • The checkpoint, the log writer, QSL agent might be running. Is there some reason you want to know? Books online probably has a list.

  • When one looks at all your questions today, one might be inclined to say, it's a good idea for you to get a copy of Ken Henderson's Guru's Guide to SQL Server internals. Search the site here, Antares686 did a review of this book.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • I agree, that book will probably be the best resource for the questions you are asking. But as far as background process there really aren't truely any. Within SQL there are many threads and many task performed by those threads. SQL Server is the process itself. But Widnows looks at many of the running services as background process as they have no client screen for the process itself in most of those cases so they are in the "background".

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

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