SQL Server Health Check
Whether you’re brand new to SQL Server Health Checks, or want to learn advanced strategies, this is your hub for SQL knowledge.
Most Popular Posts
Server-level configuration
Services configurations
Ensure all your SQL Server services are functioning as required.
Windows operating system settings
Optimized OS settings ensure stable and efficient system performance.
Security
Make sure your SQL Server security settings are up-to-date and robust.
SQL instance options and features
Check SQL instance settings and features for optimal configuration and reliability.
tempdb settings
Check if tempdb is configured for the best performance.
Database options and SQL Server Agent Jobs
Review SQL Agent job setups, maintenance plans, and database configurations for optimal performance.
SQL database owned by non-SA account
SQL objects owned by non-SA account
Backup health checks
Verify backup processes, corruption checks, and storage configurations to ensure data integrity and availability.
Disks and storage configuration
Optimize storage by analyzing drive performance and file distribution.
Filegroups and file layout
Streamline performance by optimizing filegroups, managing VLF counts, and ensuring precise DB file configurations.
Identify top resource-heavy queries and processes
Find high-impact T-SQL and SPs, assess backups, and review memory usage.
Query plan analysis
Detect single-use/multiple query plans, implicit conversions, and RECOMPILE usage.
Database objects and tables design
Review tables without clustering keys, untrusted constraints, triggers, cursors, and forced hints.
Indexes and statistics
Check for missing, useless indexes, over-indexing, and outdated statistics.
