The Multifunctioning DBA

Oct 28 2010   11:00PM GMT

SQL Server Monitoring



Posted by: Colin Smith
Tags:
Database Monitoring
Monitoring
Powershell
Scripting

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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: