2021年4月16日 星期五

Pssdiag

 

Pssdiag/Sqldiag Manager

https://github.com/microsoft/DiagManager

Getting Started

https://github.com/Microsoft/DiagManager/wiki/Getting-Started

Step by Step tasks

  1. Installation of pssdiag/sqldiag manager
  2. Creating a pssdiag package
  3. [Running Pssdiag an SQL Server instance](Running PSSDiag)
  4. [Running pssdiag on a cluster](Running Pssdiag on a Cluster)
  5. [Creating your own custom collectors](Custom collector)
  6. Frequently Asked Questions

Reference:

SQL Server: How to Configure pssdiag utility for SQL Server 2016

https://social.technet.microsoft.com/wiki/contents/articles/51504.sql-server-how-to-configure-pssdiag-utility-for-sql-server-2016.aspx

Using PSSDiag and SQL Nexus to monitor SQL Server performance (Youtube Video) 

https://www.youtube.com/watch?v=5xo_S1nx_nA


- 沒有留言:
標籤： , , , , ,
訂閱： 文章 (Atom)

SQL Server Planning, Pricing and License

  Server-CALs授權模式 1.需購買的量應該是所有終端用戶的電腦 例如:一台Data warehouse主機 與 一台Web報表主機，但公司有50人或電腦會連進Web報表主機開啟報表，則應該每一台用戶端電腦都需要有CALs授權，Data warehouse主機購買Ser...

  • Oracle TNS連線設定(Tnsnames.ora)
    1.安裝了Oracle Client，就可以用Oracle Net Manager工具來設定TNS連線設定(Tnsnames.ora)       Oracle Client 18.3 Installation 安裝Oracle Client 18.3 2.啟動Oracle Ne...
  • SSIS Oracle Source and Destination
    SQL Server Integration Service可以透過內建的OLE DB Source連線到Oracle匯出資料，但無法寫入資料到Oracle，Attunity公司針對這個功能提供了SSIS的連結Source，並且聽說資料傳送效率非常好，本人沒有測試過效能，有興趣的...
  • Oracle Client Installation 安裝Oracle Client
    1.下載 Oracle Database 18c (18.3) https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-windows-180000-5066774.ht...