Solved

SQL Server Healthcheck

Posted on 2014-01-31
5
404 Views
Last Modified: 2014-02-11
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
Comment
Question by:pma111
  • 3
  • 2
5 Comments
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
ID: 39823895
you can try sp_blitz from brentozar, it is free
http://www.brentozar.com/blitz/
0
 
LVL 3

Author Comment

by:pma111
ID: 39823902
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
 
LVL 16

Expert Comment

by:Surendra Nath
ID: 39823939
it run on SQL Server 2005 or newer.
it works on express edition as well.
0
 
LVL 3

Author Comment

by:pma111
ID: 39824092
what kind of things is it reporting on/checking for?
0
 
LVL 16

Expert Comment

by:Surendra Nath
ID: 39824296
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

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now