10

I was watching a 7 years old webinar done by Brent Ozar (https://youtu.be/U_Kle3gKaHc), and heard of several items being recommended at that time.

  1. SQLDiag utility.
  2. SQLNexus.
  3. PAL tool.
  4. Database Tuning Advisor/wizard.
  5. BPA (Best Practices Analyzer).
  6. SQL Server Policy Based Management.

Are all of them still to be used/considered or there is something newer that replaced them?

16

Brent here - the guy in the hairy chest wig in the video.

Much like that hairy chest wig, I don't use those tools much anymore. The video is still up just for comic relief sake.

Over time, I wanted better tools, so with the help of my coworkers, I built 'em and open sourced 'em. Here's the Github repo for the First Responder Kit, which contains:

  • sp_Blitz - health check, replaces the BPA for my needs
  • sp_BlitzFirst - performance check, replaces Diag/Nexus for most of my needs, especially with the @SinceStartup = 1 parameter
  • sp_BlitzCache - performance check that focuses on queries
  • sp_BlitzIndex - index design check that replaces the DTA for me
| improve this answer | |
  • Hello Brent, great to hear from you again. I was pretty sure that would be the case, but I was just trying to make sure that I am not missing something here and posted on stackoverflow (as you would say to do). If I had a question, maybe somebody else has it too ;-) Have a good one! – TheNixon Feb 15 '17 at 13:26
  • @TheNixon good job! Glad to see you posted it, heh. – Brent Ozar Feb 15 '17 at 15:53
7

Whether these are valid, and what they should be used or not could be a massive answer and be mostly opinion. So I've tried to answer this as objectively as possible, from the point of view of whether they are (or look like they are) being actively maintained/updated. Scroll to the bottom for the summary.

1:

SQLDiag is still in use for SQL Server 2016, but is possible up for deprecation

This utility may be changed, and applications or scripts that rely on its command line arguments or behavior may not work correctly in future releases.

2:

SQL Nexus looks like it is still being developed, and the most recent version (5.5.0.1) was released on CodePLex

3:

PAL tool the most recent version (2.7.7) was released last May (can't find further information on the life of this, I'll carry on looking - it does appear that Data Collector most of what this does).

1-3(sort of):

So yes, although lots of these features have been included in the Data Collector component which can partially replace lots of what these do component (partially discussed here. ), coupled with a Management Data Warehouse, these also makes it easier to manage multiple servers.

4:

Database Tuning Adviser is packaged with 2016 and appears to still be a core component. As far as alternatives go, you could check things yourself using DMVs, and there are third party tools like Qure Analyzer (I have no experience on this tool and I only mention it as an example, if you want to know more check out this SO post which asks for alternatives to Tuning Adviser

5:

BPA doesn't appear to be maintained, although I can't actually find anything confirming that it's officially got rid of (it's actually a Windows Server tool, which complicates finding info, and there is a BPA for Windows Server 2012) - there's no BPA for SQL Server 2014 or later. So it might still be useful if you're on 2012 or earlier. This SQL Server Central thread discusses this, but there doesn't seem to be a clear replacement that does it all (I'll add to this if I can find something).

6:

Policy based management is still a thing, take a look at - Central Management Server, which helps you manage multiple servers (coupled with data collectors to replace some elements of the other tools).

TL;DR/Summary:

Yes, most of these tools can still be used, but some are ageing and may not be updated.

SQLDiag is packaged in 2016 (but looks iffy for the future, SQL Nexus and PAL tool have both got version released on codeplex within the last year. Database Tuning Adviser still seems to be a core component of SQL Server. Best Practice Analyzer hasn't had a released for SQL Server since SQL Server 2012, doesn't appear to have an official word but doesn't look like it's being developed. Policy based management is still in use, and looking at Central Management Server with Data Collector may replace, in part, some of the other tools for ongoing management.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.