14,494 questions
Have a look at Glenn Berry's diagnostic queries: https://glennsqlperformance.com/resources/
Scripts/alerts for health check of SQLServer
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 55.00000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Avyayah
1,291
Reputation points
What scripts/alerts can I run on a database server to check health of the server.
SQL Server | Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff2021-08-30T09:21:44.023+00:00 Hi SahaSaha-5270,
How are things going?
Do the answers help you?
Please feel free to let us know if you have any other question. If you find any post in the thread is helpful, you could kindly accept it as answer.Best Regards,
Amelia
Sign in to comment
2 answers
Sort by: Most helpful
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2021-08-25T21:22:06.357+00:00 -
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
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.