0

I want to know how healthy an SQL Server database is now (before I started to work with it).

Then, in a month or so, I want to check again to see how healthy database is at that time and compare it to the previous state.

Basically is there any way I can take something like a snapshot of the database health now and later? And then see what's been improved, so I can track my progress.

Any source of information would be great.

1
  • That's way too broad, I'm afraid. "Health" of a server means different things to different people. Once you define what a "healthy SQL Server" means to you with your workload and SLA, you'll be half-way through to the answer.
    – mustaccio
    Sep 30, 2020 at 20:28

2 Answers 2

4

Look at sp_blitzfirst from www.brentozar.com This store procedure will give you a good status of your SQL servers.

1

There are also a series of Brent's First Responder files here - https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit.

As Dominique says, sp_blitz_first is the one you want.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.