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

MS Techie 2,751

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

bharathn-msft 5,106 Reputation points Microsoft Employee Moderator

2021-09-02T03:14:55.86+00:00

@MS Techie 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.

1 answer

David Browne - msft 3,851 Reputation points

2021-09-02T13:29:33.563+00:00

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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer