Free scripts and tools for your Production SQL Server
So, go to http://github.com/microsoft/tigertoolbox and enjoy the free stuff. Some notes on the solutions I’ve already used on a lot of production environments:
- SQL Server Performance baseline – probably the best solution I ever worked on the topic of performance baselining. You get a bunch of reports, pre-created for you, that you just need to deploy to a RS instance. The solution uses a distributed system of collecting data, where each monitored instance collects data on its own (in a local database). I’ve hit couple of issues with that solution though, so please be aware – you will need Kerberos configured for your RS server and might need to change some of the queries to utilize the TRY_PARSE() statements, especially on source systems that are with different Windows Locale.
[Edit: 11/24/2017] : Thanks to Parikshit Savjani (SQL Tiger PM) - if you are allowed by your organization's security standards, you can store credentials (both Windows and SQL) in the data sources - https://technet.microsoft.com/en-us/library/ms159736(v=sql.105) and https://technet.microsoft.com/en-us/library/ms160330(v=sql.105)
- SQL Server System Health Session PowerBI – you get a template of a PowerBI report, where you just change the source instance and immediately get visual representation of your system health session (SQL 2012+). Which means that even if you do not have any other performance collections and you need some history information on your instance – this is the thing for you. Now you have a tool to visit the history of your SQL.
- BPCheck – this is actually a must have utility for your environment. It is not something that you run on daily basis, but more like a tool you use to check your best practices and sweep your instance for issues on configuration, performance, indexing, plan caching, etc. Make sure you test before you run it on PRODUCTION though. And make sure you are aware of all the input parameters for the script!
There are over 10 different solutions/scripts/utilities at the tigertoolbox, so make sure you check them all! And test before you implement. Of course, you are also free to adapt them to your environment, as every piece of source code is OPEN for you to use!