SQL Xray ™  |  Features and Benefits

Once installed and running, SQL Xray ™ can help improve your application’s performance by identifying problems even during the developmental stage. Here are some of the many features and benefits of installing SQL Xray ™:

• Easy to install, easy to operate - The relative simplicity of the interface belies its innovative design. SQL Xray ™ can be learned and mastered in the shortest time, eliminating the need to employ costly database experts that charge by the hour.
• Efficient Monitoring - The SQL Xray ™ systems allows you to find and resolve database issues more efficiently than conventional system management and diagnostic tools.
• Systematized information display - Organized data views display concise information in an easy-to read format so that problems can be easily identified without the need to constantly look up references or employ complex system commands.
• Data Sorting - Once collected, data can be sorted so that you can view information the way you prefer it.
• Improved Application Response Time and Reduced Downtimes - Once performance issues are identified and resolved, especially during initial stages, internal users can benefit from the streamlined application and experience productivity increases. For customer-facing applications, improved internal performance and lesser downtimes might mean a significant increase in customer satisfaction and greater retention.
• Debugging the live system - Xray Integrated debugger is a post factum debugger that allows you to debug code with actual data recorded from DTF files. This allows for code changing decisions based on real production server load and environment without shutting down production databases.
• Convenient, compact DTF viewer - Activity Viewer lets you view the DTF files generated by Activity Recorder quickly and easily.
• Object Explorer - Displays a list of all traced database objects (stored procedures, functions, triggers, and extend stored procedures), including name, object type, number of calls, total execution time, locks, and time spent waiting for locks.
• Object Details - Displays a wealth of information from an object's source code selected from Objects Explorer. Shows specific line per line information on execution and trace point statistics. Post factum debugger features are available when in Trace mode, showing variables and call-stack information.
• Lock Range Display -Displays raw information on locked table resources as individual events provided there are both victim process that is kept to wait from a guilty process owning the lock. Specific resource information, locks and relevant time data is displayed for these individual events.
• Wait Event List - Displays a more useful analysis of lock events by way of showing the victim procedure and statement during lock wait and the guilty procedure and statement that initiated the lock. Tables locked by the guilty procedure and lock duration are also shown.
• Deadlock Identifier - Shows all deadlocks that inherently halt your system. Displays both victim procedure and statement during lock wait and the guilty procedure and statement that initiated the lock. The time the deadlock event, locked table object and terminated process ID of the victim is also shown.
• Raw Transaction - Provides raw information on all transactions occurring in your system.
• Graph Builder - Provides graphical representation of activities in your system, including Activity and Call graphs.  
• Cache Identification - Sorts cache usage and displays it a diagram view to show how SQL server memory cache is used up.
• Fragmentation Dynamics Testing - Identifies tables with the highest fragmentation degradation rate to help you make an optimal defragmentation strategy and improve system performance more accurately.
• Memory Estimation - calculates how much performance can be gained when you add more memory
• Test Server Delay Synopsis - Provides an overview of SQL Server delay categories for reference when identifying and correcting setbacks.
• Automatic Procedure Rename - fixes name for procedures incorrectly renamed in SQL 2000.
• Lock Logger - Records locks that cause unnecessary server delays.
• Provides the most cost-effective solution - SQL Xray ™ can result in immediate ROI by eliminating the need for costly software and hardware upgrades.
• Outstanding Product Support - Most, if not all, questions and problems in the use of SQL Xray ™ can be addressed by your friendly Lakeside support personnel over the phone