Skip to content

2016 Sept 3 - Bug Fixes, Memory Grants, and Improvements to @OutputServerName, @CheckServerInfo
Compare
Choose a tag to compare
@BrentOzar BrentOzar released this 04 Sep 11:37
20160903
2ee15e7

In addition to lots of bug fixes, here's the new stuff:

sp_Blitz v53.2:

  • @OutputServerName writes output to remote server (Haris Khan) - for years, these stored procs have had an @OutputServerName parameter just waiting to be hooked up, and Haris is doin' the hookin'. Now you can push your sp_Blitz results to a central server for easier monitoring! He's doing the same with the rest of the stored procs, too, and we just have to put more work into testing those.
  • New warning for unevenly sized TempDB data files (Brianc-DBA) - we'd always checked for different autogrowth sizes, but shockingly, we weren't looking for unevenly sized files! Great catch, Brian.
  • @CheckServerInfo = 1 now includes Windows restart time (Julie OKC) - it had always included the SQL Server instance restart time, but now you get Windows too.
  • @CheckServerInfo = 1 now checks for Instant File Initialization (Tara Kizer) - starting with SQL Server 2014 SP2 and 2016, Microsoft's logging it in the error log on startup, so we're checkin' for it. We only say yes if it's enabled - we can't say for sure that it's not enabled, since you may have cycled the errorlog since startup.

sp_BlitzCache v3.2:

  • New warning on unused memory grants (Erik Darling) - thanks to new DMV improvements in 2012/2014/2016 that show how much memory queries are granted versus how little they actually use.
  • Add @sortorder options for 'memory grant' and 'avg memory grant' (Erik Darling) - makes it way easier to troubleshoot queries that get a huge memory grant.

sp_BlitzFirst v25.1:

  • Add waits from sys.dm_os_waiting_tasks to wait stats (Erik Darling) - now, if we've got a long-running query blocking others, the lock waits will go up even though the query hasn't finished. Before, we were only adding up activity from sys.dm_os_wait_stats, which doesn't increment until the wait clears.

sp_BlitzIndex v4.1:

  • Better version number/date formatting (Jorge Solorzano) - making it easier to update new versions of sp_BlitzIndex.
  • New @SkipPartitions parameter (Erik Darling) - for faster processing on databases with large numbers of partitions.
  • Better results when @GetAllDatabases = 1 (Erik Darling) - when you've got lots of problems, you want 'em sorted by priority.
Assets 3
Loading