SQL Newsgroups: Microsoft SQL Server Administration

IO Completion Listener Worker appears to be non-yielding on Node

Vishal - 31 Dec 2006 10:29 AM - 2 messages

I am getting this message in the event log "IO Completion Listener (0xe0c) Worker 0x00000000040601C0 appears to be non-yielding on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms, Interval: 15016." Soon after this, the sql server stops. ...

how is the cache broken up in SQL 2000?

Hassan - 31 Dec 2006 8:09 AM - 4 messages

I want to know how much of my buffer pool is being used for data and how much is consumed for procedure cache? Is there a way I can find out? ...

sessions vs connections

Hassan - 31 Dec 2006 7:13 AM - 5 messages

Whats the difference between sessions and connection in 2005 ? ...