|
|
|
|
|
The TI Group's SQL Health Check consists of the following high-level tasks that will be performed on an SQL Server environment and carried out by an experienced Senior Technical Consultant. This will ascertain overall health and audit the current configuration:
Server and O/S Configuration
- Details on server configuration
- Suitability of hardware and software setup
- Memory, CPU and NIC
- Storage types: DAS, NAS, RAID, SAN
- Other software systems on same servers
- SQL Server Instance Configuration
- Server settings
- Versions and service packs
- 32 bit vs 64 bit
- SQL Agent
- Jobs and alerts
- Mail configuration
- Service Broker
- Full text indexing
Security Analysis
- Firewall rules
- Security models
- Login methods used by applications
- Password policies
- Group allocations
- SQL Server and SQL Agent accounts and auto-start mode
- Job proxy model and job usage
- Network library configuration and usage
- SSL traffic encryption
- Database encryption
- Linked servers, logins and usage
- Endpoints security checks
- Kerberos setup and server trusts
Security Analysis
- Appropriate database configuration
- File placement analysis
- Collation sequences
- Fragmentation Analysis
- Size and growth management
- Partitioning (tables and views)
Replication
- Analysis of replication distribution and publisher and subscriber configuration
- Replication Security
- Replication Performance
Fault Tolerance
- Analysis of existing cluster or requirements
- Analysis of existing mirrors or requirements
- Analysis of existing log shipping or requirements
- SAN usage and replication
- Backup of database and logs
- Log size management
- Disaster Recovery Strategy
- Are maintenance plans and other jobs in place to maintain database integrity
Data Warehouse
- Is SSIS in use and configured correctly
- SSIS packages storage, security and execution
- Analysis server installation and configuration / clustering
- Reporting service installation and configuration
- Is Reporting services running SharePoint integrated mode and if so is it configured correctly
Performance Analysis
- Are the basic performance measures for the server in line (CPU, Memory, IO, etc)
- Are the databases performing adequately with respect to I/O
- Are there any obvious badly performing queries
|
|
|
|
|
|
|
|
