SLA

With SQL Watchmen your company has its choice of three different remote DBA management packages to fit your budget as well as your needs. The following is a small sample of the basic maintenance tasks available for all three plans. This table shows most of the first page, but there are four pages in all. Contact us today for more information and book your FREE database Health Check if your company is in Central Texas. No-strings-attached.

Criteria

Silver

Gold

Platinum

Full Backup

SQL Server backup to .BAK file on disk. Customer responsible for moving .BAK file from disk to tape, or other location off-site.

Daily Daily Daily

Transaction Log Backup

Only available on database in Full or Bulk-Log Recovery modes. Backup to .TRN file on disk. Customer responsible for moving .TRN file from disk to tape, or other location off-site.

20 Minutes 20 Minutes 20 Minutes

Reindexing/Defragmenting Indexes and Data

Reorganizing data within SQL Server data files (.MDF and .NDF). If not possible to perform full reindexing daily, intelligence via proprietary code will rebuild ‘most fragmented’ indexes and data, as determined by SQLWatchmen, or the frequency may be changed to Weekly or another more infrequent schedule.

Daily Daily Daily

Update Column and Index Statistics

Update Statistics using a FULL SCAN where possible (100% data read) to produce most accurate results. However, if not possible for any reason, partial scan updating or updating only ‘hot tables’ statistics may be done as determined by SQLWatchmen, or the frequency may be changed to Weekly or another more infrequent schedule.

Daily Daily Daily

Integrity Check

Check database integrity and consistency for allocation errors, defects or any corruption or other problems with the physical database files and logical data.

Daily Daily Daily

Index Tuning Key Databases

Record activity during Customer work hours. Analyze workload, usually after hours and create indexes or statistics, also usually after hours to prevent impacting daily performance. A ‘key’ database is a primary database that is needed to perform a ‘significant’ amount of Customer work each day.

Monthly Monthly Monthly

Query Analysis and Tuning

Identify poorly performing queries or statements and analyze the syntax of the statement to come up with several possible alternatives. After hours – execute each alternative and track execution times, Disk IO, CPU, Memory and other metrics to identify if one of the alternatives is ‘better’ for the overall performance of the database system. A ‘better’ query is not necessarily one that runs faster. A query that is slightly slower, but uses less Disk IO to perform may be a better choice to improve the overall speed of the server; depending on if Disk IO is the current bottleneck in the server’s ability to service requests in a timely fashion. Each query usually takes several hours to tune and the results may not always yield a ‘better’ alternative.

1 Queries/mo. 2 Queries/qtr. 1 Query/qtr.

Blocking Monitor and Notification

Sample system looking for one process blocking other processes due to long running SQL statements, which applies locks and blocks users who are requesting resources with incompatible locks. If blocking is detected, the lead blocker is identified and their blocking statement is logged in a SQLWatchmen table as a future tuning candidate. Also, the blocker and all processes blocked are logged to a history table for future research or trend analysis.

Every 1 Minute Every 3 Minutes Every 5 Minutes

Capacity Analysis and Planning

Review collected data and look for future issues. Either react to analysis by extending database sizes, if there is enough disk space, or notify customer of need to adjust hardware before there is an issue.

Monthly Quarterly Not Included

High Priority

Issues disrupt normal operation of business and cause a ‘significant’ number of customer employees to be unable to perform their job duties to any degree.

15-30 minutes 95% of the time. 30-45 minutes 95% of the time. 45-60 minutes 95% of the time.

There’s More?

…with about three more pages of maintenance tasks for each package…

© 2001-2014 SQLWatchmen, LLC.

1766 FM 967, Suite A., Buda, TX 78610          (877) SQL-Watchmen