New in SSMS: Searching in Showplan

Cross post with http://aka.ms/sqlserverteam Have you ever analyzed a somewhat big plan? And while doing so did you ever wish you could search for something like table name, index name or column name? In SSMS 17.2, we are including the ability to search all these and more in graphical showplan. Let’s look at an example….


Correlating xEvents with DMVs

Cross post with http://aka.ms/sqlserverteam Since the inception of xEvents there has been the need to occasionally correlate data from xEvent collections and DMVs. Specifically, using the query_hash and query_plan_hash actions and correlate with DMVs such as sys.dm_exec_requests and sys.dm_exec_query_stats for example. The blog post on Correlating XE query_hash and query_plan_hash to sys.dm_exec_query_stats in order to…


Memory grant related diagnostics

Cross post with http://aka.ms/sqlserverteam Back in March I blogged about Addressing large memory grant requests from optimized Nested Loops. To further enhance discoverability of memory grant related issues, in SQL Server 2016 and 2014 SP2 we released a new xEvent (query_memory_grant_usage). This fires at the end of query processing for all queries with a memory…


Added per-operator level performance stats for Query Processing

Cross post with https://aka.ms/sqlserverteam When you are troubleshooting query performance, metrics are never too much. With that in mind, based on customer feedback, but also our own CSS support, we have added runtime information to Showplan, and exposed a new Extended Event in SQL Server 2016 RC0. We are adding the new Showplan info and…


SQL Server Tools – Extended Events Manager & Partition Management

There are two tools available on Codeplex that you may consider to use/test: SQL Server 2008 Extended Events Manager http://extendedeventmanager.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23813 and SQL Server Partition Management http://sqlpartitionmgmt.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=23683 Cheers,