Looking for a best DBA tool

  • Hi,

    I need some recommendations about getting an enterprise DBA Tool with ER diagram capability.

    Appreciate some inputs.

    Thanks

    Aj

  • Your best bet would be Microsoft SQL Managment Studio with Visual Studio and SSRS

  • Thanks for your suggestion. I would like to get some recommendation about some third party tools like Redgate or Idera. Please let

    me know if any of you using these tools and how do you like it so far and so forth.

    Thanks again.

    Aj

  • You would need to be specific on what you need. Design? Monitoring? Automation?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Its for SQL Server 2008 R2.

    We will be needing for DBA monitoring which should include administration, performance and diagnostics.

    We also need designing features as well.

    Thanks

  • ajdba33 (4/29/2016)


    Its for SQL Server 2008 R2.

    We will be needing for DBA monitoring which should include administration, performance and diagnostics.

    We also need designing features as well.

    Thanks

    Those are different tools.

    That is unless you hire a person that can do both.

    SQLSentry for monitoring. ERD tools are frankly not worth the money.

    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

  • You're kind of all over the map here, but I'll be happy to make some suggestions.

    First off, get the SQL Toolbelt from Redgate[/url]. It has a number of tools that you can make use of in development, deployment, and day-to-day maintenance of your databases. SQL Prompt for better, more efficient, T-SQL generation. SQL Compare & Data Compare to assist in deployment and maintenance. SQL Monitor for your monitoring needs. SQL Source Control to get your database code under source control management just like your app code.

    DISCLAIMER: I work for Redgate.

    ER tools...

    The one I recommend usually is Embarcadero DBArtisan. However, I haven't used it for a number of years. I'm not sure it's as good as it used to be.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Thanks so much Grant, I will definitely explore the tools that you have mentioned.

    Also, has anybody used SQ Sentry PowerSuite tool ? I would like to compare few tools before we make any decisions.

    Thanks

    Aj

  • ER tools: Erwin, and ER/Studio.

  • ajdba33 (4/30/2016)


    Thanks so much Grant, I will definitely explore the tools that you have mentioned.

    Also, has anybody used SQ Sentry PowerSuite tool ? I would like to compare few tools before we make any decisions.

    Thanks

    Aj

    Just remember, different tools do different things. SQL Sentry makes some excellent tools for monitoring and plan exploration. They don't have anything like SQL Prompt or SQL Compare. It's not just a question of "the best DBA tool". It's getting the right tools to help you do the work you need to do.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • There are a lot of helpful tools out there but, to be honest, the absolute best tool in all of these instances is frequently overlooked... a DBA that actually knows all this stuff and knows not only how to write and correctly tuneT-SQL but also knows how to write his own tools when push comes to shove.

    Above all else, they must know how to get the current date and time. 😛

    --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)

  • I absolutely recommend RedGate SQL Prompt for SSMS. It's a great plugin for SQL development.

    For data modeling and so forth, I think Excel and Visio still work fine. I normally stick to just Excel because it serves as a great data dictionary that is compact and get be sent to other teams, vendors and so forth. You can define your entire schema, keys (relationships) and indexes (table per tab). Everyone can open Excel.

    Most of the hardcore DBA's I work with still use a visualization tool like SSRS, Tableu or MicroStrategy for monitoring. That means they run their own SQL scripts they've made or collected combined with custom made reports for monitoring the SQL environments.

    Being I just went through a SQL Sentry demo, I got to say their suite of tools for managing and monitoring multiple SQL environments is pretty sweet. I really like how you can drill down to the files in on sweep and down to the host in another if your virtualized. I also love the cached plans with animated playbacks.

  • For data dictionary information, I simply store extended properties with the table. When you send the code or the database to someone, the documentation is auto-magically included.

    --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)

  • Jeff Moden (5/2/2016)


    For data dictionary information, I simply store extended properties with the table. When you send the code or the database to someone, the documentation is auto-magically included.

    That too!

    But before tables are made, I still use Excel 😛

  • https://www.idera.com - looks like it has some interesting tools for free

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

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