SQL Server Performance Audits
Our professional SQL Server Audit Service reports problems and suggests solutions associated with:
- SQL Server Query Tuning / Optimization
- SQL Server Index Tuning / Optimization
- SQL Server Execution Plan Tuning / Optimization
- Overall Database Performance
- Data and Structural Integrity Problems
- Maintenance Issues
- Best Practices
Let Practical Computer Applications (PCApps) perform an engineering audit. Our SQL Server Engineering team will perform a thorough assessment of your SQL Server database for SQL database improvements and will identify any design and implementation issues that are impediments to your database application. Then, we recommend the appropriate remedial engineering techniques necessary for a stable, high performance SQL system that is more cost-effective to maintain and extend.
The PCApps SQL Audit methodology checks your entire database, for elements that we have known to cause problems in the past.
EXAMPLE CHART: Database Reads Vs Writes For Each Database Index
Below, we have provided an example of a chart used to highlight many problems with an existing database index design. All the indexes in the system are plotted as bubbles and show labels when you hover over the bubble. The x-axis shows the # of database reads, and the y-axis on # of writes (database updates). The axes are log-based, and we’ve put a multiplier of 10 on reads to give a “benefit of the doubt” to occasionally read tables. Those indexes in red above the diagonal are generally speaking “bad” with a lot of writing going on, and with few reads, while those in green below the line are “good”. Darker green is better, darker red is worse. The size of the bubbles indicates the size of the index
SQL Audit Example Database Reads vs Writes for each Database Index. If you’d like this type of insight into your database performance contact PCApps.
Audit Scope
The scope of the Engineering audit is the database configuration, data structures, indexes, procedures, and dynamic performance. It looks at the performance characteristics, integrity characteristics, maintainability, standards and best practices of the SQL Server Database and from this information, we can formulate recommendations for many configurations and Index changes, and will point to areas that need improvement at the code level.
Available Service Plans
| Free Plan | Professional ($5,000) | Premium ($9,000) | Custom (Contact Us) | |
|---|---|---|---|---|
| 1-Hour Expert Insight Consultation Call | ✓ | ✓ | ✓ | Upgrade SSRS to PowerBI |
| Basic Performance Review | ✓ | ✓ | ✓ | Database Replication and Clustering |
| Database Performance Checkup | ✓ | ✓ | ✓ | Temporal Table Implementation |
| Table Design Analysis | . | ✓ | ✓ | Data Archiving and Purging Strategy |
| Query Execution Plan Analysis and Optimization | . | ✓ | ✓ | SQL Server Version Upgrade and Migration |
| Database Schema Optimization | . | ✓ | ✓ | Database Security Best Practices |
| Advanced Index Analysis and Optimization | . | ✓ | ✓ | Cloud Migration Planning |
| Locking and Blocking Analysis | . | ✓ | ✓ | Custom Application Development |
| Statistics Management and Analysis | . | ✓ | ✓ | Disaster Recovery Planning |
| Advanced Query Optimization | . | . | ✓ | . |
| Data Compression Implementation | . | . | ✓ | . |
| Advanced Transaction Optimization | . | . | ✓ | . |
| In-Memory Table Usage Optimization | . | . | ✓ | . |
| Materialized Views Implementation | . | . | ✓ | . |
| I/O Optimization and Analysis | . | . | ✓ | . |
| TempDB usage Optimization | . | . | ✓ | . |
| Advanced Locking and Concurrency Control | . | . | ✓ | . |
| Database Capacity Planning | . | . | ✓ | . |
| Database Maintenance Plan Refinement | . | . | ✓ | . |