-
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?
-
It is normal.
BTW. when did you recycle your box recently?
-
About 10 days ago.
We're also looking into redoing the indexes on a more regular basis. We do alot of inserts and updates(At least 10,000 to 20,000 inserts a day). What time frame would you say we should re index the tables?
-
Do the reindexing during off hours. first try it on a sat and sun and see how long does it takes, then schedule it.
-
Sorry, I should have worded it better. Do you think we should do it weekly? Daily? I've really havn't read any good articles or docs. giving a good idea on frequency of the reindexes...
-
I would recommend Daily for such amount of transactions.
-
Sounds good. Thank you for the great advice.
-
remember. run update stats or do using maintenance plan.
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
|
|