[Reading notes] SQL Server Enterprise Platform Management practice reading notes 01

1. SQL Server information collection

SQLDIAG

Using the interface

C:\users\administrator>sqldiag
2018/01/02 08:13:26.10 SQLDIAG Collector version
2018/01/02 08:13:28.19 SQLDIAG

IMPORTANT: Please wait until ' see ' Collection started ' before attempting to
Reproduce your issue

2018/01/02 08:13:28.19 SQLDIAG Output Path:

C:\Program Files\Microsoft SQL Server\100\tools\binn\sqldiag\

2018/01/02 08:13:28.82 SQLDIAG collecting from 1 logical machine (s)
2018/01/02 08:13:28.85 win2008r2sp1\* SQL Server version:10.50
2018/01/02 08:13:28.85 win2008r2sp1\* Machine NAME:WIN2008R2SP1

2018/01/02 08:13:28.85 win2008r2sp1\* Target machine was not a cluster
2018/01/02 08:13:28.85 win2008r2sp1\* Instance: (Default) (64-bit)
2018/01/02 08:13:30.86 SQLDIAG Initialization starting ...
2018/01/02 08:13:35.21 win2008r2sp1\* msinfo:get MSINFO32
2018/01/02 08:13:35.31 win2008r2sp1\* msinfo:get Default traces
2018/01/02 08:13:35.40 win2008r2sp1\* msinfo:get sqldumper Log
2018/01/02 08:13:35.93 win2008r2sp1\* Collecting diagnostic data
2018/01/02 08:13:35.93 SQLDIAG Initialization complete

2018/01/02 08:13:35.94 SQLDIAG Collection started. Press CTRL + C to stop.

Content:

2. Performance Dashboard

Create a management Data warehouse and set up data collection first

You can then view the corresponding report

Report:

Note that the agent service needs to be opened for SQL Server to be available

[Reading notes] SQL Server Enterprise Platform Management practice reading notes 01