Example report This is a sample SQL Server Health Check, produced from a test environment for demonstration only. All server, database, user, object and path names have been replaced with generic names. Our health check runs approximately 200 automated checks across 10 risk areas: backup and recovery, data integrity, security, high availability, performance, configuration, database settings, storage, monitoring and maintenance, and platform and patching.
Want this report for your own server? The SQL Server Health Check is $499 per server, delivered in 3 business days with a walkthrough. See price, scope and FAQ · Contact us
Everconnect Data Systems, Inc. | EverconnectDS.com

SQL Server Health Check

A point-in-time review of SQLSERVER01 covering data protection, integrity, security, performance and configuration.

Server SQLSERVER01
Platform SQL Server 2025 - Standard Developer Edition (64-bit)
Report date 2026-10-07 15:51
Scope All databases
Prepared by Everconnect Data Systems, Inc.
Overall health score
63
/ 100
At risk
Critical issues 1
Warnings 9
Advisories 25
Areas with no issues 0 of 10

The score starts at 100 and is reduced for each distinct critical and warning issue. Any critical issue keeps the score below 75.

Report SQL Server Health Check
Prepared by Everconnect Data Systems, Inc.
Client
Server SQLSERVER01
Platform SQL Server 2025
Report date 2026-10-07 15:51
Health score 63 / 100
Rating At risk
Critical issues 1
Warnings 9
Advisories 25
Risk area: Backup & Recovery Advisory
Risk area: Data Integrity Critical
Risk area: Security Needs attention
Risk area: High Availability Advisory
Risk area: Performance Advisory
Risk area: Configuration Needs attention
Risk area: Database Settings Advisory
Risk area: Storage Needs attention
Risk area: Monitoring & Maintenance Needs attention
Risk area: Platform & Patching Needs attention
Key Severity Area Finding Object Details Recommendation
ECDS_201 Critical Data Integrity Integrity check (DBCC CHECKDB) has never run master No successful DBCC CHECKDB recorded. Run DBCC CHECKDB at least weekly. Undetected corruption spreads into backups, and may only be found when it is too late to recover.
ECDS_201 Critical Data Integrity Integrity check (DBCC CHECKDB) has never run model No successful DBCC CHECKDB recorded. Run DBCC CHECKDB at least weekly. Undetected corruption spreads into backups, and may only be found when it is too late to recover.
ECDS_201 Critical Data Integrity Integrity check (DBCC CHECKDB) has never run msdb No successful DBCC CHECKDB recorded. Run DBCC CHECKDB at least weekly. Undetected corruption spreads into backups, and may only be found when it is too late to recover.
ECDS_303 Warning Security The sa login is enabled sa The well-known sa account is enabled and is a common target for password attacks. Disable or rename sa and use named administrator accounts.
ECDS_604 Warning Configuration Cost threshold for parallelism is at the default (5) cost threshold for parallelism Current value: 5. The default of 5 lets tiny queries run in parallel, wasting CPU. Start at 50 and tune from there.
ECDS_616 Warning Configuration Instant file initialization is disabled SQL Server (MSSQLSERVER) The SQL Server service account cannot skip zero-initializing data files. Grant "Perform volume maintenance tasks" to the service account. File growth and restores become much faster.
ECDS_803 Warning Storage Files grow by a percentage master Files: master (10%), mastlog (10%) Use a fixed growth size (e.g. 256 MB - 1 GB). Percentage growth becomes very large and slow as files grow.
ECDS_803 Warning Storage Files grow by a percentage msdb Files: MSDBData (10%), MSDBLog (10%) Use a fixed growth size (e.g. 256 MB - 1 GB). Percentage growth becomes very large and slow as files grow.
ECDS_814 Warning Storage Database or log ran out of space - 1 occurrence(s) in the last 7 days; most recent 2026-10-06 08:47. A transaction log or database filled up and changes failed. Review file growth settings and log backups.
ECDS_905 Warning Monitoring & Maintenance Critical error alerts are not configured - Missing alerts: Sev 19, Sev 20, Sev 21, Sev 22, Sev 23, Sev 24, Sev 25, Error 823, Error 824, Error 825. Create SQL Agent alerts for severity 19-25 and errors 823/824/825 (storage corruption) and send them to an operator.
ECDS_903 Warning Monitoring & Maintenance No one is notified when problems occur - No SQL Agent operators are configured and Database Mail is not set up. Configure Database Mail and an operator, and notify it on job failures and critical alerts. Without this, failures go unnoticed.
ECDS_901 Warning Monitoring & Maintenance SQL Server Agent is not running SQL Server Agent (MSSQLSERVER) Status: Stopped, startup: Manual. Backups, maintenance and alerts scheduled in SQL Agent are not running. Start the service and set it to Automatic.
ECDS_005 Warning Platform & Patching No cumulative update installed (RTM build) SQL Server 2025 Build 17.0.1000.7 is the original release with no cumulative updates. Apply the latest cumulative update. Many performance and stability fixes ship only in CUs.
ECDS_108 Advisory Backup & Recovery Backups taken without CHECKSUM Database_A The last full backup did not verify page checksums. Use WITH CHECKSUM (or enable the "backup checksum default" setting) so corruption is caught at backup time.
ECDS_108 Advisory Backup & Recovery Backups taken without CHECKSUM Database_B The last full backup did not verify page checksums. Use WITH CHECKSUM (or enable the "backup checksum default" setting) so corruption is caught at backup time.
ECDS_108 Advisory Backup & Recovery Backups taken without CHECKSUM master The last full backup did not verify page checksums. Use WITH CHECKSUM (or enable the "backup checksum default" setting) so corruption is caught at backup time.
ECDS_108 Advisory Backup & Recovery Backups taken without CHECKSUM model The last full backup did not verify page checksums. Use WITH CHECKSUM (or enable the "backup checksum default" setting) so corruption is caught at backup time.
ECDS_108 Advisory Backup & Recovery Backups taken without CHECKSUM msdb The last full backup did not verify page checksums. Use WITH CHECKSUM (or enable the "backup checksum default" setting) so corruption is caught at backup time.
ECDS_108 Advisory Backup & Recovery Backups taken without CHECKSUM Database_C The last full backup did not verify page checksums. Use WITH CHECKSUM (or enable the "backup checksum default" setting) so corruption is caught at backup time.
ECDS_209 Advisory Data Integrity Untrusted foreign keys or check constraints Database_C 8 foreign keys and 8 check constraints are not trusted. Untrusted constraints may hide invalid data and prevent query optimizations. Re-validate them WITH CHECK.
ECDS_341 Advisory Security Databases owned by individual logins Database_A Owner: SQLSERVER01\User_123. If this person's account is removed, jobs and features that rely on the database owner can fail. Change the owner to a dedicated low-privilege login or sa.
ECDS_341 Advisory Security Databases owned by individual logins Database_B Owner: SQLSERVER01\User_123. If this person's account is removed, jobs and features that rely on the database owner can fail. Change the owner to a dedicated low-privilege login or sa.
ECDS_341 Advisory Security Databases owned by individual logins Database_C Owner: SQLSERVER01\User_123. If this person's account is removed, jobs and features that rely on the database owner can fail. Change the owner to a dedicated low-privilege login or sa.
ECDS_344 Advisory Security Databases are not encrypted at rest - 3 user database(s) do not use Transparent Data Encryption. If databases hold personal or regulated data, consider TDE (Enterprise edition, or Standard 2019+) and encrypted backups.
ECDS_346 Advisory Security Encrypted connections are not enforced - Force Encryption is off in SQL Server Configuration Manager. Install a trusted certificate and enable Force Encryption so all client traffic is encrypted.
ECDS_339 Advisory Security High-risk database permissions granted directly msdb dc_admin: IMPERSONATE on USER::MS_DataCollectorInternalUser Permissions such as CONTROL, IMPERSONATE or ALTER ANY USER give near-owner rights. Grant through roles and only where needed.
ECDS_321 Advisory Security Login activity is not tracked - SQL Server does not record when a login was last used, and login auditing is not turned on, so inactive user accounts cannot be identified. We recommend turning on login auditing so inactive users can be tracked and removed. Ask Everconnect about this functionality.
ECDS_313 Advisory Security Mixed-mode authentication is enabled - SQL Server accepts both Windows and SQL logins. If all applications support Windows/Entra authentication, switch to Windows-only authentication.
ECDS_324 Advisory Security No server audit is configured - There is no SQL Server Audit for logins, permission changes or data access. Configure SQL Server Audit for security events, especially if you have compliance requirements (PCI, HIPAA, SOX).
ECDS_314 Advisory Security SQL login passwords never expire sa CHECK_EXPIRATION is OFF; password last changed 2026-10-06. Enable password expiration for user logins, or rotate application passwords on a schedule.
ECDS_404 Advisory High Availability No high availability or standby server - No failover cluster, Availability Group, mirroring or log shipping was found. If this server fails, recovery depends entirely on backups. Decide how long the business can be without this server (RTO) and how much data it can lose (RPO), then choose a matching HA/DR solution.
ECDS_532 Advisory Performance Duplicate indexes Database_A 1 index(es) have the same key columns as another index on the same table. Duplicate indexes double the write cost and storage for no read benefit. Consolidate them.
ECDS_532 Advisory Performance Duplicate indexes Database_C 6 index(es) have the same key columns as another index on the same table. Duplicate indexes double the write cost and storage for no read benefit. Consolidate them.
ECDS_540 Advisory Performance Query Store is not enabled Database_A Query Store is OFF. Enable Query Store to capture query performance history. It makes troubleshooting and plan regressions much easier to fix.
ECDS_540 Advisory Performance Query Store is not enabled Database_C Query Store is OFF. Enable Query Store to capture query performance history. It makes troubleshooting and plan regressions much easier to fix.
ECDS_526 Advisory Performance Expensive queries have tuning opportunities - 8 of the most expensive queries show plan issues: Implicit conversion (5), Optimizer timeout (4), Key lookup (2), Table scan (1), Cursor (1). These patterns are classic, fixable causes of slow queries (data type mismatches, missing or incomplete indexes, row-by-row functions). A query tuning engagement typically targets these first.
ECDS_528 Advisory Performance High query compilation rate - 72.7 compilations per 100 batch requests since the last restart. Compiling queries costs CPU on every execution. Parameterizing application queries (or forced parameterization) usually reduces CPU noticeably.
ECDS_546 Advisory Performance Windows power plan is not High performance - The active power plan lets Windows lower CPU speed to save energy. Set the power plan to High performance on database servers (and check BIOS/hypervisor power settings).
ECDS_608 Advisory Configuration Backup checksums are not on by default backup checksum default Current value: 0. Enable "backup checksum default" so every backup verifies page checksums.
ECDS_607 Advisory Configuration Backup compression is not on by default backup compression default Current value: 0. Compressed backups are smaller and usually faster. Enable "backup compression default".
ECDS_605 Advisory Configuration Optimize for ad hoc workloads is off optimize for ad hoc workloads Single-use plans use 36.9 MB of the plan cache. Enabling this setting is low-risk and saves plan cache memory.
ECDS_609 Advisory Configuration Remote dedicated admin connection (DAC) is disabled remote admin connections Current value: 0. The DAC is the emergency way in when the server is unresponsive. Enable remote admin connections.
ECDS_707 Advisory Database Settings Database compatibility level is behind the server Database_A Compatibility level 140; the server supports 170. Newer levels enable query-processing improvements. Test before changing; Query Store makes this change safer.
ECDS_707 Advisory Database Settings Database compatibility level is behind the server Database_C Compatibility level 150; the server supports 170. Newer levels enable query-processing improvements. Test before changing; Query Store makes this change safer.
ECDS_808 Advisory Storage Data and log files share a drive Database_A Data and log files are on the same volume. Separating data and log files improves performance and isolates failures.
ECDS_808 Advisory Storage Data and log files share a drive Database_B Data and log files are on the same volume. Separating data and log files improves performance and isolates failures.
ECDS_808 Advisory Storage Data and log files share a drive Database_C Data and log files are on the same volume. Separating data and log files improves performance and isolates failures.
ECDS_910 Advisory Monitoring & Maintenance Backup success messages are not suppressed in the error log Trace flag 3226 Trace flag 3226 is not enabled, so every successful backup adds a line to the error log. Enable trace flag 3226 so the error log is not flooded with backup messages. Failed backups and other errors are still logged. Also set it as a startup parameter.
ECDS_909 Advisory Monitoring & Maintenance Deadlock details are not written to the error log Trace flag 1222 Trace flag 1222 is not enabled. Enable trace flag 1222 so the full deadlock graph is written to the error log whenever a deadlock happens. It is low risk and makes deadlocks much easier to investigate. Also set it as a startup parameter so it survives restarts.
ECDS_014 Advisory Platform & Patching Deprecated features are in use Database compatibility level 140 Used 2 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
ECDS_014 Advisory Platform & Patching Deprecated features are in use Database compatibility level 150 Used 2 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
ECDS_014 Advisory Platform & Patching Deprecated features are in use DATABASEPROPERTYEX('IsFullTextEnabled') Used 21 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
ECDS_014 Advisory Platform & Patching Deprecated features are in use sp_db_vardecimal_storage_format Used 1 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
ECDS_014 Advisory Platform & Patching Deprecated features are in use String literals as column aliases Used 8 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
ECDS_014 Advisory Platform & Patching Deprecated features are in use sysdatabases Used 6 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
ECDS_014 Advisory Platform & Patching Deprecated features are in use sysfiles Used 21 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
ECDS_014 Advisory Platform & Patching Deprecated features are in use sysprocesses Used 1 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
ECDS_014 Advisory Platform & Patching Deprecated features are in use sysusers Used 1 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
ECDS_014 Advisory Platform & Patching Deprecated features are in use XP_API Used 6 time(s) since the last restart (2026-10-06 08:50). Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
01 / Executive summary

What we found

The most important results of this review in plain language. Details for each item follow in the sections below.

Top priorities

  1. Critical Integrity check (DBCC CHECKDB) has never run (3 items)ECDS_201
  2. Warning The sa login is enabledECDS_303
  3. Warning Cost threshold for parallelism is at the default (5)ECDS_604
  4. Warning Instant file initialization is disabledECDS_616
  5. Warning Files grow by a percentage (2 items)ECDS_803
  6. Warning Database or log ran out of spaceECDS_814
  7. Warning Critical error alerts are not configuredECDS_905
02 / Risk areas

Risk by area

Each area shows its most serious finding. Red needs immediate attention, yellow should be planned soon, blue is advisory and green means no issues were found.

Backup & Recovery
Advisory - 6 findings
Data Integrity
Critical - 4 findings
Security
Needs attention - 11 findings
High Availability
Advisory - 1 finding
Performance
Advisory - 7 findings
Configuration
Needs attention - 6 findings
Database Settings
Advisory - 2 findings
Storage
Needs attention - 6 findings
Monitoring & Maintenance
Needs attention - 5 findings
Platform & Patching
Needs attention - 11 findings
03 / Findings

Findings and recommendations

Every issue found, ordered by severity, with the affected objects and a recommended action.

ID Severity Area Finding Affected / details Recommendation
ECDS_201 Critical Data Integrity Integrity check (DBCC CHECKDB) has never run
  • master: No successful DBCC CHECKDB recorded.
  • model: No successful DBCC CHECKDB recorded.
  • msdb: No successful DBCC CHECKDB recorded.
Run DBCC CHECKDB at least weekly. Undetected corruption spreads into backups, and may only be found when it is too late to recover.
ECDS_303 Warning Security The sa login is enabled
  • sa: The well-known sa account is enabled and is a common target for password attacks.
Disable or rename sa and use named administrator accounts.
ECDS_604 Warning Configuration Cost threshold for parallelism is at the default (5)
  • cost threshold for parallelism: Current value: 5.
The default of 5 lets tiny queries run in parallel, wasting CPU. Start at 50 and tune from there.
ECDS_616 Warning Configuration Instant file initialization is disabled
  • SQL Server (MSSQLSERVER): The SQL Server service account cannot skip zero-initializing data files.
Grant "Perform volume maintenance tasks" to the service account. File growth and restores become much faster.
ECDS_803 Warning Storage Files grow by a percentage
  • master: Files: master (10%), mastlog (10%)
  • msdb: Files: MSDBData (10%), MSDBLog (10%)
Use a fixed growth size (e.g. 256 MB - 1 GB). Percentage growth becomes very large and slow as files grow.
ECDS_814 Warning Storage Database or log ran out of space
  • 1 occurrence(s) in the last 7 days; most recent 2026-10-06 08:47.
A transaction log or database filled up and changes failed. Review file growth settings and log backups.
ECDS_905 Warning Monitoring & Maintenance Critical error alerts are not configured
  • Missing alerts: Sev 19, Sev 20, Sev 21, Sev 22, Sev 23, Sev 24, Sev 25, Error 823, Error 824, Error 825.
Create SQL Agent alerts for severity 19-25 and errors 823/824/825 (storage corruption) and send them to an operator.
ECDS_903 Warning Monitoring & Maintenance No one is notified when problems occur
  • No SQL Agent operators are configured and Database Mail is not set up.
Configure Database Mail and an operator, and notify it on job failures and critical alerts. Without this, failures go unnoticed.
ECDS_901 Warning Monitoring & Maintenance SQL Server Agent is not running
  • SQL Server Agent (MSSQLSERVER): Status: Stopped, startup: Manual.
Backups, maintenance and alerts scheduled in SQL Agent are not running. Start the service and set it to Automatic.
ECDS_005 Warning Platform & Patching No cumulative update installed (RTM build)
  • SQL Server 2025: Build 17.0.1000.7 is the original release with no cumulative updates.
Apply the latest cumulative update. Many performance and stability fixes ship only in CUs.
ECDS_108 Advisory Backup & Recovery Backups taken without CHECKSUM
  • Database_A: The last full backup did not verify page checksums.
  • Database_B: The last full backup did not verify page checksums.
  • master: The last full backup did not verify page checksums.
  • model: The last full backup did not verify page checksums.
  • msdb: The last full backup did not verify page checksums.
  • Database_C: The last full backup did not verify page checksums.
Use WITH CHECKSUM (or enable the "backup checksum default" setting) so corruption is caught at backup time.
ECDS_209 Advisory Data Integrity Untrusted foreign keys or check constraints
  • Database_C: 8 foreign keys and 8 check constraints are not trusted.
Untrusted constraints may hide invalid data and prevent query optimizations. Re-validate them WITH CHECK.
ECDS_341 Advisory Security Databases owned by individual logins
  • Database_A: Owner: SQLSERVER01\User_123.
  • Database_B: Owner: SQLSERVER01\User_123.
  • Database_C: Owner: SQLSERVER01\User_123.
If this person's account is removed, jobs and features that rely on the database owner can fail. Change the owner to a dedicated low-privilege login or sa.
ECDS_344 Advisory Security Databases are not encrypted at rest
  • 3 user database(s) do not use Transparent Data Encryption.
If databases hold personal or regulated data, consider TDE (Enterprise edition, or Standard 2019+) and encrypted backups.
ECDS_346 Advisory Security Encrypted connections are not enforced
  • Force Encryption is off in SQL Server Configuration Manager.
Install a trusted certificate and enable Force Encryption so all client traffic is encrypted.
ECDS_339 Advisory Security High-risk database permissions granted directly
  • msdb: dc_admin: IMPERSONATE on USER::MS_DataCollectorInternalUser
Permissions such as CONTROL, IMPERSONATE or ALTER ANY USER give near-owner rights. Grant through roles and only where needed.
ECDS_321 Advisory Security Login activity is not tracked
  • SQL Server does not record when a login was last used, and login auditing is not turned on, so inactive user accounts cannot be identified.
We recommend turning on login auditing so inactive users can be tracked and removed. Ask Everconnect about this functionality.
ECDS_313 Advisory Security Mixed-mode authentication is enabled
  • SQL Server accepts both Windows and SQL logins.
If all applications support Windows/Entra authentication, switch to Windows-only authentication.
ECDS_324 Advisory Security No server audit is configured
  • There is no SQL Server Audit for logins, permission changes or data access.
Configure SQL Server Audit for security events, especially if you have compliance requirements (PCI, HIPAA, SOX).
ECDS_314 Advisory Security SQL login passwords never expire
  • sa: CHECK_EXPIRATION is OFF; password last changed 2026-10-06.
Enable password expiration for user logins, or rotate application passwords on a schedule.
ECDS_404 Advisory High Availability No high availability or standby server
  • No failover cluster, Availability Group, mirroring or log shipping was found. If this server fails, recovery depends entirely on backups.
Decide how long the business can be without this server (RTO) and how much data it can lose (RPO), then choose a matching HA/DR solution.
ECDS_532 Advisory Performance Duplicate indexes
  • Database_A: 1 index(es) have the same key columns as another index on the same table.
  • Database_C: 6 index(es) have the same key columns as another index on the same table.
Duplicate indexes double the write cost and storage for no read benefit. Consolidate them.
ECDS_540 Advisory Performance Query Store is not enabled
  • Database_A: Query Store is OFF.
  • Database_C: Query Store is OFF.
Enable Query Store to capture query performance history. It makes troubleshooting and plan regressions much easier to fix.
ECDS_526 Advisory Performance Expensive queries have tuning opportunities
  • 8 of the most expensive queries show plan issues: Implicit conversion (5), Optimizer timeout (4), Key lookup (2), Table scan (1), Cursor (1).
These patterns are classic, fixable causes of slow queries (data type mismatches, missing or incomplete indexes, row-by-row functions). A query tuning engagement typically targets these first.
ECDS_528 Advisory Performance High query compilation rate
  • 72.7 compilations per 100 batch requests since the last restart.
Compiling queries costs CPU on every execution. Parameterizing application queries (or forced parameterization) usually reduces CPU noticeably.
ECDS_546 Advisory Performance Windows power plan is not High performance
  • The active power plan lets Windows lower CPU speed to save energy.
Set the power plan to High performance on database servers (and check BIOS/hypervisor power settings).
ECDS_608 Advisory Configuration Backup checksums are not on by default
  • backup checksum default: Current value: 0.
Enable "backup checksum default" so every backup verifies page checksums.
ECDS_607 Advisory Configuration Backup compression is not on by default
  • backup compression default: Current value: 0.
Compressed backups are smaller and usually faster. Enable "backup compression default".
ECDS_605 Advisory Configuration Optimize for ad hoc workloads is off
  • optimize for ad hoc workloads: Single-use plans use 36.9 MB of the plan cache.
Enabling this setting is low-risk and saves plan cache memory.
ECDS_609 Advisory Configuration Remote dedicated admin connection (DAC) is disabled
  • remote admin connections: Current value: 0.
The DAC is the emergency way in when the server is unresponsive. Enable remote admin connections.
ECDS_707 Advisory Database Settings Database compatibility level is behind the server
  • Database_A: Compatibility level 140; the server supports 170.
  • Database_C: Compatibility level 150; the server supports 170.
Newer levels enable query-processing improvements. Test before changing; Query Store makes this change safer.
ECDS_808 Advisory Storage Data and log files share a drive
  • Database_A: Data and log files are on the same volume.
  • Database_B: Data and log files are on the same volume.
  • Database_C: Data and log files are on the same volume.
Separating data and log files improves performance and isolates failures.
ECDS_910 Advisory Monitoring & Maintenance Backup success messages are not suppressed in the error log
  • Trace flag 3226: Trace flag 3226 is not enabled, so every successful backup adds a line to the error log.
Enable trace flag 3226 so the error log is not flooded with backup messages. Failed backups and other errors are still logged. Also set it as a startup parameter.
ECDS_909 Advisory Monitoring & Maintenance Deadlock details are not written to the error log
  • Trace flag 1222: Trace flag 1222 is not enabled.
Enable trace flag 1222 so the full deadlock graph is written to the error log whenever a deadlock happens. It is low risk and makes deadlocks much easier to investigate. Also set it as a startup parameter so it survives restarts.
ECDS_014 Advisory Platform & Patching Deprecated features are in use
  • Database compatibility level 140: Used 2 time(s) since the last restart (2026-10-06 08:50).
  • Database compatibility level 150: Used 2 time(s) since the last restart (2026-10-06 08:50).
  • DATABASEPROPERTYEX('IsFullTextEnabled'): Used 21 time(s) since the last restart (2026-10-06 08:50).
  • sp_db_vardecimal_storage_format: Used 1 time(s) since the last restart (2026-10-06 08:50).
  • String literals as column aliases: Used 8 time(s) since the last restart (2026-10-06 08:50).
  • sysdatabases: Used 6 time(s) since the last restart (2026-10-06 08:50).
  • sysfiles: Used 21 time(s) since the last restart (2026-10-06 08:50).
  • sysprocesses: Used 1 time(s) since the last restart (2026-10-06 08:50).
  • sysusers: Used 1 time(s) since the last restart (2026-10-06 08:50).
  • XP_API: Used 6 time(s) since the last restart (2026-10-06 08:50).
Deprecated features will be removed in a future version and can block an upgrade. Find the code that uses them and plan replacements before the next upgrade.
04 / Performance review

Performance

We identified 5 performance improvement opportunities (0 significant, 5 advisory). Many performance problems can be fixed through query, index and configuration tuning, without buying new hardware or licenses.

0%
Average CPU (last hour)
Peak 0%
Other (82.4%)
Biggest wait area
Since last restart
111659 s
Page life expectancy
Guideline 300 s
0.0
Batch requests / sec
Average since restart
0
Missing index suggestions
8
Top queries with plan issues
Of the most expensive queries
7 / 0
Duplicate / unused indexes
Extra write overhead
0.0
Deadlocks per day
Average since restart
10
File autogrowth events
In the default trace window

Performance findings

ID Severity Area Finding Affected / details Recommendation
ECDS_532 Advisory Performance Duplicate indexes
  • Database_A: 1 index(es) have the same key columns as another index on the same table.
  • Database_C: 6 index(es) have the same key columns as another index on the same table.
Duplicate indexes double the write cost and storage for no read benefit. Consolidate them.
ECDS_540 Advisory Performance Query Store is not enabled
  • Database_A: Query Store is OFF.
  • Database_C: Query Store is OFF.
Enable Query Store to capture query performance history. It makes troubleshooting and plan regressions much easier to fix.
ECDS_526 Advisory Performance Expensive queries have tuning opportunities
  • 8 of the most expensive queries show plan issues: Implicit conversion (5), Optimizer timeout (4), Key lookup (2), Table scan (1), Cursor (1).
These patterns are classic, fixable causes of slow queries (data type mismatches, missing or incomplete indexes, row-by-row functions). A query tuning engagement typically targets these first.
ECDS_528 Advisory Performance High query compilation rate
  • 72.7 compilations per 100 batch requests since the last restart.
Compiling queries costs CPU on every execution. Parameterizing application queries (or forced parameterization) usually reduces CPU noticeably.
ECDS_546 Advisory Performance Windows power plan is not High performance
  • The active power plan lets Windows lower CPU speed to save energy.
Set the power plan to High performance on database servers (and check BIOS/hypervisor power settings).

Performance details

Top wait statistics

What SQL Server spends its time waiting on (cumulative since the last restart). Harmless background waits are excluded.

Wait type Area % of waits Total wait (hours) Avg wait (ms) What it means
AZURE_IMDS_VERSIONS Other 82.1 0.0 21045.0 -
ASYNC_NETWORK_IO Network / application 6.7 0.0 0.2 The client application is slow to read query results (often row-by-row processing).
ASYNC_IO_COMPLETION Storage 3.5 0.0 106.5 Other disk I/O such as sort/hash spills, backups and file growth.
PAGEIOLATCH_SH Storage 2.2 0.0 0.3 Reading data pages from disk. Storage is slow or there is not enough memory to cache data.
SOS_SCHEDULER_YIELD CPU 1.7 0.0 0.1 Queries waiting for CPU time. CPU pressure or heavy scans.
WRITELOG Transaction log 1.6 0.0 0.8 Waiting for transaction log writes to disk. Log storage latency or many small transactions.
PREEMPTIVE_OS_DELETESECURITYCONTEXT External calls 0.4 0.0 0.4 Calls to the operating system or external components.
PREEMPTIVE_OS_CREATEFILE External calls 0.2 0.0 0.7 Calls to the operating system or external components.
LCK_M_S Blocking 0.2 0.0 26.5 Blocking: sessions wait for locks held by other sessions.
MSQL_XP Other 0.2 0.0 0.7 -

Workload profile

Average activity since the last restart, from SQL Server performance counters.

Measure Value What it means
Batch requests per second (average) 0.0 Overall workload volume.
Compilations per 100 batches 72.7 High values mean queries are not reusing plans (often non-parameterized SQL), which costs CPU.
Recompilations per 100 compilations 15.4 Frequent recompiles add CPU and can cause unstable performance.
Index searches per full scan 179 Low values indicate many table/index scans, often caused by missing indexes.
Forwarded records per 100 batches 0.7 Extra reads caused by heap tables whose rows moved. Fixed by adding clustered indexes or rebuilding heaps.
Page splits per 100 batches 11.5 Page splits fragment indexes and add log activity.
Lock waits per 100 batches 0.07 How often requests had to wait for a lock.
Page life expectancy (seconds) 111659 How long data stays in memory. Guideline for this server: above 300 seconds.
SQL Server memory in use / target (GB) 0.7 / 15.4 Memory SQL Server is using compared with what it wants.
User connections 4 Current connections.
Processes blocked right now 0 Sessions blocked at the time of the check.

Storage latency by file

Average time per read and write since the last restart. Under 20 ms is generally healthy for data files, under 5-10 ms for log files.

Database Type File Avg read (ms) Avg write (ms) GB read GB written
master LOG E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 0.2 1.5 0.0 0.0
tempdb LOG E:\SQLServer\TempDB\templog.ldf 0.2 1.0 0.0 0.0
Database_B LOG E:\SQLServer\Logs\Database_B_log.ldf 0.3 0.9 0.0 0.0
msdb LOG E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf 0.2 0.7 0.0 0.0
Database_C ROWS E:\SQLServer\Data\Database_C.mdf 0.7 0.2 0.0 0.0
master ROWS E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\master.mdf 0.4 0.6 0.0 0.0
tempdb ROWS E:\SQLServer\TempDB\tempdb.mdf 0.6 0.0 0.0 0.0
msdb ROWS E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf 0.4 0.6 0.0 0.0
Database_B ROWS E:\SQLServer\Data\Database_B.mdf 0.3 0.5 0.0 0.0
Database_A ROWS E:\SQLServer\Data\Database_A.mdf 0.4 0.2 0.0 0.0
model LOG E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\modellog.ldf 0.2 0.4 0.0 0.0
model ROWS E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\model.mdf 0.3 0.3 0.0 0.0
tempdb ROWS E:\SQLServer\TempDB\tempdb_mssql_2.ndf 0.3 0.0 0.0 0.0
tempdb ROWS E:\SQLServer\TempDB\tempdb_mssql_3.ndf 0.3 0.0 0.0 0.0
tempdb ROWS E:\SQLServer\TempDB\tempdb_mssql_4.ndf 0.3 0.0 0.0 0.0
tempdb ROWS E:\SQLServer\TempDB\tempdb_mssql_5.ndf 0.3 0.0 0.0 0.0
tempdb ROWS E:\SQLServer\TempDB\tempdb_mssql_6.ndf 0.2 0.0 0.0 0.0
tempdb ROWS E:\SQLServer\TempDB\tempdb_mssql_7.ndf 0.2 0.0 0.0 0.0
tempdb ROWS E:\SQLServer\TempDB\tempdb_mssql_8.ndf 0.2 0.0 0.0 0.0
Database_A LOG E:\SQLServer\Logs\Database_A_log.ldf 0.2 0.2 0.0 0.0
Database_C LOG E:\SQLServer\Logs\Database_C_log.ldf 0.2 0.2 0.0 0.0

CPU utilization (last hour)

SQL Server and other-process CPU, sampled each minute over the last hour.

​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​
CPU % over the last hour (oldest on the left). Hover a bar for the time and value.
Measure Value
Average SQL Server CPU % 0
Peak SQL Server CPU % 0
Time at 90%+ CPU 0%
Average non-SQL CPU % 2

Top queries by CPU

The most expensive queries currently in the plan cache. Tuning a handful of queries is often the fastest way to improve performance.

# Database Executions Total CPU (sec) Avg CPU (ms) Avg duration (ms) Avg logical reads Last run Plan warnings Query
1 master 22 0.6 28.2 47.0 10 2026-10-07 15:47 - SELECT target_data FROM sys.dm_xe_session_targets xet WITH(nolock) JOIN sys.dm_xe_sessions xes WITH(nolock) ON xes.address = xet.event_session_address WHERE xes.name = 'telemetry_xevents' AND xet.target_name = 'ring_buffer'
2 Database_B 2 0.3 132.8 276.1 46966 2026-10-06 09:00 - SELECT SCHEMA_NAME(udf.schema_id) AS [Schema], udf.name AS [Name], udf.object_id AS [ID], (case when 'FN' = udf.type then 1 when 'FS' = udf.type then 1 when 'IF' = udf.type then 3 when 'TF' = udf.type then 2 when 'FT' = udf.type then 2 else 0 end) AS [FunctionType], CASE WHEN udf.type IN ('FN','IF','TF') THEN 1 WHEN udf.type IN ('FS','FT') THEN 2 ELSE 1 END AS [ImplementationType], CAST( case
3 master 1 0.3 265.0 265.0 146 2026-10-07 15:51 - INSERT #FileIO SELECT DB_NAME(s.database_id), mf.type_desc, mf.physical_name, s.num_of_reads, s.num_of_writes, 1.0 * s.io_stall_read_ms / NULLIF(s.num_of_reads, 0), 1.0 * s.io_stall_write_ms / NULLIF(s.num_of_writes, 0), s.num_of_bytes_read / 1073741824.0, s.num_of_bytes_written / 1073741824.0 FROM sys.dm_io_virtual_file_stats(NULL, NULL) s JOI
4 Database_B 4 0.2 53.9 53.9 222 2026-10-06 09:00 Implicit conversion; Key lookup; Optimizer timeout SELECT sp.name AS [Name], sp.object_id AS [ID], sp.create_date AS [CreateDate], sp.modify_date AS [DateLastModified], ISNULL(ssp.name, N'') AS [Owner], CAST(case when sp.principal_id is null then 1 else 0 end AS bit) AS [IsSchemaOwned], SCHEMA_NAME(sp.schema_id) AS [Schema], CAST( case when sp.is_ms_shipped = 1 then 1 when ( select major_id from
5 master 1 0.2 199.6 203.3 89660 2026-10-07 15:51 - SELECT SCHEMA_NAME(udf.schema_id) AS [Schema], udf.name AS [Name], udf.object_id AS [ID], (case when 'FN' = udf.type then 1 when 'FS' = udf.type then 1 when 'IF' = udf.type then 3 when 'TF' = udf.type then 2 when 'FT' = udf.type then 2 else 0 end) AS [FunctionType], CASE WHEN udf.type IN ('FN','IF','TF') THEN 1 WHEN udf.type IN ('FS','FT') THEN 2 ELSE 1 END AS [ImplementationType], CAST( case
6 master 1 0.2 168.4 174.0 123885 2026-10-07 15:51 - SELECT SCHEMA_NAME(v.schema_id) AS [Schema], v.name AS [Name], v.object_id AS [ID] FROM sys.all_views AS v WHERE (v.type = @_msparam_0) ORDER BY [Schema] ASC,[Name] ASC
7 master 1 0.1 106.1 113.8 85497 2026-10-07 15:51 - SELECT SCHEMA_NAME(sp.schema_id) AS [Schema], sp.name AS [Name], sp.object_id AS [ID], CAST( case when sp.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = sp.object_id and minor_id = 0 and class = 1 and name = N'microsoft_databas
8 master 1 0.1 98.3 111.2 27127 2026-10-07 15:51 Optimizer timeout INSERT #DbDesign (DBName, UserTables, Heaps, UnusedIndexes, DisabledIndexes, HypotheticalIndexes, UntrustedFKs, UntrustedChecks, StaleStats) SELECT DB_NAME(), (SELECT COUNT(*) FROM sys.tables WHERE is_ms_shipped = 0), (SELECT COUNT(*) FROM sys.indexes i JOIN sys.tables t ON t.object_id = i.object_id WHERE i.type = 0 AND t.is_ms_shipped = 0), (S
9 master 1 0.1 83.9 84.0 28 2026-10-07 15:51 - SELECT RTRIM(counter_name), MAX(cntr_value) FROM sys.dm_os_performance_counters WHERE (object_name LIKE N'%SQL Statistics%' AND counter_name IN (N'Batch Requests/sec', N'SQL Compilations/sec', N'SQL Re-Compilations/sec')) OR (object_name LIKE N'%Access Methods%' AND counter_name IN (N'Forwarded Records/sec', N'Page Splits/sec', N'Full Scans/sec', N'Index Searches/sec'))
10 master 1 0.1 61.3 61.3 72 2026-10-07 15:51 Implicit conversion INSERT #Cpu (EventTime, SqlCpu, OtherCpu) SELECT TOP (60) DATEADD(MILLISECOND, -1 * (@ticks - y.[timestamp]), GETDATE()), y.SqlCpu, CASE WHEN 100 - y.Idle - y.SqlCpu > 0 THEN 100 - y.Idle - y.SqlCpu ELSE 0 END FROM (SELECT x.[timestamp], x.rec.value('(./Record/@id)[1]', 'int') AS RecordId, x.rec.value('(./Record/SchedulerMoni

Top queries by logical reads

Queries reading the most data. High reads usually point to missing or unsuitable indexes.

# Database Executions Total CPU (sec) Avg CPU (ms) Avg duration (ms) Avg logical reads Last run Plan warnings Query
1 master 1 0.2 168.4 174.0 123885 2026-10-07 15:51 - SELECT SCHEMA_NAME(v.schema_id) AS [Schema], v.name AS [Name], v.object_id AS [ID] FROM sys.all_views AS v WHERE (v.type = @_msparam_0) ORDER BY [Schema] ASC,[Name] ASC
2 Database_B 2 0.3 132.8 276.1 46966 2026-10-06 09:00 - SELECT SCHEMA_NAME(udf.schema_id) AS [Schema], udf.name AS [Name], udf.object_id AS [ID], (case when 'FN' = udf.type then 1 when 'FS' = udf.type then 1 when 'IF' = udf.type then 3 when 'TF' = udf.type then 2 when 'FT' = udf.type then 2 else 0 end) AS [FunctionType], CASE WHEN udf.type IN ('FN','IF','TF') THEN 1 WHEN udf.type IN ('FS','FT') THEN 2 ELSE 1 END AS [ImplementationType], CAST( case
3 master 1 0.2 199.6 203.3 89660 2026-10-07 15:51 - SELECT SCHEMA_NAME(udf.schema_id) AS [Schema], udf.name AS [Name], udf.object_id AS [ID], (case when 'FN' = udf.type then 1 when 'FS' = udf.type then 1 when 'IF' = udf.type then 3 when 'TF' = udf.type then 2 when 'FT' = udf.type then 2 else 0 end) AS [FunctionType], CASE WHEN udf.type IN ('FN','IF','TF') THEN 1 WHEN udf.type IN ('FS','FT') THEN 2 ELSE 1 END AS [ImplementationType], CAST( case
4 master 1 0.1 106.1 113.8 85497 2026-10-07 15:51 - SELECT SCHEMA_NAME(sp.schema_id) AS [Schema], sp.name AS [Name], sp.object_id AS [ID], CAST( case when sp.is_ms_shipped = 1 then 1 when ( select major_id from sys.extended_properties where major_id = sp.object_id and minor_id = 0 and class = 1 and name = N'microsoft_databas
5 master 1 0.1 98.3 111.2 27127 2026-10-07 15:51 Optimizer timeout INSERT #DbDesign (DBName, UserTables, Heaps, UnusedIndexes, DisabledIndexes, HypotheticalIndexes, UntrustedFKs, UntrustedChecks, StaleStats) SELECT DB_NAME(), (SELECT COUNT(*) FROM sys.tables WHERE is_ms_shipped = 0), (SELECT COUNT(*) FROM sys.indexes i JOIN sys.tables t ON t.object_id = i.object_id WHERE i.type = 0 AND t.is_ms_shipped = 0), (S
6 master 1 0.1 53.4 54.1 14956 2026-10-07 15:51 Optimizer timeout INSERT #DbDesign (DBName, UserTables, Heaps, UnusedIndexes, DisabledIndexes, HypotheticalIndexes, UntrustedFKs, UntrustedChecks, StaleStats) SELECT DB_NAME(), (SELECT COUNT(*) FROM sys.tables WHERE is_ms_shipped = 0), (SELECT COUNT(*) FROM sys.indexes i JOIN sys.tables t ON t.object_id = i.object_id WHERE i.type = 0 AND t.is_ms_shipped = 0), (S
7 master 1 0.0 29.4 29.4 11242 2026-10-07 15:51 Implicit conversion; Optimizer timeout WITH ix AS ( SELECT i.object_id, i.index_id, i.name, (SELECT CONVERT(nvarchar(10), ic.column_id) + CASE ic.is_descending_key WHEN 1 THEN N'd,' ELSE N'a,' END FROM sys.index_columns ic WHERE ic.object_id = i.object_id AND ic.index_id = i.index_id AND ic.key_ordinal > 0 ORDER BY ic.key_ordi
8 master 1 0.0 24.1 24.1 9652 2026-10-07 15:51 Optimizer timeout INSERT #DbDesign (DBName, UserTables, Heaps, UnusedIndexes, DisabledIndexes, HypotheticalIndexes, UntrustedFKs, UntrustedChecks, StaleStats) SELECT DB_NAME(), (SELECT COUNT(*) FROM sys.tables WHERE is_ms_shipped = 0), (SELECT COUNT(*) FROM sys.indexes i JOIN sys.tables t ON t.object_id = i.object_id WHERE i.type = 0 AND t.is_ms_shipped = 0), (S
9 master 1 0.0 5.4 5.4 2572 2026-10-07 15:51 Implicit conversion; Optimizer timeout WITH ix AS ( SELECT i.object_id, i.index_id, i.name, (SELECT CONVERT(nvarchar(10), ic.column_id) + CASE ic.is_descending_key WHEN 1 THEN N'd,' ELSE N'a,' END FROM sys.index_columns ic WHERE ic.object_id = i.object_id AND ic.index_id = i.index_id AND ic.key_ordinal > 0 ORDER BY ic.key_ordi
10 master 1 0.0 4.5 4.5 2402 2026-10-07 15:51 Table scan; Optimizer timeout INSERT #DbIndexInfo (DBName, TablesManyIndexes, LargeHeaps, DuplicateIndexes) SELECT DB_NAME(), (SELECT COUNT(*) FROM (SELECT i.object_id FROM sys.indexes i JOIN sys.tables t ON t.object_id = i.object_id WHERE t.is_ms_shipped = 0 AND i.type = 2 GROUP BY i.object_id HAVING COUNT(*) > @maxIdx) x), (SELECT COU

Most frequently executed queries

Small savings on these queries multiply across every execution.

# Database Executions Total CPU (sec) Avg CPU (ms) Avg duration (ms) Avg logical reads Last run Plan warnings Query
1 master 22 0.6 28.2 47.0 10 2026-10-07 15:47 - SELECT target_data FROM sys.dm_xe_session_targets xet WITH(nolock) JOIN sys.dm_xe_sessions xes WITH(nolock) ON xes.address = xet.event_session_address WHERE xes.name = 'telemetry_xevents' AND xet.target_name = 'ring_buffer'
2 - 21 0.0 0.0 0.0 2 2026-10-06 09:13 - update #spdbdesc set dbdesc = @dbdesc where dbid = @curdbid
3 - 21 0.0 0.0 0.0 2 2026-10-06 09:13 - select @curdbid = min(dbid) from #spdbdesc where dbid > @curdbid
4 - 21 0.0 0.1 0.1 5 2026-10-06 09:13 Cursor fetch ms_crs_c1 into @name
5 Database_C 11 0.0 1.2 1.8 99 2026-10-06 09:14 Implicit conversion; Key lookup SELECT clmns.name AS [Name], clmns.column_id AS [ID], clmns.is_nullable AS [Nullable], clmns.is_computed AS [Computed], CAST(ISNULL(cik.index_column_id, 0) AS bit) AS [InPrimaryKey], clmns.is_ansi_padded AS [AnsiPaddingStatus], CAST(clmns.is_rowguidcol AS bit) AS [RowGuidCol], CAST(ISNULL(cc.is_persisted, 0) AS bit) AS [IsPersisted], ISNULL(clmns.collation_name, N'') AS [Collation], CAST(ISNULL((s
6 master 11 0.0 0.0 0.0 0 2026-10-07 15:51 - select host_platform from sys.dm_os_host_info
7 master 6 0.0 0.3 0.3 6 2026-10-07 14:07 Implicit conversion SELECT 'PolicyStore[@Name=' + quotename(CAST(serverproperty(N'Servername') AS sysname),'''') + ']' AS [Urn], CAST(serverproperty(N'Servername') AS sysname) AS [Name], CAST( (SELECT current_value FROM msdb.dbo.syspolicy_configuration WHERE name = 'Enabled') AS bit) AS [Enabled], CAST( (SELECT current_value FROM msdb.dbo.syspolicy_configuration WHERE name = 'HistoryRetentionInDays') AS i
8 master 6 0.0 0.9 0.9 2 2026-10-06 09:20 - insert into #tmp_db_ars select replica_id, group_id, replica_server_name from master.sys.availability_replicas
9 master 6 0.0 0.1 0.1 0 2026-10-06 09:20 - insert into #tmp_db_ags select group_id, name from master.sys.availability_groups
10 master 6 0.0 0.1 0.1 0 2026-10-06 09:20 - insert into #tmp_db_hadr_dbrs select group_database_id, synchronization_state, is_local, group_id, database_id from master.sys.dm_hadr_database_replica_states

Long-running queries at the time of the check

User requests that had been running for more than 5 minutes when the health check ran.

No long-running queries at the time of the check.

Missing index suggestions

Indexes SQL Server reports it would have used. Review each one before creating it; these suggestions are often redundant.

No missing index suggestions.

Index and design indicators

Counts of objects that commonly cause performance or data-quality problems. Unused-index counts are based on activity since the last restart.

Database Tables Heaps (large) Unused indexes Duplicate indexes Tables with > 10 indexes Disabled / hypothetical indexes Untrusted constraints Stale statistics Query Store
Database_A 72 3 (0) 0 1 0 0 / 0 0 0 OFF
Database_B 0 0 (0) 0 0 0 0 / 0 0 0 READ_WRITE
Database_C 13 5 (0) 0 6 0 0 / 0 16 0 OFF

Duplicate indexes

Indexes with exactly the same key columns as another index on the same table. Every extra index slows down inserts, updates and deletes.

Database Table Duplicate index Same keys as Key columns
Database_A [Schema_A].[Table_A] Index_A Index_B Column_A
Database_C [dbo].[Table_B] Index_C Index_D Column_B
Database_C [dbo].[Table_B] Index_E Index_F Column_C
Database_C [dbo].[Table_C] Index_G Index_H Column_D
Database_C [dbo].[Table_C] Index_I Index_J Column_E
Database_C [dbo].[Table_D] Index_K Index_L Column_F
Database_C [dbo].[Table_D] Index_M Index_N Column_G

File autogrowth events

Data and log file growth events recorded in the default trace. Frequent or slow growth events pause activity in the database. The default trace currently covers events since 2026-10-06 08:45.

Database File Event Count Total growth (MB) Avg duration (ms) Max duration (ms) Most recent
master mastlog Log file autogrow 5 1 5 10 2026-10-06 08:45
model_replicatedmaster replicatedmasterlog Log file autogrow 3 0 5 7 2026-10-06 08:45
msdb MSDBData Data file autogrow 1 1 3 3 2026-10-06 08:45
msdb MSDBLog Log file autogrow 1 0 3 3 2026-10-06 08:45

Index fragmentation

Indexes larger than the configured minimum size with high average fragmentation (LIMITED scan).

Fragmentation scan not included (set @IncludeFragmentation = 1 to enable; it can take several minutes on large databases).

Database performance settings

Database options that influence query performance and concurrency.

Database Compat. level Read committed snapshot Snapshot isolation Async stats update Forced parameterization Delayed durability MAXDOP (database) Legacy CE Parameter sniffing
Database_A 140 OFF OFF OFF OFF DISABLED 0 OFF ON
Database_B 170 OFF OFF OFF OFF DISABLED 0 OFF ON
Database_C 150 OFF OFF OFF OFF DISABLED 0 OFF ON
05 / Security review

Security

We identified 9 security findings (0 critical, 1 warning, 8 advisory). This review covers who can access the server and its databases, how much access they have, and how that access is protected and audited.

Mixed mode
Authentication
SQL logins allowed
1
Full-control logins
sysadmin / CONTROL SERVER, excl. sa and services
0
Security admins
Can grant themselves sysadmin
Enabled, not renamed
Built-in sa account
Most attacked account
1
Enabled SQL logins
0 with weak passwords
Not tracked
Inactive logins
No login in 90+ days
0 / 0
Orphaned users / logins
DB users without login / deleted AD accounts
0
db_owner members
Across user databases, excl. dbo
0 of 3
Encrypted databases (TDE)
Data at rest
0
Failed logins
Last 7 days
No SQL Audit
Auditing
Login auditing: failures

Security findings

ID Severity Area Finding Affected / details Recommendation
ECDS_303 Warning Security The sa login is enabled
  • sa: The well-known sa account is enabled and is a common target for password attacks.
Disable or rename sa and use named administrator accounts.
ECDS_341 Advisory Security Databases owned by individual logins
  • Database_A: Owner: SQLSERVER01\User_123.
  • Database_B: Owner: SQLSERVER01\User_123.
  • Database_C: Owner: SQLSERVER01\User_123.
If this person's account is removed, jobs and features that rely on the database owner can fail. Change the owner to a dedicated low-privilege login or sa.
ECDS_344 Advisory Security Databases are not encrypted at rest
  • 3 user database(s) do not use Transparent Data Encryption.
If databases hold personal or regulated data, consider TDE (Enterprise edition, or Standard 2019+) and encrypted backups.
ECDS_346 Advisory Security Encrypted connections are not enforced
  • Force Encryption is off in SQL Server Configuration Manager.
Install a trusted certificate and enable Force Encryption so all client traffic is encrypted.
ECDS_339 Advisory Security High-risk database permissions granted directly
  • msdb: dc_admin: IMPERSONATE on USER::MS_DataCollectorInternalUser
Permissions such as CONTROL, IMPERSONATE or ALTER ANY USER give near-owner rights. Grant through roles and only where needed.
ECDS_321 Advisory Security Login activity is not tracked
  • SQL Server does not record when a login was last used, and login auditing is not turned on, so inactive user accounts cannot be identified.
We recommend turning on login auditing so inactive users can be tracked and removed. Ask Everconnect about this functionality.
ECDS_313 Advisory Security Mixed-mode authentication is enabled
  • SQL Server accepts both Windows and SQL logins.
If all applications support Windows/Entra authentication, switch to Windows-only authentication.
ECDS_324 Advisory Security No server audit is configured
  • There is no SQL Server Audit for logins, permission changes or data access.
Configure SQL Server Audit for security events, especially if you have compliance requirements (PCI, HIPAA, SOX).
ECDS_314 Advisory Security SQL login passwords never expire
  • sa: CHECK_EXPIRATION is OFF; password last changed 2026-10-06.
Enable password expiration for user logins, or rotate application passwords on a schedule.

Security details

Privileged logins

Logins with full control of the server (sysadmin or CONTROL SERVER).

Login Type Access Enabled Created
##MS_PolicySigningCertificate## CERTIFICATE_MAPPED_LOGIN CONTROL SERVER Yes 2025-10-21
SQLSERVER01\User_123 WINDOWS_LOGIN sysadmin Yes 2026-10-06
NT Service\MSSQLSERVER WINDOWS_LOGIN sysadmin Yes 2026-10-06
NT SERVICE\SQLSERVERAGENT WINDOWS_LOGIN sysadmin Yes 2026-10-06
NT SERVICE\SQLWriter WINDOWS_LOGIN sysadmin Yes 2026-10-06
NT SERVICE\Winmgmt WINDOWS_LOGIN sysadmin Yes 2026-10-06
sa SQL_LOGIN sysadmin Yes 2003-04-08

Logins by access level

Every server login, ordered from most to least privileged.

Login Type Access level Server roles Enabled Created Password last set Policy / expiration Default database Last activity
SQLSERVER01\User_123 WINDOWS_LOGIN Full control (sysadmin) sysadmin Yes 2026-10-06 - - master Not tracked
sa SQL_LOGIN Full control (sysadmin) sysadmin Yes 2003-04-08 2026-10-06 On / Off master Not tracked
NT Service\MSSQLSERVER WINDOWS_LOGIN Full control (sysadmin) - service account sysadmin Yes 2026-10-06 - - master Not tracked
NT SERVICE\SQLSERVERAGENT WINDOWS_LOGIN Full control (sysadmin) - service account sysadmin Yes 2026-10-06 - - master Not tracked
NT SERVICE\SQLWriter WINDOWS_LOGIN Full control (sysadmin) - service account sysadmin Yes 2026-10-06 - - master Not tracked
NT SERVICE\Winmgmt WINDOWS_LOGIN Full control (sysadmin) - service account sysadmin Yes 2026-10-06 - - master Not tracked
NT AUTHORITY\SYSTEM WINDOWS_LOGIN Standard - service account - Yes 2026-10-06 - - master Not tracked
NT SERVICE\SQLTELEMETRY WINDOWS_LOGIN Standard - service account - Yes 2026-10-06 - - master 2026-10-07 15:47 (Connected now)

Server role membership

Members of fixed and user-defined server roles. securityadmin is effectively equivalent to sysadmin because it can grant itself any permission.

Server role Member Type Enabled
sysadmin SQLSERVER01\User_123 WINDOWS_LOGIN Yes
sysadmin NT Service\MSSQLSERVER WINDOWS_LOGIN Yes
sysadmin NT SERVICE\SQLSERVERAGENT WINDOWS_LOGIN Yes
sysadmin NT SERVICE\SQLWriter WINDOWS_LOGIN Yes
sysadmin NT SERVICE\Winmgmt WINDOWS_LOGIN Yes
sysadmin sa SQL_LOGIN Yes

Explicit server permissions

Server-level permissions granted directly to logins (excluding the defaults every login has).

No explicit server permissions.

Login activity

SQL Server does not record when a login was last used, and login auditing is not turned on, so only currently connected logins can be shown as active. We recommend turning on login auditing so inactive users can be tracked; ask Everconnect about this functionality.

Login Type Access level Created Last activity Status
SQLSERVER01\User_123 WINDOWS_LOGIN Full control (sysadmin) 2026-10-06 - Unknown - login activity not tracked
sa SQL_LOGIN Full control (sysadmin) 2003-04-08 - Unknown - login activity not tracked

Database principal issues

No issues found.

Database users by access level

Users in each database and the highest level of access they have through role membership.

Database User Login Type Access level Roles Can connect
master dbo sa SQL_USER / INSTANCE Owner (dbo) db_owner Yes
model dbo sa SQL_USER / INSTANCE Owner (dbo) db_owner Yes
msdb dbo sa SQL_USER / INSTANCE Owner (dbo) db_owner Yes
msdb MS_DataCollectorInternalUser - SQL_USER / NONE Custom role db_ssisoperator, dc_admin, SQLAgentUserRole Yes
Database_A dbo - WINDOWS_USER / WINDOWS Owner (dbo) db_owner Yes
Database_B dbo SQLSERVER01\User_123 WINDOWS_USER / WINDOWS Owner (dbo) db_owner Yes
Database_C dbo - WINDOWS_USER / WINDOWS Owner (dbo) db_owner Yes

Elevated database permissions

High-risk permissions granted directly to database users (outside of roles).

Database Grantee Type Permission On State
msdb dc_admin DATABASE_ROLE IMPERSONATE USER::MS_DataCollectorInternalUser GRANT

Database ownership and trust

Who owns each database. Databases owned by individual people break when that account is removed; TRUSTWORTHY databases owned by a sysadmin are a privilege-escalation risk.

Database Owner Owner is sysadmin TRUSTWORTHY db_owner members (excl. dbo)
master sa Yes OFF 0
model sa Yes OFF 0
msdb sa Yes ON 0
Database_A SQLSERVER01\User_123 Yes OFF 0
Database_B SQLSERVER01\User_123 Yes OFF 0
Database_C SQLSERVER01\User_123 Yes OFF 0

Encryption

Transparent Data Encryption (data at rest) status per database and the certificates that protect it.

Database TDE status Algorithm Protected by Certificate expires Certificate backed up
Database_A Not encrypted - - - -
Database_B Not encrypted - - - -
Database_C Not encrypted - - - -

Attack surface configuration

Features that widen the attack surface when enabled.

Setting Current Recommended Why it matters
xp_cmdshell 0 0 Runs operating-system commands from SQL Server.
Ole Automation Procedures 0 0 Runs COM objects inside SQL Server.
Ad Hoc Distributed Queries 0 0 OPENROWSET/OPENDATASOURCE to arbitrary servers.
clr enabled 0 As needed Runs .NET code inside SQL Server.
clr strict security 1 1 Requires CLR assemblies to be signed.
cross db ownership chaining 0 0 Lets permissions flow across databases.
contained database authentication 0 0 Users authenticate inside a database, outside server login policy.
scan for startup procs 0 0 Runs procedures automatically at startup.
remote access 1 0 Legacy remote procedure calls between servers (deprecated).
external scripts enabled 0 0 Runs R/Python scripts inside SQL Server.
Database Mail XPs 0 As needed Needed for alert e-mails; can also be used to send data out.
remote admin connections 0 1 Emergency admin connection (recommended ON, restricted by firewall).
c2 audit mode 0 0 Legacy heavy auditing; replaced by SQL Server Audit.
Authentication mode Mixed Windows only SQL logins rely on passwords stored in SQL Server.
Force encryption Off On Encrypts all client connections.
Built-in administrator (sa) sa (enabled) Renamed and disabled Most common password-guessing target.

Linked servers

Connections from this server to other servers and the credentials they use.

No linked servers.

Auditing and compliance

How security events are recorded on this server.

Item Current Recommendation
Login auditing Failed logins only At least failed logins
SQL Server Audit (enabled audits) 0 Audit logins, permission changes and sensitive data access
Server audit specifications None Include SUCCESSFUL_LOGIN_GROUP, FAILED_LOGIN_GROUP and permission-change groups
Default trace Enabled Enabled
Failed logins (last 7 days) 0 Investigate repeated failures
Login history available No Turn on login auditing to track inactive users (ask Everconnect)
06 / Technical details

Technical details

Supporting data for the findings: server and database configuration, storage, backups, availability and logs.

Server overview

Property Value
Server name SQLSERVER01
Platform SQL Server (on-premises / IaaS)
Product SQL Server 2025
Edition Standard Developer Edition (64-bit)
Build 17.0.1000.7 RTM
Host operating system Windows 10 Pro 10.0
Virtualization HYPERVISOR
Logical CPUs 16
Physical memory 31.6 GB
Memory model CONVENTIONAL
SQL Server started 2026-10-06 08:50:30
Uptime 1 days 7 hours
Server collation SQL_Latin1_General_CP1_CI_AS
Failover cluster No
Always On enabled No
Authentication Mixed (Windows + SQL logins)
Database scope All databases
Max server memory 23168 MB
Page life expectancy 111659 seconds
Locked pages in memory Not in use
SQL Server (MSSQLSERVER) Running / Automatic / NT Service\MSSQLSERVER
SQL Server Agent (MSSQLSERVER) Stopped / Manual / NT Service\SQLSERVERAGENT
Global trace flags None
Windows power plan Balanced

Instance configuration

Key server settings compared with recommended values.

Setting Configured In use Recommended
max server memory (MB) 23168 23168 About 28215 (RAM 32311 MB)
min server memory (MB) 0 16 Usually 0 or below max
max degree of parallelism 8 8 Cores per NUMA node, max 8
cost threshold for parallelism 5 5 30 - 50
optimize for ad hoc workloads 0 0 1
backup compression default 0 0 1
backup checksum default 0 0 1
remote admin connections 0 0 1
priority boost 0 0 0
lightweight pooling 0 0 0
default trace enabled 1 1 1
xp_cmdshell 0 0 0
Ole Automation Procedures 0 0 0
Ad Hoc Distributed Queries 0 0 0
cross db ownership chaining 0 0 0
clr enabled 0 0 0 unless needed
clr strict security 1 1 1
scan for startup procs 0 0 0 unless needed
contained database authentication 0 0 0 unless needed
max worker threads 0 0 0
affinity mask 0 0 0
fill factor (%) 0 0 0
query governor cost limit 0 0 0

TempDB configuration

TempDB is shared by every database; poor configuration causes server-wide contention.

File Type Path Size (MB) Autogrowth
temp2 ROWS E:\SQLServer\TempDB\tempdb_mssql_2.ndf 256 256 MB
temp3 ROWS E:\SQLServer\TempDB\tempdb_mssql_3.ndf 256 256 MB
temp4 ROWS E:\SQLServer\TempDB\tempdb_mssql_4.ndf 256 256 MB
temp5 ROWS E:\SQLServer\TempDB\tempdb_mssql_5.ndf 256 256 MB
temp6 ROWS E:\SQLServer\TempDB\tempdb_mssql_6.ndf 256 256 MB
temp7 ROWS E:\SQLServer\TempDB\tempdb_mssql_7.ndf 256 256 MB
temp8 ROWS E:\SQLServer\TempDB\tempdb_mssql_8.ndf 256 256 MB
tempdev ROWS E:\SQLServer\TempDB\tempdb.mdf 256 256 MB
templog LOG E:\SQLServer\TempDB\templog.ldf 256 64 MB

Trace flags

Trace flags change how the engine behaves. A few are widely recommended, some are risky, and any flag switched on with DBCC TRACEON is lost at the next restart unless it is also a startup parameter.

Trace flag State Set at startup What it does Assessment
1222 Off - Writes deadlock details (as XML) to the SQL Server error log. Recommended - Recommended on every server so deadlocks can be investigated from the error log.
3226 Off - Stops successful backup messages from being written to the error log. Recommended - Recommended so the error log stays readable. Failed backups are still logged.

Deprecated feature usage

Features Microsoft has announced will be removed from SQL Server. Counts are cumulative since the last restart (uptime 1 days), so a recently restarted server under-reports. They show how ready the databases and applications are for an upgrade.

Deprecated feature Uses since last restart
DATABASEPROPERTYEX('IsFullTextEnabled') 21
sysfiles 21
String literals as column aliases 8
sysdatabases 6
XP_API 6
Database compatibility level 140 2
Database compatibility level 150 2
sp_db_vardecimal_storage_format 1
sysprocesses 1
sysusers 1

Database inventory

Database State Recovery model Compat. level Data size (GB) Log size (GB) Log used % Owner Last good CHECKDB
master ONLINE SIMPLE 170 0.00 0.00 46 sa Never
model ONLINE FULL 170 0.01 0.01 9 sa Never
msdb ONLINE SIMPLE 170 0.02 0.00 56 sa Never
Database_A ONLINE SIMPLE 140 0.26 0.13 4 SQLSERVER01\User_123 Never
Database_B ONLINE SIMPLE 170 0.06 0.06 1 SQLSERVER01\User_123 Never
Database_C ONLINE SIMPLE 150 1.95 0.98 8 SQLSERVER01\User_123 Never

Database files and growth settings

Database Logical name Type Path Size (MB) Used (MB) Autogrowth Max size VLFs
Database_A Database_A ROWS E:\SQLServer\Data\Database_A.mdf 264 204 64 MB Unlimited -
Database_A Database_A_log LOG E:\SQLServer\Logs\Database_A_log.ldf 136 6 64 MB Unlimited 12
Database_B Database_B ROWS E:\SQLServer\Data\Database_B.mdf 64 4 64 MB Unlimited -
Database_B Database_B_log LOG E:\SQLServer\Logs\Database_B_log.ldf 64 1 64 MB Unlimited 4
master master ROWS E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\master.mdf 5 4 10 % Unlimited -
master mastlog LOG E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2 1 10 % Unlimited 8
model modeldev ROWS E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\model.mdf 8 3 64 MB Unlimited -
model modellog LOG E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\modellog.ldf 8 1 64 MB Unlimited 3
msdb MSDBData ROWS E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf 16 15 10 % Unlimited -
msdb MSDBLog LOG E:\SQLServer\MSSQL17.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf 1 0 10 % Unlimited 3
Database_C Database_C ROWS E:\SQLServer\Data\Database_C.mdf 2000 8 1000 MB Unlimited -
Database_C Database_C_log LOG E:\SQLServer\Logs\Database_C_log.ldf 1000 81 500 MB Unlimited 16

Backup status

Most recent backups recorded in msdb on this server.

Database Recovery model Last full Last differential Last log Full size (MB, compressed) Last full backup destination
master SIMPLE 2026-10-07 00:23 - n/a (SIMPLE) 4.0 {8D2F6A41-5C3B-4E7A-9B10-3E5A7C2D9F04}6
model FULL 2026-10-07 00:23 - Never 2.7 {8D2F6A41-5C3B-4E7A-9B10-3E5A7C2D9F04}1
msdb SIMPLE 2026-10-07 00:23 - n/a (SIMPLE) 14.6 {8D2F6A41-5C3B-4E7A-9B10-3E5A7C2D9F04}2
Database_A SIMPLE 2026-10-07 00:23 - n/a (SIMPLE) 203.6 {8D2F6A41-5C3B-4E7A-9B10-3E5A7C2D9F04}5
Database_B SIMPLE 2026-10-07 00:23 - n/a (SIMPLE) 4.3 {8D2F6A41-5C3B-4E7A-9B10-3E5A7C2D9F04}3
Database_C SIMPLE 2026-10-07 00:23 - n/a (SIMPLE) 10.4 {8D2F6A41-5C3B-4E7A-9B10-3E5A7C2D9F04}4

SQL Agent job failures

Jobs that failed in the last 7 days.

No failed jobs.

High availability status

Failover cluster: No. Database mirroring sessions: 0. Log shipping databases: 0.

No high availability features detected.

Disk / storage capacity

Volume Label Total (GB) Free (GB) Free %
E:\ SQLServer 952.6 838.6 88.0

Error log highlights

Notable messages from the SQL Server error log over the last 7 days.

Search pattern Occurrences Most recent Latest message
is full 1 2026-10-06 08:47 The current event was not reported to the operating system error log. Operating system error = 1717(The interface is unknown.). You may need to clear the operating system error log if it is full.

Checks that could not be completed

Usually caused by insufficient permissions or a feature not available on this platform.

All checks completed.

Next steps

How Everconnect can help

Many of the issues in this report are common, and most can be fixed quickly by an experienced DBA. Everconnect Data Systems' DBA team can resolve them and keep your SQL Server environment protected, secure and fast.

  • Corruption detection and integrity-check scheduling, and recovery if corruption is found
  • Security hardening: logins, permissions, encryption and auditing
  • Performance tuning of queries, indexes and server resources
  • Best-practice configuration of the instance, TempDB and databases
  • Capacity planning and storage configuration
  • Proactive monitoring, alerting and automated maintenance
  • Patching, upgrade and migration planning (including Azure)
  • Login auditing to track and clean up inactive user accounts

Learn more at EverconnectDS.com or order the SQL Server Health Check ($499 per server).