SQLRx Windows Hardware & Software Performance Analysis is the culmination of proven industry "best practices" and years of experience optimizing database and system architecture and performance. We deliver a detailed analysis identifying specific system hardware and SQL Server software bottlenecks with a prioritized list of suggested resolutions and cost-benefit estimates. Analysis of both hardware and software enables SQLRx to provide clients with the added benefits of extending the life of existing hardware and improving application performance.
SQLRx utilizes a wide-ranging set of procedures, perfected over 1,500 customer studies, to provide the customer with all the information needed to understand their current system's performance.
Through the analysis of BOTH hardware and software, SQLRx develops a comprehensive view of the entire system.
We collect performance data from:
We load performance data into our software suite, WinPerf, which is designed and coded specifically to enable fast, high quality performance analyses.
This software enabled SQLRx to win the Microsoft Partner of the Year for Data Management award.
We extract performance data into several hundred Excel worksheets and generate many timeseries graphs.
We analyze the extracted data to determine the following:
Processor, memory, and disk hardware usage patterns and problem areas
The worst 100 database queries by total and average:
Queries that are:
Database views that are used in queries that consume the most system resources
Database tables that:
Software bottlenecks, e.g., blocking and deadlocking
…evaluation was thorough and recommendations made an extremely positive impact on the performance of our system.
…recommendations were concise and clear. During implementation, noticeable performance improvements were recognized ... follow-up documentation and availability added to the excellent work … will definitely look to ... for any future SQL Server performance tuning needs.
Baton Rouge, LA