SQL Xray ™

Applications normally use hundreds, if not thousands of queries, and searching each one for problems is virtually impossible considering the limited time you can afford. Plus, the original developers and database administrators may have moved on to other projects and may not be readily available to help out. For problems like these, what do you do?

SQL Xray ™ provides a comprehensive solution that helps detect and free up database bottlenecks in your system. By recording all events in the production/QA/testing environment, it gives the T-SQL developers all information they need to optimize code. DBAs need only to start SQL Xray™ Activity Recorder, allow time for processing, and gather the results. There is no need to understand the underlying complicated concepts, as Activity Viewer will indicate what and where the problems can be found.

Consisting of two components, Activity Recorder and Activity Viewer, SQL Xray ™ is a compact, intuitive and user-friendly application that can save you hundreds of hours in manually identifying, testing and rewriting potentially problematic T-SQL codes during the development stage and even after post production release. The resulting improvements can eventually lead to savings in overhead, minimized downtimes, and costly hardware upgrades. When it comes to the SQL server administration, SQL Xray ™ offers unprecedented flexibility and responsiveness.

Program components:

SQL Xray ™ Activity Recorder goes deep into your T-SQL code and takes a profile of your database's performance. Activity Recorder provides plug-ins that allow for expansion of features like automatically renaming problematic procedures carried over from a bug caused by SQL 2000's sp_rename procedure. The software saves logged Trace events as a Deep Trace File.

SQL Xray ™ Activity Viewer is a compact reader that lets you view the Deep Trace File generated by Activity Recorder so that you can better formulate solutions to the identified issues. Information for all traced objects is displayed by Activity Viewer, including the following:

• Number of calls made by the object
• Total execution time for each object run
• Amount of time the object waits for locks
• Types of locks slowing down your system
• Places that cause delays or deadlocks

In addition, you can also run and debug code in a debugger-like environment.

A complete SQL system purchase consists of Xray Activity Recorder, Xray Activity Viewer, and the accompanying plug-ins. Its license allows you to engage in collaborative efforts in development can be maintained. It also allows you to install additional SQL Xray ™ Plug-ins, including:

• server wait causes
• memory requirements
• fragmentation dynamics
• cache top list
• modifying incorrectly renamed procedures
• lock journal