Pyn Logic unveils database performance tool

WELLINGTON, NEW ZEALAND: Pyn Logic LLC, a provider in security and performance solutions for SQL Server, recently announced the launch of Enzo Audit for development organizations and Independent Software Vendors (ISVs).

This new solution could 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 an organization develops SQL Server code for internal use or for customers, controlling poor performing database code proliferation is always a challenge, said a press release.

"Large software development organizations have a difficult time managing their database performance objectives and meeting customer expectations" explained Herve Roggero, Managing Partner of Pyn Logic.

He added, "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."

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, said the release.

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.

The solution 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, the release added.