question

Vishu-2318 avatar image
0 Votes"
Vishu-2318 asked Cathyji-msft commented

basline SQL checks

Can you please suggest some query/DMV which can be used to collect the baseline information instead of running some of the performance counters for compute/storage/Memory as mentioned in the link :

https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-collect-baseline

sql-server-generalsql-server-transact-sql
· 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.

Hi @Vishu-2318,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know . By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

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

Hi @Vishu-2318,

Please check if below blogs could help you.

Collect and store historical SQL Server performance counter data with DMVs
How to analyze SQL Server database performance using T-SQL

This is an old thread Creating SQL Server Performance Baseline Monitoring, hope it could help you.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.



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.