Have a look at Glenn Berry's diagnostic queries: https://glennsqlperformance.com/resources/
Scripts/alerts for health check of SQLServer
Avyayah
1,231
Reputation points
What scripts/alerts can I run on a database server to check health of the server.
2 answers
Sort by: Most helpful
-
-
AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
2021-08-26T02:28:04.757+00:00 Hi SahaSaha-5270,
Please refer to the scripts in the following articles which might be helpful:
SQL Server Health Check HTML Report
T-SQL scripts to generate database health reportsBest Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.