Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Monitoring, powershell Rss

   Items 1 to 6 of 6   
 

Working with SQL Agent Durations

SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.  Read more...
By Kyle Neier 2012/08/23 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,773 reads

Perform Routine Server Checks Using PowerShell

Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.  Read more...
By Additional Articles 2012/05/21 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 3,557 reads

Automating Daily Checks with Powershell

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...
By Warren Campbell 2011/12/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 10,555 reads

Create a Monitoring Server for SQL Server with PowerShell

At some point you are going to need a notification system for a range of events that occur in your servers. Laerte Junior shows how you can even set up temporary or permanent alerts for any WMI events to give you a system that fits your server environment perfectly.  Read more...
By Additional Articles 2011/11/09 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,793 reads

Disk Space Monitoring and Early Warning with PowerShell

Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.  Read more...
By Additional Articles 2011/09/12 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,456 reads

Monitoring SQL Server Agent with Powershell

This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.  Read more...
By Additional Articles 2009/03/31 | Source: SQLTeam.com | Category: sql agent
Rating: (not yet rated)  Rate this |   Briefcase | 2,455 reads
   Items 1 to 6 of 6   
 
Tags
administration (2)    
sql agent (2)    
backup / restore (1)    
errorlogs (1)