Developers Choice: USE HINT query hints

Cross post with http://aka.ms/sqlserverteam 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…

0

Developers Choice: CREATE OR ALTER

Cross post with http://aka.ms/sqlserverteam Today we are starting a new blog post series entitled “Developers Choice”. In the first few posts we will be focusing on SQL Server 2016 SP1 enhancements that focus on the developer community, including all developer DBA’s. Following in the same reasoning of simplifying DDL statements that was started by the…

0

New Showplan XML properties in SSMS October Release

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. However, SQL Server Management Studio (SSMS) did not expose this information, and so users had to look in the Showplan XML, in the…

2

24HOP – Portuguese Edition 2016

Hello all, if you’re a Portuguese speaker, come join me on 11/16 for a 24HOP session on “Gems to help you troubleshoot query performance”. Starts at 21h GMT or 19h BR. Description: SQL Server 2012 Service Pack 3, SQL Server 2014 Service Pack 2 and SQL Server 2016 introduced enhancements to support execution plan analysis. Join…


AdaptiveIndexDefrag and Maintenance Solution moved to GitHub

Hello all, While I will continue to keep the blog updated in what relates to AID and the Maintenance Solution, all files have moved to GitHub as part of the Tiger Toolbox (http://github.com/Microsoft/tigertoolbox), for easier management and access. Also, it’s easier submit suggestions or bugs, and to keep up with any updates by subscribing to any changes,…


Tiger speaking at PNWSQL User Group

Next September 14 (Wednesday), at 7pm, Tiger will be presenting a session to the Pacific Northwest SQL Server Users Group (PNWSQL). If you’re around Redmond, please join us. Session Title: Gems to help you troubleshoot query performance Session Description: SQL Server 2012 Service Pack 3, SQL Server 2014 Service Pack 2 and SQL Server 2016…

0

Operator progress changes in LQS

Cross post with http://aka.ms/sqlserverteam EDIT (11/12/2016): With the October release of SQL Server Management Studio, operator percentage calculations include multiplying the estimated rows by estimated executions and then compare with actual rows (which already accounted for all executions). One of the useful features that shipped with SQL Server 2016 is  LQS (Live Query Statistics), which is…


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…


MSSQLTIGER and May PASS Virtual Conferences

Cross post with https://aka.ms/sqlserverteam Tiger is delivering another session on an upcoming Performance Virtual Chapter (VC) meeting. This time the topic is about “Gems to help you troubleshoot query performance”.  What are we discussing in this session? Query Store in SQL Server 2016 is one of the most relevant improvements for production DBAs. It introduces…


Presenting at #SQLBits XV

I’ll be doing a two-part session at ‪#‎SQLBITS‬ on Friday: Enhancements that will make your SQL database engine roar – Part 1 (11h-13h) Enhancements that will make your SQL database engine roar – Part 2 (14h-15h) If you’re around, and want to learn more about features and enhancements on SQL Server 2012 SP3, SQL Server…