| 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. |
What we found
The most important results of this review in plain language. Details for each item follow in the sections below.
- Data Integrity: Corruption checks are missing or have found problems. Corruption can spread silently into backups until it can no longer be repaired.
- Security: Security settings do not follow best practice and widen the attack surface.
- Configuration: Several server settings are at defaults that are known to hurt stability or performance.
- Storage: Storage capacity, latency or file settings need attention.
- Monitoring & Maintenance: Failures can go unnoticed because jobs are failing or alerts and notifications are not configured.
- Platform & Patching: The server is missing updates or is approaching end of support.
Top priorities
- Critical Integrity check (DBCC CHECKDB) has never run (3 items)ECDS_201
- Warning The sa login is enabledECDS_303
- Warning Cost threshold for parallelism is at the default (5)ECDS_604
- Warning Instant file initialization is disabledECDS_616
- Warning Files grow by a percentage (2 items)ECDS_803
- Warning Database or log ran out of spaceECDS_814
- Warning Critical error alerts are not configuredECDS_905
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.
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 |
|
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 |
|
Disable or rename sa and use named administrator accounts. |
| ECDS_604 | Warning | Configuration | Cost threshold for parallelism is at the default (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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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) |
|
Apply the latest cumulative update. Many performance and stability fixes ship only in CUs. |
| ECDS_108 | Advisory | Backup & Recovery | Backups taken without CHECKSUM |
|
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 |
|
Untrusted constraints may hide invalid data and prevent query optimizations. Re-validate them WITH CHECK. |
| ECDS_341 | Advisory | Security | Databases owned by individual logins |
|
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 |
|
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 |
|
Install a trusted certificate and enable Force Encryption so all client traffic is encrypted. |
| ECDS_339 | Advisory | Security | High-risk database permissions granted directly |
|
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 |
|
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 |
|
If all applications support Windows/Entra authentication, switch to Windows-only authentication. |
| ECDS_324 | Advisory | Security | No server audit is configured |
|
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 |
|
Enable password expiration for user logins, or rotate application passwords on a schedule. |
| ECDS_404 | Advisory | High Availability | No high availability or standby server |
|
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 |
|
Duplicate indexes double the write cost and storage for no read benefit. Consolidate them. |
| ECDS_540 | Advisory | Performance | Query Store is not enabled |
|
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 |
|
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 |
|
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 |
|
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 |
|
Enable "backup checksum default" so every backup verifies page checksums. |
| ECDS_607 | Advisory | Configuration | Backup compression is not on by default |
|
Compressed backups are smaller and usually faster. Enable "backup compression default". |
| ECDS_605 | Advisory | Configuration | Optimize for ad hoc workloads is off |
|
Enabling this setting is low-risk and saves plan cache memory. |
| ECDS_609 | Advisory | Configuration | Remote dedicated admin connection (DAC) is disabled |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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. |
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.
Performance findings
| ID | Severity | Area | Finding | Affected / details | Recommendation |
|---|---|---|---|---|---|
| ECDS_532 | Advisory | Performance | Duplicate indexes |
|
Duplicate indexes double the write cost and storage for no read benefit. Consolidate them. |
| ECDS_540 | Advisory | Performance | Query Store is not enabled |
|
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 |
|
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 |
|
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 |
|
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.
| 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 |
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.
Security findings
| ID | Severity | Area | Finding | Affected / details | Recommendation |
|---|---|---|---|---|---|
| ECDS_303 | Warning | Security | The sa login is enabled |
|
Disable or rename sa and use named administrator accounts. |
| ECDS_341 | Advisory | Security | Databases owned by individual logins |
|
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 |
|
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 |
|
Install a trusted certificate and enable Force Encryption so all client traffic is encrypted. |
| ECDS_339 | Advisory | Security | High-risk database permissions granted directly |
|
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 |
|
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 |
|
If all applications support Windows/Entra authentication, switch to Windows-only authentication. |
| ECDS_324 | Advisory | Security | No server audit is configured |
|
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 |
|
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) |
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.
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).