Total Pageviews

Saturday, November 16, 2019

Free: SQL Server Diagnostic Tool for SQL 2012 – SQL 2022

Portable Tool:........ SQL Digger
                                 (SQLDigger.exe - Main executable
                                  SQLDigger.txt - Encoded Configuration file)
Version Supports... SQL 2012 - SQL 2022
Last Upload:........... 2023.10.23 (October 2023)
Usage Type:.............Free, strictly non-commercial, and educational.
Download:.............. http://bit.ly/2NTn6Zi

Purpose of this tool:
As database administrator, I have to support different SQL Server environments. Often it becomes a challenge and obvious to understand the current server health status. To attain this goal based on my requirements, I have created this small tool just for fun with my limited development application skill. It is Free, Agent-less, No Installation/Configuration is required, Single executable and portable, easy to use and only needs a couple of clicks to be up and running.

Background for the new development:
The latest SQL Server release is bringing a number of new features and is changing the underlying functionality and behaviour of SQL Server. Thus, creating a new and updated diagnostic tool makes sense to help my DBA responsibilities and improve my regular workflow. The new tool is meant to be a replacement for my old “SQLMonitor.exe” which can be found at this link: http://sqltouch.blogspot.com/2014/03/free-real-time-sql-server-performance.html

Development and distribution:
As I am developing this tool, new features will be added on an ongoing basis. This tool is free, non-commercial and only for educational purposes, so as always, use at your own risk. If you’ve used (or are currently using) my previous tool, then you might be interested in testing this new tool as well. If you need an uncompressed version of this tool to avoid false positive alert from your Anti-Virus, then you may contact with me describing/providing the reason and I’ll try to forward you the uncompressed version of this tool.

Screenshot #1: Connecting a SQL Server


Screenshot #2: Connecting a multi-subnet AlwaysOn Availability Group

Screenshot #3: Detailed view of all databases on a server

Screenshot #4: AlwaysOn Availability Group Health status

Screenshot #5: Details view of blocking
 
Screenshot #5(a): Details view of blocking including parallel processes
Screenshot #6: Server configurations.

Screenshot #7: Wait Type Analysis with wait type group and description