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 :
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 :
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.
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.
13 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index