View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 08:25 AM
Michael
 
Posts: n/a
Default Process Info (SQL Server Enterprise - Management - Current Activity)

Dear All

I have problem with my database server which running SQL server 2000.
The server running very slow. The worst case, to save a record required
more than 20-30 seconds.
Since this problem, I usually monitoring Process Info from Enterprise
Manager (Management - Current Activity), and I found a misterious
process as follow :

1. User : System
AccessTo : Master
Status : Background
Common : Task Manager
Waiting : >438 Million

2. User : System
AccessTo : Master
Status : Background
Common : Task Manager
Physical IO : > 51000

3. User : Administrator (Join domain)
Database : MSDB
Status : Sleeping
Common : Awaiting Command
App : SQL Agent Alert Engine
CPU Usage : > 16 Million

Anybody know about these condition? Does it normal?

Thanks

Michael

Reply With Quote