question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked DavidBrowne-msft answered

Buffer cache-hit ratio for SQL Server on Azure VM fetching

I have SQL installed on Azure VM , which is connected to Log Analytics workspace, for logging/monitoring.

Using Azure Monitor , We want to raise alerts based on the buffer cache hit ratio of SQL Server on Azure VM.

Can you please help with same query for the same

azure-monitor
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MSTechie-7364 Apologies for delay in getting to this thread.

Checking in to see if you had a chance to review Azure SQL Analytics (Preview). Azure SQL Analytics is an advanced cloud monitoring solution for monitoring performance of all of your Azure SQL databases at scale and across multiple subscriptions in a single view. Azure SQL Analytics collects and visualizes key performance metrics with built-in intelligence for performance troubleshooting.

Here is some guidance on how to create alerts for Azure SQL database.

I am further validating if Buffer cache-hit ratio shows up with Azure SQL Analytics (Preview) , will keep this thread updated as I learn more on this.

Hope the above information helps.

0 Votes 0 ·

1 Answer

DavidBrowne-msft avatar image
0 Votes"
DavidBrowne-msft answered

You can capture any performance counters you want with Azure Monitor. See

Collect Windows and Linux performance data sources with Log Analytics agent

But the generally recommendation is to watch Page Life Expectancy instead of (or in addition to) than Buffer Cache Hit Ratio.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.