Share via

basline SQL checks

Vishu 1,736 Reputation points
2021-06-14T11:59:14.523+00:00

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://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-collect-baseline

Developer technologies | Transact-SQL
SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-06-15T06:01:10.203+00:00

    Hi @Vishu ,

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.