Extended per-operator level performance stats for Query Processing

Cross post with http://aka.ms/sqlserverteam Back in March we announced the availability of per-operator level performance stats for Query Processing (exposed in Showplan XML) with SQL Server 2014 SP2 and SQL Server 2016, such as CPU and I/O. Observe the example, where by executing the below query in AdventureWorks2014, on SQL Server 2016 SP1, we get…


Query progress: anytime, anywhere

Cross post with http://aka.ms/sqlserverteam One of the most important actions when a performance issue hits, is to get precise understanding on the workload that’s executing and how resource usage is being driven. The actual execution plan is an invaluable tool for this purpose. Query completion is a prerequisite for the availability of an actual query…