Crisis/ Outage Message !!!

[astra1]

Hi
We are working on SQL Server 2k and I want to monitor the server round the clock... major issue we wanna deal is the server space... the requirement is to monitor server performance, ie whenever there is some outage (like low memory, table truncation etc), I want to get an SMS on the cell... don’t even know whether this is possible??
Can any one help me out on the same!!!!

Vish

 

[NoCoolHandle]

Vish,

in the wonderfull world of Windows, you don't need to monitor these things on the local server You can do it across the network using Performance Monitor. PM can be used to raise alerts, capture workloads for later analysis etc. It has the ablility to look at disk space avalilble, you have sql counters that provide insight into cache usage, worker threads queued, and much more..

Re table truncation... No, this is something you need to look at using other tricks. The key one here would be SQL Profiler. You can use this one to monitor specific db,s and then look at specific statements like "truncate". these could be filterd for, or you could do a mega dump of everyting. One cool option of profiler is that it will let save the "trace" to a table for later analysis. You would then open the table and query it with you normal sql tools.

Bottom line is you can look at all these things. You also have the ability to create custom stored procs in the master database that return values you choose. THese can then be trapped and returned to performance monitor.

HTH


Rob

 

[chiph]

You may also want to look at a tool like MOM (Microsoft Operations Manager)

http://www.microsoft.com/MOM/default.asp

Or look at something like CA UniCenter

http://www3.ca.com/Solutions/Solution.asp?ID=4643

Or something like NetIQ

http://www.netiq.com/solutions/windows/default.asp

Chip H.