Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-10 : 09:51:03
|
| Sushant writes "When I run sp_who2, it shows me following process with a heavy CPU Time. but in other servers it is not showing. if i kill this process it again comes. What this process is? Is it a performance overhead? If it is how should i omit it? What does it do?Login Database CPU Time Program Name----------------------------------------------------------------NT AUTHORITY\SYSTEM msdb 161322013 SQLAgent - Alert Engine" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-02-10 : 09:52:16
|
| It's SQL Agent, and you should not kill it (it will automatically restart anyway). If you're seeing heavy usage then it could be running a job that uses excessive resources. Look at the jobs that are running and stop them if necessary, you don't have to stop SQL Agent entirely. |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-02-10 : 10:17:45
|
| What is the login_time of the process. It has most likely been up as long as the server. Check the CPU number from day to day, and see how much it is growing. |
|
|
|
|
|
|
CPU Time of SQLAgent - Alert Engine in SP_WHO2