• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 469
  • Last Modified:

SQL Server Healthcheck

Can anyone recommend any sort of daily SQL healthcheck script to check for common/known issues in your SQL infrastructure and databases. or what kind of parameters you put into your healthcheck scripts to keep an eye that things are running smoothly. I appreciate there are probably commercial tools do to the same.
0
pma111
Asked:
pma111
  • 3
  • 2
1 Solution
 
Surendra NathTechnology LeadCommented:
you can try sp_blitz from brentozar, it is free
http://www.brentozar.com/blitz/
0
 
pma111Author Commented:
can I ask what kind of things it checks for, and what versions of sql it is tested on, i.e. does it run on express?
0
 
Surendra NathTechnology LeadCommented:
it run on SQL Server 2005 or newer.
it works on express edition as well.
0
 
pma111Author Commented:
what kind of things is it reporting on/checking for?
0
 
Surendra NathTechnology LeadCommented:
go through the video in this url please... it has the complete details about it.

http://www.brentozar.com/blitz/
http://www.brentozar.com/blitz/documentation/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now