News – XML Showplan Support for Microsoft SQL Server

ProActive DBA 9.0: Focus on SQL Server

Posted: 2014-08-26

XML Showplan Support for Microsoft SQL Server

ProActive DBA 9.0 includes support for capturing XML-format query plans on running processes, as part of TimeLine’s continuous monitoring.

You can configure TimeLine to capture showplan data on running processes as part of a timed process snapshot, and/or when an alert is triggered (for example, when a long-running query occurs, or server CPU usage spikes).

Query plans are displayed using SQL Server Management Studio, with full details including I/O counts, index usage, join types and more.