Posted by: Colin Smith
DBA, Monitoring, Powershell
A while back, about a year ago, I wrote some custom scripts to monitor all of our SQL Server instances for errors. I have a driver file that has all the information that the script needs in order to find errors on the SQL Servers and it just walks thru them and checks for any errors that I might care about. If it finds an error it sends out a page to the on-call DBA and also sends emails out to the DBA team about the error found. I also wrote a script called workit, because we are working the issue, that when run, will output the errors found on all servers that have errors. This script has many functions to aid in resolving any issues that are found and also stops the emails and paging about the error. Everything really works well, but I was watching a training video done by Buck Woody(blog | twitter) and he had an example of using the .net windows.forms assembly. That got me thinking that I could wrap my workit script into a GUI. I went out and found a quick basic tutorial on using the forms assembly and now I am hard at work building a gui around my scripts. This will allow me to let others, that are not so savvy with command line, to run this script and help us to resolve issues. This should be a fun project so I will keep you up to date on my progress. I love powershell because I can always find something useful and fun to do with it.