SQL Server Performance

Health Check for SQL Server 2005

Discussion in 'ALL SQL SERVER QUESTIONS' started by Ksr39, Aug 6, 2012.

  1. Ksr39 Member

    Hi Experts,
    Need a small help as I want to do health check on my sql server 2005, I was wondering is there any script so that I can run and check the health of the server.
    Please let me know if any script is there.

    Thank you in advance
  2. Luis Martin Moderator

    Using SSMS you have a lot of jobs to check health.
    Integrity, defrag, reindex, etc.
    Check Management --> Maintenance Plan
  3. Shehap MVP, MCTS, MCITP SQL Server

    Adding also for what Luis has mentioned , you can use also a variety of Microsoft tools and third party tools like :

    Microsoft tools:

    · MBPA (Microsoft Best practice Analyzer)

    · RML utilities

    · SQL IO SIM

    · SQL RAP (Risk Assessment Program)

    · ….etc

    You can go through Microsoft and download them for free and learn more about them also

    Third party tools

    SQL Deadlock Detector that you can download it at http://www.sqlsolutions.com/products/sql-deadlock-detector/index.html

    SQL Query test that you can download it http://www.datamanipulation.net/SQLQueryStress/sqlquerystressdownload.asp

    SQL Quest Tools Foglight for SQL Server like that you can download it through http://www.quest.com/foglight-for-sql-server/

    …etc

    Kindly let me know if any further help is needed
  4. Ksr39 Member

    Thank you Luis & Shehap for the reply, but I got a doubt about what Luis said, Luis are you asking me to create a Maintenance plan for all the defrag and rebuild Index and integrity checks for the database.
    If so by creating them, how can we do health checks? Its fare that by doing all the above we can say that the db is updated with index and stats, but is it enough with this for saying that db health is good.
  5. Luis Martin Moderator

    So, the question is: what db health means to you?
  6. Ksr39 Member

    Sorry as I have no idea about how to check the health of a database so I asked, I thought there might be some thing else apart from this that's why I asked. If all the
    Maintenance Plan jobs (Rebuild/Reorganize Index, update Stats) are running fine without any error then can we say that the DB health is good or anything else need to be checked, Please let me know on this…
    Thank you in Advance.
  7. Luis Martin Moderator

    Those task are, to me, part of health.
    Usually I include performance, backups and some 3rd party (monitoring) software.
    Check Shehap links.
  8. Ksr39 Member

    Thank you Luis & Shehap for your help.

Share This Page