More Showplan enhancements – Row Goal

As I shared before, we have been working for over a year to make showplan the one-stop-shop for query performance analysis and troubleshooting (as much as possible). With the recent release of SQL Server 2017 CU3, we released yet more showplan enhancements: you can see other posts related to showplan enhancements here. In this article…

0

New in SSMS: Query Performance Troubleshooting made easier!

The community already uses tools that can make it easier to read and analyze query plans (including SSMS), but these require significant expertise in understanding query processing and plans in order to be able to actually find and fix root causes. In the latest version of SSMS that released last week, we debut a new…


Developers Choice: Query progress – anytime, anywhere

Edit (4/23/2018): due to a possible random AV running your favorite monitoring stored procedure, please make sure you install KB 4078596 in your SQL Server 2016 and SQL Server 2017. 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…


Developers Choice: USE HINT query hints

The use of Trace Flags has always been understood as a sort of ‘hack’, and a solution that is hard to manage and sometimes understand (namely because it depends on a number). Over the years, users have seen several knobs added to SQL Server to influence the Query Optimizer. These trace flags are documented in…

2

#AskSQLTiger Twitter Chat on June 27

Have you ever wanted the opportunity to ask the MSSQLTIGER team about SQL Server? Join the SQL Server Tiger team for a Twitter Chat on Monday, June 27th from 10 -11 AM PST. You can ask anything about Query Performance on SQL Server for our first Twitter chat.  All you need is a Twitter account…

0