2016 July 15 - Performance Tuning Help

SQL Server 2012-2016 users are going to find a lot of stuff to love in here:

sp_BlitzCache v3.1:

• Show cost for stored procedures. #339
• Warn about trace flags added at the query level, and global trace flags. #361
• Add warnings about Remote Queries. #315
• Do not show Forced Plans warning if the real cause is forced parameterization. #343
• Fix divide-by-zero error if Cost Threshold for Parallelism is 0. #358
• Fix warning for unparameterized query. #334

sp_BlitzFirst v25 (The Artist Formerly Known as sp_AskBrent):

• Add new memory grants columns to 2012-2016 live queries output. #362
• Add SQL login to live queries output. #354
• Filter Perfmon counter display to skip counters with zeroes. Still logged to table though. #356

sp_Blitz v53.1:

• Warn about 2016 Query Store cleanup bug in Standard, Evaluation, Express. #352
• Updating list of supported SQL Server versions. #344
• Fixing bug in wait stats percentages. #324

sp_BlitzIndex v4.1:

• Compression information in @mode = 2. #18
• Use recently-modified check to improve indexes-not-in-use recommendations. #220
• Alphabetical sort for @GetAllDatabases = 1, @mode = 2 output. #351
• Remove per-day cost filter for missing indexes in @mode = 4. #338
• Missing index benefit is now labeled per-day to make it more obvious. #330