October 28, 2010 11:00 PM
Posted by: Colin Smith
Database Monitoring,
Monitoring,
Powershell,
ScriptingI 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...
May 27, 2010 10:00 AM
Posted by: Colin Smith
DBA,
Monitoring,
PowershellA 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...
July 24, 2009 3:47 PM
Posted by: Colin Smith
Database Administration,
DBA,
Education,
Monitoring,
Perl,
ScriptingMy team is going to be developing a new application that will handle all of our monitoring. Currently that includes the monitoring of Sybase Servers, Oracle Instances, and MSSQL Servers. We will also be adding another Database Type that will house all of the Monitoring data. We will be using a...
June 25, 2009 9:24 PM
Posted by: Colin Smith
Excel,
Monitoring,
MSSQL,
Powershell,
SQL ServerOK so I think that I have everything I want in my script to check on the health of my SQL Servers. I will run this at least once a day and more if needed. I hope that this will help some people out and if you have any questions, comments, or ideas of what else might be good to include please let me...
June 25, 2009 3:30 PM
Posted by: Colin Smith
Microsoft,
Monitoring,
MSSQL,
Powershell,
Reporting,
SQL ServerYesterday I posted about a great article that I found on how to use Powershell to create an excel file and also use SMO to get information about SQL Server. I am working on a report that I will have run daily. This report is going to give me an overall health check of my SQL Servers. I am going to...
April 30, 2009 9:15 PM
Posted by: Colin Smith
Database,
Database Administration,
Monitoring,
Ping,
Powershell,
SQL Server,
System AdministrationEarlier this month I posted about SQL Ping Servers Script that I was working on to notify different groups if a server was down or just SQL Server was down or just the agent was down. Well here is the next part....
April 24, 2009 4:15 PM
Posted by: Colin Smith
Database Administration,
DBA,
Monitoring,
Powershell,
SQL Server,
Windows AdministrationNot long ago I did a post about pinging the interface of a server since you may encounter a problem connecting to WMI even if a server is up. The article is at
April 7, 2009 5:14 PM
Posted by: Colin Smith
Database Administration,
DBA,
Monitoring,
Powershell,
Windows AdministrationI have a script that goes out and pings all of my SQL Servers. This script, right now, simply makes a connection to the SQL Server instance. If I am able to connect I call it good and if not I send out notifications saying that the SQL Server is down. I found that more often than not I was getting...
