SQL Diag

Article

SQL Diag is a very useful diagnostic tool that will help capture performance information from SQL Server. This tool is shipped with the SQL Server product. Howerver there is not an easy way to configure the tool - it requires the hand editing of an XML file, which is tedious and error prone. That is until now!
SQL Diag Configuration Tool (SDCT) is an intuitive, easy to use tool that will read existing sqldiag.xml configuration files, allow you to select your desired options and save those options to a new file.

2011-04-29

3,589 reads

Read the latest Blogs

Visit the forum

Question of the Day

Multiple Escape Characters

In SQL Server 2025, I run this code (in a database with the appropriate collation):

SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';

What is returned?

See possible answers

SQL Diag

SQL Diag Configuration Tool

Blogs

Using Prompt AI for a Travel Data Analysis

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

2025 Wrapped for Steve

Forums

The North Star for the Year

Multiple Escape Characters

reaching ftp thru winscp but erroring in ssis ftp task connection

Question of the Day

Multiple Escape Characters