DBSophic, a developer of innovative software solutions for database performance optimization, has announced the launch of its new Trace Analyzer tool for Microsoft SQL Server. This tool, which can be downloaded free of charge from the company's website, allows users to instantly find out what is slowing down their databases by enabling them to easily pinpoint which batches or specific parameter value sets consume the most resources.
DBSophic's Trace Analyzer helps database administrators quickly analyze trace events stored in multiple trace files and trace tables. Within a few minutes, the software enables the user to view all the trace events analyzed, de-parameterized, grouped and clearly arranged in a tree format and ordered by their resource consumption. The results display the total resource consumption and enable the user to drill down to specific parameter value sets.
The new product is aimed at assisting DBA professionals in analyzing database transactions in order to help them better monitor and improve the performance of their applications. The Trace Analyzer tool can save them time and effort and is completely free of charge.
"Trace Analyzer eliminates the need to read hundreds of thousands of trace file events, thus saving time and resources," Ami Levin, chief technology officer for DBSophic, tells 5 Minute Briefing. "It allows DBAs to quickly identify operations and processes that cause slow database performance and enables them to easily pinpoint the batches or statements that are consuming the most resources. Furthermore, it enables easy drill down to specific executions with parameter value sets to quickly identify execution anomalies. Lastly, it enables DBAS to determine immediately which batches are overloading their servers, and provides an overall yet detailed view providing IT managers with the opportunity to see the whole picture."
For more information and to download the free Trace Analyzer tool, go here.