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 - 2003-02-18 : 23:51:28
|
| writes "i want to give an alert as soon as the cpu reaches 40% utilization how to do that" |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-02-19 : 02:05:49
|
quote:
writes "i want to give an alert as soon as the cpu reaches 40% utilization how to do that"
You can use slq alerts but there is no such alert like the one u have mentioned ,I think u will have to write a customized alert.I don't know whethere there is a thing like customised alerts.Regards,Harshal.Expect the UnExpected |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-02-19 : 11:17:44
|
| You'll probably need to write a service to do that.I think that .Net has a LOT of Perf Mon stuff in it, that would make it fairly easy to write.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-19 : 12:37:23
|
| You can do this in the System Monitor (or Performance Monitor on NT 4.0). Just take a look at the alerts in the System Monitor. From there, you should be able to figure out how to do it. It's actually very simple. Let me know if you need help.BTW, 40% utilization isn't very much CPU usage. Servers don't usually become sluggish until about 75% or above. |
|
|
|
|
|
|
CPU usage