basline SQL checks

Vishu 1,516 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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,692 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    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