Software Developers Can Now Detect Poor Performing Database Code Instantly with Enzo Audit

Share Article

Enzo Audit helps development departments detect database performance problems before customers do. Reducing database performance issues not only improves customer satisfaction, but it can help your company reduce support calls. Enzo Audit achieves this by moving the discovery of poor performing SQL Server queries as early in the development lifecycle as possible: when the SQL code is first created.

Most solutions available today address performance problems once they are already in production. With Enzo Audit, companies have a fighting chance to prevent them in the first place.

With Enzo Audit and its client-side popup alerting technology, development organizations and Independent Software Vendors (ISVs) can give developers the tools necessary to know instantly if their SQL code (embedded SQL, Views, Stored Procedures...) violates established performance thresholds, collaborate with senior developers and DBAs, and take corrective action immediately.

Whether your organization develops SQL Server code for internal use or for customers, controlling poor performing database code proliferation is always a challenge. The difficulty lies in three primary areas:

  • Early Detection and Tracking

The first challenge developers face is visibility: is the query slow because the database is busy, or is the network slow? Enzo Audit provides actual database performance metrics so that the developer is alerted instantly (through a popup window) if the query is performing poorly. Developers can save the evidence for future resolution or share it with other developers and DBAs.

  • Established Performance Guidelines

The second challenge developers typically face is related to guidelines: what is considered poor performance? Since complex SQL code can be difficult to improve, it is important to provide clear guidelines to developers on what is considered good enough or not acceptable. With Enzo Audit development departments can establish clear guidelines that are used to trigger popup alerts on developer's workstations.

  • Progress Report

Development managers also face multiple challenges when it comes to database performance: is the code ready for release? What are the unresolved performance issues? What is the overall progress from the previous release? Enzo Audit comes with three reports that provide enough information to give management teams the necessary information to answer these questions, providing better visibility into a product's actual performance footprint.

"Large software development organizations have a difficult time managing their database performance objectives and meeting customer expectations" explains Herve Roggero, Managing Partner of Pyn Logic. "Most solutions available today address performance problems once they are already in production. With Enzo Audit, companies have a fighting chance to prevent them in the first place."

OPPORTUNITY: Reduce Support Costs
The size of a support department largely depends on the overall quality of software products found in customer production environments. Creating poor performing SQL code can yield to more expensive support operations and may require dedicated support engineers knowledgeable in database performance tuning. As most quality assurance professionals can attest, detecting defects early in the software development lifecycle (SDLC) reduces overall support costs.

With Enzo Audit, development organizations can provide enough information to developers to detect and fix database performance early in the development lifecycle, before the code is ever released in production. Over time, managers can refine established performance thresholds to continuously improve a system's performance objectives, hence improving customer satisfaction and reducing database performance-related support costs.

Enzo Audit offers many features that allow software departments to take control of their SQL Server performance objectives. Enzo Audit is designed as a hub-and-spoke system and as such scales to dozens of developers easily without impacting database performance.

Try Enzo Audit for free for 30 days by visiting Pyn Logic at http://www.pynlogic.com.

About Pyn Logic
Pyn Logic LLC, headquartered in Wellington, Florida, combines deep technology expertise and strong management consulting to develop unique security and performance solutions for SQL Server. For more information go to http://www.Pynlogic.com or email at info(at)Pynlogic.com.

###

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Herve Roggero
Visit website