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.