monitoring sql server through vb .net

  • Thread starter Thread starter Bernie Yaeger
  • Start date Start date
B

Bernie Yaeger

I've developed and am deploying a very important enterprise wide app for a
client. This app controls virtually everything the client does, and has
been thoroughly tested. However, I am a bit concerned about sql server
2000.

I noticed just the other day - still testing - that the server, when opened
in EM, said 'suspect'. I had been doing some fooling around and I know what
caused it. But my concern is, how can I monitor the server for this or
other failures to be able to react quickly - with a backup when necessary -
whenever something serious occurs? Is there a way, either inside vb .net or
by other means of continually polling the server for its health?

(I've cross posted on sqlserver ng also.)

Thanks for any recommendations.

Regards,

Bernie Yaeger
 
Look up SQL DMO in MSDN - it's a com dll for monitoring/controlling SQL
server services, configuration and security settings.
_______________________________
The Grim Reaper
 
Hi,

Tx for the advice.

Bernie
The Grim Reaper said:
Look up SQL DMO in MSDN - it's a com dll for monitoring/controlling SQL
server services, configuration and security settings.
_______________________________
The Grim Reaper

..net
Click to expand...
 
Back
Top