MS SQL Server - System Proces issues "RESOURCE MONITOR" command and blocks a proce

Author

System Proces issues "RESOURCE MONITOR" command and blocks a proce

Rich Wood

2006-03-27, 8:23 pm

I have a process which is getting blocked by a System proces. The only
information I have about the system process (from the Activity Monitor) is
the Command field which is "RESOURCE MONITOR". I've looked up "resource
monitor" in books on-line and it says something about clustered servers. I
don't have a server cluster.

This server is severely underutilized -- the sql server is currently using
less than 1 GB of 10 GB available to SQL server. While the blocked process is
running, the total CPU utilization is at ~20%.

Any insight would be appreciated.

Thanks

Steven Cheng[MSFT]

2006-03-28, 3:23 am

Hi RichWood,

Thank you for posting.

Regarding on the process blocking issue, I think the "RESOURCE MONITOR" is
a internal command/operation identity instead of a system tool or process's
name. So if there does exists block, it is likely the SQL server system
process is monitoring some certain resource which cause the blocking. Is
your process (the blocked process ) accessing any resource that will also
be monitored by SQL server? Also, would you also post the full info
returned by the following query from SQLserver's sysprocesses view:

select * from master.sys.sysprocesses

If there's anything else we missed, please feel free to post here.

Regards,

Steven Cheng
Microsoft Online Community Support

====================
====================
==========

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

====================
====================
==========

This posting is provided "AS IS" with no warranties, and confers no rights.

Sponsored Links