Category: Reliability Item: Missing alerts Why should you enable SQL Server alerts? Enabling these Alerts can prevent a lot of problems: Potential to miss critical

Category: Reliability Item: Backups compression settings What is the backup compression default option? It determines whether the server instance creates compressed backups by default. Backup

Description: Problem: Deadlocking. This stored procedure is continuously involved in deadlocking. Solution: A new index. Scan operation can be tuned into becoming a seek (a

Description: Problem: This stored procedure runs very frequently (multiple times per minute) and consumes a lot of server resources (CPU, storage reads and duration). Change:

Description: Problem: Stored procedure that is run hundreds of times per hour is taking a long time. Change:  Multiple changes were made to code inside

What is the CTP in SQL Server? The cost threshold for parallelism (CTP) is the setting that controls at what point a SQL Server query

Category: Performance Item:  SQL Server Error logs not optimally What’s the SQL Server error log? It’s a file used by SQL server to write data

Category: Performance Item:  SQL Server Error logs not optimally configured. What is the TempDB database? Tempdb is one of the system databases in Microsoft SQL

Category: Security Item:  SQL Agent jobs owned by non SA account Users leave the organization. When login is disabled, deleted or Active Directory is not available –

Category: Reliability Item: Priority boost is ON What does priority boost option do? The option will make SQL Server run the sqlservr.exe process and threads as High

Category: Performance Item: Auto-update statistics What are statistics in SQL Server? They are large binary objects (BLOBs) that contain information about the correlation and distribution

Category: Performance Item: Windows OS page file not optimal What is the Windows OS page file? This file is a form of virtual memory. When your memory