Scripts/alerts for health check of SQLServer

Avyayah 1,251 Reputation points
2021-08-25T21:16:20.367+00:00

What scripts/alerts can I run on a database server to check health of the server.

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,852 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 102.1K Reputation points MVP
    2021-08-25T21:22:06.357+00:00

    Have a look at Glenn Berry's diagnostic queries: https://glennsqlperformance.com/resources/

    0 comments No comments

  2. 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 reports

    Best 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.

    0 comments No comments