Post reply

Can anyone tell me free tools for dba?

  • March 8, 2012 at 6:27 am

    #258369

    Hi guys , im new to sql dba,

    and i want to know about tools used by the dba's on daily basis??.

    and

    what type of tools should i choose to start for every purpose( like perf or blocking or cpu burden monitor or e.t.c) to monitor the db??

    can u plz list out some of ur best tools ??

    thanks.

  • March 8, 2012 at 11:03 pm

    #1456963

    are there any free tools , should i have to look out for??

    which one u guys prefer red gate sql monitor or fog light for sql server??

    thanks

  • March 9, 2012 at 1:25 am

    #1457005

    the only freeware tools I have found are Quests discovery manager so I can see who is installing SQL out on the network without us knowing and PowerGui for developing powershell scripts and SQLServer for doing object lookups which we use on a daily basis.

    SQLMonitor and Foglight and licenced products and cost approx £500 for SQLMonitor and £2000 for Foglight.

    if you need something free then you could always develop your own solution to monitor what you need and will give you that experience into DBA'ing and where all the different things lie within SQL around CPU, memory, blocking.

    dont forget that SQL does come with activity monitor which monitors CPU, SQL session, IO and expensive queries.

  • March 9, 2012 at 1:49 am

    #1457014

    There are some greate paid tools from redgate and quest like already mentioned. But most of the time you will customer scripts being used by most DBA. It gives flexibility to tweak and change easily.

    The support for monitoring is greatly improved from sql 2005 onwards you could find a few tables which will find you any parameter you want to monitor and simply write the script. Its also a great learning oppurtunity.

    Jayanth Kurup[/url]

  • March 9, 2012 at 2:28 am

    #1457018

    Actually there are quite a lot of free tools around, you only have to know how find them and determine what exactly are your needs. Codeplex is always a good place to find free tools, but commercial companies like Red-Gate or Quest also sometimes offer certain tools for free.

    SQL Monitor (http://sqlmon.codeplex.com/) is quite a comprehensive free monitoring tool.

    For realtime performance monitoring have a look at http://sqlmonitor.codeplex.com/

    David Bird once wrote two articles on this site about various free tools:

    http://qa.sqlservercentral.com/articles/Miscellaneous/2959/

    http://qa.sqlservercentral.com/articles/Tools/64908/

    [font="Verdana"]Markus Bohse[/font]

  • March 9, 2012 at 2:30 am

    #1457020

    Thanks Markus, I will take a look at them.

  • March 9, 2012 at 5:32 am

    #1457098

    Here's two I know of. I'm sure theres a couple more that I've forgotten.

    http://www.idera.com/Free-Tools/[/url]

    http://www.ssmstoolspack.com/[/url]

  • March 9, 2012 at 6:10 am

    #1457126

    My favorite of all time free tools... GOOGLE.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • March 9, 2012 at 6:12 am

    #1457128

    Jeff Moden (3/9/2012)

    My favorite of all time free tools... GOOGLE.

    kewl! where can i find that? can you send it to me via email?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 9, 2012 at 6:59 am

    #1457163

    Jeff Moden (3/9/2012)

    My favorite of all time free tools... GOOGLE.

    Jeff could you send us a download link for it?

    [font="Verdana"]Markus Bohse[/font]

  • March 9, 2012 at 8:53 pm

    #1457438

    BWAA-HAA!!! One link coming right up, fellas!

    [font="Arial Black"]Click here for requested link[/font]

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • March 10, 2012 at 1:19 am

    #1457455

    hi jeff , i installed google on my system but it looks like its not working , all i see is a white screen with the textbox and a button that says i am feeling lucky :p

    Jayanth Kurup[/url]

  • March 10, 2012 at 9:13 am

    #1457496

    Heh... must be the web browser that you're using. 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • March 10, 2012 at 9:51 am

    #1457504

    Goggle? What's that.:-)

    Try Goggle Ignite.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • March 22, 2012 at 7:21 am

    #1462689

    When it comes to trouble-shooting performance problems, there are several good free tools out there.

    One free tool for analyzing trace files is Qure Analyzer by DBSophic. You can find it here: SQL Server trace file analyzer

    The tool processes even large trace files very quickly, and provides you with an interactive GUI to drill down and sift through the trace data. Pretty neat.

Viewing 15 posts - 1 through 15 (of 15 total)

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