Scripts/alerts for health check of SQLServer

Avyayah 1,251 Reputation points

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

    Have a look at Glenn Berry's diagnostic queries:

    0 comments No comments

  2. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor

    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,

    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