question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked AmeliaGu-msft commented

Scripts/alerts for health check of SQLServer

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.