-
Notifications
You must be signed in to change notification settings - Fork 94
ReadMe
Pssdiag/Sqldiag Manager is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine. The data collected can be used by SQL Nexus tool which help you troubleshoot SQL Server performance problems. This is the same tool Microsoft SQL Server support engineers use to for data collection to troubleshoot customer's performance problems.
Download latest release here
- SQL DiagManager requirements:
- Windows 7 or Windows 10 (32 or 64 bit)
- .NET Framework 4.5
- Data collection
- The collector can only run on a machine that has SQL Server with targeted version (either client tools only or full version) installed
Download it from release tab or click here to download. Source files are also included in the release tab. There are releases for PSSDIAG for SQL Server running on Windows and Linux, as well as for Azure Arc-enabled SQL Managed Instance. Use the search box (Find a release) to quickly get to the release you need or simply scroll down.
This tool lets you customize what you want to collect and then let you create a data collection package. You extract the package and run SQLdiag data collector engine on the SQL Server you are troubleshooting.
- Powerful data collection capabilities: The tool relies on SQLdiag collector engine to provide collection of perfmon, profiler trace, msinfo32, errorlogs, Windows event logs, T-SQL script output and registry exports.
- Default templates/scenarios : You can choose SQL Server version and platform (32 bit or 64 bit). The tool will automatically choose a default template for the combination. This will have default set of perfmon counters, profiler traces.
- Shipped with ready to use Custom collectors : Most commonly used custom collectors include SQL Server performance collector scripts.
- Customization/Extensibility: You can customize what perfmon and XEvent/SQL Server trace events you want to collect. Additionally, you can create your own custom collectors with T-SQL Scripts, batch files and utilities. See Creating a Custom Collector.
- Packaging: With a single click of save, the tool will package all your files into a single ZIP so that you can ship to the machine where you intend to run on.
- Integration with SQL Nexus : The custom collectors shipped will collect data that can be analyzed by SQL Nexus Tool.
Microsoft Public License (Ms-PL)
This license governs use of the accompanying software. If you use the software, you accept this license. If you do not accept the license, do not use the software.
- Definitions
The terms "reproduce," "reproduction," "derivative works," and "distribution" have the same meaning here as under U.S. copyright law.
A "contribution" is the original software, or any additions or changes to the software.
A "contributor" is any person that distributes its contribution under this license.
"Licensed patents" are a contributor's patent claims that read directly on its contribution.
- Grant of Rights
(A) Copyright Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free copyright license to reproduce its contribution, prepare derivative works of its contribution, and distribute its contribution or any derivative works that you create.
(B) Patent Grant- Subject to the terms of this license, including the license conditions and limitations in section 3, each contributor grants you a non-exclusive, worldwide, royalty-free license under its licensed patents to make, have made, use, sell, offer for sale, import, and/or otherwise dispose of its contribution in the software or derivative works of the contribution in the software.
- Conditions and Limitations
(A) No Trademark License- This license does not grant you rights to use any contributors' name, logo, or trademarks.
(B) If you bring a patent claim against any contributor over patents that you claim are infringed by the software, your patent license from such contributor to the software ends automatically.
(C) If you distribute any portion of the software, you must retain all copyright, patent, trademark, and attribution notices that are present in the software.
(D) If you distribute any portion of the software in source code form, you may do so only under this license by including a complete copy of this license with your distribution. If you distribute any portion of the software in compiled or object code form, you may only do so under a license that complies with this license.
(E) The software is licensed "as-is." You bear the risk of using it. The contributors give no express warranties, guarantees or conditions. You may have additional consumer rights under your local laws which this license cannot change. To the extent permitted under your local laws, the contributors exclude the implied warranties of merchantability, fitness for a particular purpose and non-infringement.