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.
LVL 3
pma111Asked:
Who is Participating?
 
Surendra NathConnect With a Mentor Technology 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
All Courses

From novice to tech pro — start learning today.