-
Question about SQLAgent - Alert Engine
Just today we were seeing out SQL Server(2k) staying between 95% and 100% CPU utilization. So I ran the following query:
select hostname, program_name, loginame, cpu, physical_io, memusage,
status
from master.<name>.sysprocesses
order by cpu desc
and the SQLAgent - Alert Engine CPU was running at 611100, physical io at 28 and memory usage at 0. Is this normal for the Alert Engine to be the hardest on the CPU?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|