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 BackupSQL 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 BackupOnly 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 DataReorganizing 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 StatisticsUpdate 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 CheckCheck 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 DatabasesRecord 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 TuningIdentify 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 NotificationSample 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 PlanningReview 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 PriorityIssues 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… |
|||
