At Dynamic Decisions we have decades of experience auditing systems to identify the cause of performance issues and their solutions.
We have created a multi-step approach to performance audit.
- Use standard Windows performance monitoring tools
- Use standard Microsoft SQL performance monitoring and analysis tools. and a range of custom audit scripts to identify areas for improvement.
- Run advanced statistical “root cause” impact analysis.
This performance approach is unique to Dynamic Decisions, allowing a staged performance audit and optimisation process that starts with an overview of performance and that ends with the identification of the mist granular of impact analysis.
We can identify which specific actions (such as loading a customer) impact other actions within the database. This approach means an otherwise appropriately indexed and optimised table and query – as identified by our competitors – can still be identified as a bottleneck of performance and rectified.