View Event: New features in Management Studio — Performance Troubleshooting made easier! SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools, which enabled rapid enhancement to the Execution Plan.Do you know that now you can see how many pages are spilled to disk for a […]
This is a session about new features in SQL Server Management Studio and runtime data exposed via showplan. Microsoft’s goal is to make showplan, one stop shop for query performance troubleshooting. I presented the session to following user groups and events. Rhode Island SQL Server User Group on February 07, 2018 PASS DBA Virtual Chapter on […]
Last week I blogged about increasing retention of System Health session files. In this post I will show how you can open multiple files at once and work with the data as one set. If you select multiple System Health extended event files (with extension .xel) and click open each file will open in separate […]
As per Microsoft’s books online The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server Database Engine starts, and runs without any noticeable performance effects. The session collects system data that you can use to help troubleshoot performance issues in the […]
