[讀書筆記]SQLSERVER企業級平台管理實踐讀書筆記01

標籤：倉庫   col   gpo   sof   clu   class   def   info   ali   

 

1. SQLSERVER資訊收集

SQLDIAG

使用介面

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 you 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 (this machine)

2018/01/02 08:13:28.85 WIN2008R2SP1\* Target machine is 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.

內容:

 

2. Performance Dashboard

 

先建立管理資料倉儲 然後 設定資料收集

 

 然後可以查看相應的報表

報表:

需要注意 需要開啟 sqlserver的代理服務才可用

 

[讀書筆記]SQLSERVER企業級平台管理實踐讀書筆記01