Phoenix - Your AI AssistantSQL Server Database Audit & Health Check Report
Delivery in
2 days
- Views 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will audit your SQL Server instance and deliver a comprehensive health check report covering database file configuration, index fragmentation, missing indexes, outdated statistics, blocking and deadlock history, backup status, security permissions, and configuration settings deviating from SQL Server best practices. SQL Server instances configured at installation and never formally reviewed accumulate performance debt — fragmented indexes, missing indexes on heavily queried columns, and auto-growth events from undersized data files — that compounds into observable performance degradation over time.
The report covers instance and database configuration, disk I/O and memory pressure indicators, top-performing and worst-performing queries from Query Store or DMVs, blocking session history, backup and recovery configuration, login and permission audit, and database mail and alerting configuration. Each finding is prioritised by impact with specific remediation T-SQL or configuration change.
Ideal for DBA teams, IT managers, and businesses whose SQL Server is experiencing performance issues or approaching a critical project, audit, or upgrade.
The report covers instance and database configuration, disk I/O and memory pressure indicators, top-performing and worst-performing queries from Query Store or DMVs, blocking session history, backup and recovery configuration, login and permission audit, and database mail and alerting configuration. Each finding is prioritised by impact with specific remediation T-SQL or configuration change.
Ideal for DBA teams, IT managers, and businesses whose SQL Server is experiencing performance issues or approaching a critical project, audit, or upgrade.
What the Freelancer needs to start the work
Please provide SQL Server sysadmin access (or equivalent diagnostic permissions), your SQL Server version and edition, the databases in scope, any known performance issues or error log entries, and your backup and recovery requirements.