Microsoft SQL Server database installation, configuration and setup (2000, 2005, 2008 R2, 2012, 2014, 2016)
Data modeling, database design and audits
Performance tuning, capacity planning, T-SQL coding and optimization
High availability/Disaster recovery (Clustering, Log Shipping, Mirroring)
Upgrades, migrations, replication
Cloud migration
Integration Services (SSIS) and general ETL development
Business Intelligence: SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
Advanced troubleshooting
Use long-running queries or tasks, Perfmon, etc. to generate the data.Double check that no configuration changes have been made on the server, and if so, document and investigate.
Ensure that all data replication tasks are operating normally.Record and compare last day of CPU activity with known baseline.
Check SQL Server and Windows application and system event log entries for warnings and errors and determine if any entries warrant further investigation.
Check mirroring status for all databases being mirrored.Check for service status for all Windows services that are required for operation (i.e. Windows Full-Text Indexing, Search Server, etc.)
Look for any security policy violations.Look for resources on the server, such as file sizes and disk space, and audit growth for long-term projections.
Check system performance levels against established baselines.
Check for full system backup status.
Verify that the MSDB database is being backed up.
Verify that index and statistic maintenance has completed.
Perform sample restores of database backups on pre production servers to spot-check backup set integrity.
Examine SQL Server wait statistics to see if new ‘pain points’ have become large points of contention within SQL Server.Audit job execution time for dramatic variances against baseline runtimes.
Investigate databases for objects that violate established rules.
Verify that SQL Server is sending database mail properly.
Monitoring.
Copyright © 2018-2021 MPIT Infosec - All Rights Reserved.