DBA SQL Server Tools

Please notice that Microsoft has shut down CodePlex. I will change links on a running basis...

SQL Server

PSSDIAG - Pssdiag and Sqldiag Manager

CodePlex: diagmanager.codeplex.com

SQL Nexus

CodePlex: sqlnexus.codeplex.com

dbatools

PowerShell module with functions for SQL Server administration (dbatools.io).

DBA Dash

General DBA tool to assist with daily checks, performance monitoring and tracking configuration changes. I have no experience with the tool, but it seems worth a closer look.
(DBADash.com)

dbachecks

Validate SQL Server (Database Engine) environments and installations. Based on PowerShell with features to mail report or export to PowerBI.

(github.com/sqlcollaborative/dbachecks)

SSMS Tools Pack

SQL Server Management Studio plug-in. Licensed edition only.
(www.ssmstoolspack.com)


Windows

PAL

CodePlex: pal.codeplex.com

Windows Performance Toolkit

Microsoft: Windows Performance Toolkit.

PerfView

GitHub: Microsoft/perfview
Microsoft Download: Download PerfView

MAP Toolkit

MSDN Library: Microsoft Assessment and Planning Toolkit


Network

Wireshark

Network packet analyzer.
wireshark.org

Microsoft Message Analyzer

... is being retired. Replaced Microsoft Network Monitor with a more advanced feature set.
TechNet: „Microsoft Message Analyzer Operating Guide
Technet: „Message Analyzer Tutorial

iPerf

Measure maximum achievable IP network bandwidth.
iperf.fr

Storage

diskspd

GitHub: Microsoft/diskspd

CrystalDiskMark

(crystalmark.info/en/software/crystaldiskmark)

Samsung Magician


Monitoring

Nagios

Open source server and network monitoring and analysis.

Nmap

Security scanner.
NMAP.ORG

No comments: