SolidQ SQL Server Health Check Service

SolidQ SQL Server Health Check

 
SolidQ SQL Server Health Check service reveals the causes of problems—not just the symptoms—enabling you to shift from reactive troubleshooting to proactive maintenance.
 
 
 
SolidQ SQL Server Health Check service will help you:
 
  • Achieve the optimal configuration of your SQL Server environment so that the resources of your system are used efficiently.
  • Develop strategies for maintenance and scalability
  • Avoid unnecessary hardware expansion costs. Know exactly what aspects are limiting the SQL Server performance of each server and the most cost effective way to reduce or eliminate bottlenecks.
  • Detect the exact T-SQL query patterns that are affecting the SQL Server performance
 
 
 
 
 
SolidQ SQL Server Health Check is considered:
 
  • SQL Server Health Check
  • SQL Server Tuning Tool
  • SQL Server Performance Tool
  • SQL Server Monitoring Tool
  • SQL Server Mentoring Service
  • SQL Server Consulting Service
  • SQL Server Scalability Tool
  • SQL Server Support Tool
 
 
 
 
 

SQL Server Monitoring Tool

 
The SQL Server Health Check service combines two essential elements:
 
  • Automate your SQL Server Monitoring: fully tested in the field and error free
  • SolidQ team are SQL Server experts and will customize the service to your needs and help you interpret the measurements and conclusions and establish a prioritized action plan
 

 

 

For more information about SQL Server Heath Check and a sample document, contact us at info@solidq.com

 
 
 
 
 

Appendix: Information for Technical Staff responsible for validating the analysis of the Health Check service

The SQL Server Health Check service analyzes the following SQL Server and Windows Server components:

Component: Server and Hardware
 
  • Supported Windows 2000, 2003, 2008 and 2008R2
  • Windows and SQL Server version including its configuration parameters
  • Efficiency and appropriate configuration of memory management
        • Efficiency and configuration of the storage system and its parameters: RAID, parity, alignment blocks and so on.
  • Network interfaces configuration
  • Windows ErrorLog and SQL Server ErrorLog
  • Review of the High Availability system
 
Component: SQL Server Instance
 
  • Supported on all versions of SQL Server
  • Configuration of SQL Server system databases
 

 

 

Use of system resources:

 
    • Memory, disks, network
    • Performance monitor
  • Security and safety audit connections
  • Review of SQL Server Agent and associated parameters
    • Database mail
    • Permissions
  • Latencies in server resource usage

 

 

Component: Database Maintenance
 
   Analysis of strategies for backups for all SQL Server databases
  • Recovery models
  • Maintenance tasks: index maintenance, detection of duplicated indexes, missing indexes and indexes to delete.
  • Database consistency
  • Latencies in resource usage in databases
 
Component: Databases
 
                                        • Configuration parameters

                                                •  

  • Security and user permissions
    •  
  • Space use and distribution of objects
    •  
  • Detection of inconsistent collations (at instance, database, object and column scope)
    •  
  • Efficiency of the relational model: primary keys, indexes, integrity constraints, foreign keys and data types
    •  
  • Physical model: indexing and index tips
    •  
  • Topology Query: more frequent and problematic patterns, optimizing queries and deadlocks
    •  
  • SQL Server 2000: pre-migration validation for rules not included in SQL Server Migration Assistant TM
 

 

Følg os på: