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


沒有留言:

SQL Server Planning, Pricing and License

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