Monitoring Details

SQLCare remote DBA services consists of:

    24/7 On Failure
SQL Care Alert
On Failure
Client Alert
 
    Frequency Emailed Pages Record Emailed Phone Action
  Server Connectivity 3 Min. x x   x x Call Client
DATABASE STATUS
  Marked Suspect 18 Min. x x   x x Attempt repair
  Marked Emergency Mode 18 Min. x x   x x Attempt repair
  Is Offline 18 Min. x x   x x Attempt repair
  Recovering 18 Min. x     x   Email Client
  Loading 18 Min. x     x   Email Client
DATA
  Data Corruption 3 Hours x     x x Attempt repair
  Index Corruption 3 Hours x     x x Attempt repair
DATABASE
  Fragmentation Daily x     x x Defrag weekly
  Transaction Log Full 12 Min. x x   x x Shrink Log
  Transaction Log Size 12 Min. x          
  Backup Alerts 2 Days x     x   Backup Database
  Backup Verification Daily x          
  Tables without Indexes Weekly x     x    
SQL SERVER
  Error Log File 90 Min. x   x x   Attempt repair, notify Client
  Job Failed 20 Min. x   x x   Attempt repair, notify Client
  Jobs Running Over 1 Hour 45 Min. x   x x   Attempt repair, notify Client
  Security Violation 90 Min. x   x x   Notify Client
  Database Space Utilization 90 Min. x   x     Notify Client
  Recycle Error Log Weekly            
PROCESSES
  Blocking over (1/2 seconds) 1 Min. x   x *   Notify Client
  Blocking Over 3 minutes 2 Min. x x x x   Notify Client
  Queries Running Over 1 Minute 4 Min. x   x *   Notify Client
  Queries Running Over 90 Minutes 75 Min. x   x x   Notify Client
  Dead Locks (new) 90 Min. x     x   Notify Client
OS
  Memory Less Than 80% 5 Min. x   x x   Notify Client
  Disk IO Over 70% 5 Min. x   x x   Notify Client
  Disk Queuing Over 20 5 Min. x   x x   Notify Client
  CPU Utilization Over 80% 5 Min. x   x x   Notify Client
  Disk Drive Below 2GB 35 Min. x x x x   Notify Client
  Disk Drive Below 500 MB 10 Min. x x x x x Notify Client
SCRIPTING
  All Databases Weekly x          
  Logins and Encrypted Passwords Weekly x          
  *=Upon request