“The PCA crew is leagues above
the competition” - Pepsico
"a prior vendor failed to develop
the application, which (Practical) delivered." - Franklin Park
"the application (is) easier to use, with a
much simpler, more intuitive use interface" - Royal Administration Services
"Sometimes it's the things you don't ask for
that are important" - Royal Administration Services
"PCA turned our raw data and algorithms into easy to use
and understand features and reports." - CareScout
"The quality and professionalism ... has been
so outstanding that we want to send you a letter of thanks." - USALCO
"PCA people and applications stand out by
far exceeding our expectations." - USALCO
"The resulting application greatly increas(ed)...
our business effectiveness and efficiency." - The Advest Group
"PCA completes projects
efficiently and effectively" - Pepsico
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
Usually, we can acheive a 300% performance improvement in your database with simple to implement suggestions, and for really poorly optimized SQL Server databases, we can acheive orders of magnitude improvement!
Let Practical Computer Applications (PCA) perform an engineering audit. Our SQL Server Engineering team will perform a thorough assessment of your SQL Server database for SQL database improvements. We will identify any design and implementation issues that are impediments to your database application. We then recommend the appropriate remedial engineering techniques necessary for a stable, high performance SQL system that is more cost-effective to maintain and extend.
The PCA SQL Audit methodology checks the entire database, including every table, every index, every column, every procedure and function for various performance and integrity problems that we have known in the past to cause problems or otherwise not conform to best practices.
EXAMPLE CHART: Database Reads vs Writes for each Database Index
Here we provide one 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 show 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.
Several other data visualizations are constructed as part of the audit to highlight specific issues in the database.
If you’d like this type of insight into your database performance contact PCA.
The scope of the Engineering audit is the database configuration, data structures, indexes, procedures, and dynamic performance. The audit looks at the performance characteristics, integrity characteristics, maintainability, and standards and best practices of the SQL Server Database. From the audit, we can gather enough information to make recommendations for many configuration and Index changes, and will point to areas that need improvement at the code level.
Read about the process and value of a SQL Server Audit .
For more information, contact us.
Most Popular Pages
Recent Posts: Practical Blog
- Power View empowered practical Smart Client applications
- Tableau vs Qlikview and Tableau vs Spotfire
- Data, Story, View: Prototype and Update
- 2012 starts with Tableau 7.0
- SQL Server 2012 is good for Data Visualization
- Spotfire 4.0 is available
- Introduction of QlikView 11
- VisiCalc jubilee and history of Excel
- Data Visualization 2011: Omniscope 2.6
- Data Visualization 2011: Spotfire 3.3, Silver 2.0
- Data Visualization 2011: Tableau 6.1
- SQL Server 2012 is released for Preview