The Multifunctioning DBA

Oct 28 2010   11:00PM GMT

SQL Server Monitoring

Colin Smith Colin Smith Profile: Colin Smith

I am getting back into writing my monitoring application in powershell and I have made some progress over the last few days. I have figured out my issue with getting the backup dates and times inserted into my monitoring database and also not entering the information multiple times if I already have an entry for that day for the full backup if the database is using the simple recovery model.

Then I wanted to develop a new script that would allow me to add a new instance to monitoring very quick and easy. It took me about 40 lines of ode but man it really does work great. The script will ask for some simple inputs like hostname, instance name, do you want to monitor it, who is the Customer, Test or Prod Instance, so really everything in the monitor and instance tables. Then it goes and inserts the data in the appropriate tables and also gets the instance identifier from the instances table before inserting it into the monitor table.

Getting ready to put this in place with the basic functionality and then add features as I go.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: