Monitoring database performance statistics

Henry Schein One recommends that you monitor database performance statistics monthly or semi-annually to ensure proper server performance is being achieved. Besides the built-in Microsoft tools, you can also use third-party monitoring tools to log and analyze performance data. Refer to the following:

MS SQL Server 2019

https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-resource-usage-system-monitor?view=sql-server-2019

https://docs.microsoft.com/en-us/sql/relational-databases/performance/performance-monitoring-and-tuning-tools?view=sql-server-2019