Thank you for the article.
I have been struggling to figure out what each of the metrics means in the SQL Sentry Performance Advisor dashboard, and I must admit I am a little lost.
Let's take for example the "Page Reads/Writes" graph (History mode) in the SQL SERVER MEMORY section.
I take it these are Reads/Writes from disk(?), which would indicate memory pressure? Is this correct?
I wish there was some documentation on how to best make use of this tool to detect performance issues.
What I would find really useful would be a chart listing the system monitor counters used for each graph.
Anyone have any suggestions?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]