SQL Baseline Build-step

1. Collect the performance metrics on the target machine:
Run:
Configuration file
Execute the following command:
Run as Service
It's 8 to 18 o'clock in the evening in the morning.
Sqldiag-p "C:\sqldiag"-B 08:00:00-e 18:30:00-n2-r
net start SQLdiag

Unloading:
net stop SQLdiag
Sqldiag-u
2, convert the last generated SQLDIAG.BLG file with PAL tool, generate analysis results, observe this result, and focus on problem solving.
Convert sqldiag.blg through relog sqldiag.blg-f csv-o sqldiag.csv to CSV and import into SQL Server for data analysis, such as averages.
3. Open the collected SQL Server TRC file, file-Import performance data, select the generated BLG performance counter file, so you can compare performance counters with specific SQL to view.

SQL Baseline Build-step