Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

background threads Expand / Collapse
Author
Message
Posted Saturday, August 27, 2011 10:08 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 1:13 PM
Points: 774, Visits: 1,734
Hi,

This question is regarding the sql server background threads.

Can anyone provide me the documentation on sql server background threads and what does each thread does?

checkpt and lazy writer writes to mdf but which thread is responsible for writing to LDF using WAL protocol?

Thats why i wanted to know the functionality of each system thread and they do in the background.

1 RESOURCE MONITOR 2776
2 XE TIMER 2908
3 XE DISPATCHER 2416
4 LAZY WRITER 1316
5 LOG WRITER 2404
6 LOCK MONITOR 1592
7 SIGNAL HANDLER 1516
9 TRACE QUEUE TASK 1544
11 TASK MANAGER 1524
13 CHECKPOINT 1520
14 BRKR EVENT HNDLR 1556
15 BRKR TASK 1552

Thanks in Advance.

Post #1166648
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse