Post reply

How do you monitor your database and server

  • March 4, 2010 at 9:03 pm

    #217490

    hi ,

    I am looking for a way to monitor our servers and databases.

    Can anyone tell me how do you monitor your databases and servers,by manual? or automate alert? or using a monitoring software?

    ---------------------------------------
    Thorn Bird...

  • March 4, 2010 at 9:54 pm

    #1128945

    Idera Diagnostic Manager

    Quest Spotlight

    Confio

    Those are options to purchase. Or you can develop some inhouse stuff to monitor performance counters, jobs, database files, backups, etc.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 4, 2010 at 10:51 pm

    #1128963

    thank you ~

    But the tools you list are copyright software.

    Is there a open-source software to monitor my MSSQL.:-D

    ---------------------------------------
    Thorn Bird...

  • March 4, 2010 at 11:10 pm

    #1128970

    This is a free dashboard tool from Idera that I could recommend:

    http://www.idera.com/Products/Free-Tools/SQL-check/

    no licensing involved, but it is limited, try it.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • March 4, 2010 at 11:10 pm

    #1128971

    Compiled applications? I don't know of any in particular.

    There are a bunch of applets and scripts available for download.

    Check out Glenn Berry's DMV scripts

    Simple-talk.com has some SMO things to test out

    SSC has plenty of tsql scripts in the script repository to help with various tasks

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 5, 2010 at 12:05 am

    #1128998

    there are many free scripts that monitor job status, performance counter, update statistics, re-indexing etc

    I write my own scripts to capture data from dynamic views.

  • March 5, 2010 at 7:03 am

    #1129146

    If you don't have the time or inclination to create your own monitoring setup, and you want a free monitoring application, my choice would be SQL Spy.

  • March 5, 2010 at 10:42 am

    #1129310

    There is this tool: http://sqlh2.codeplex.com/

    On SQL Server 2008 - you can also implement and use the data collector to monitor multiple systems.

    There are other free tools available at the above site for monitoring SQL Server.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply