Looking for a best DBA tool

Question

Post reply

Looking for a best DBA tool

ajdba33

SSC Enthusiast

Points: 170
More actions
April 29, 2016 at 10:59 am

#316099

Hi,
I need some recommendations about getting an enterprise DBA Tool with ER diagram capability.
Appreciate some inputs.
Thanks
Aj

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

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

SpaveNation SSCommitted Points: 1563 More actions · Answer 1

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

ajdba33 SSC Enthusiast Points: 170 More actions · Answer 2

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

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

ajdba33 SSC Enthusiast Points: 170 More actions · Answer 4

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

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

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 6

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

ajdba33 SSC Enthusiast Points: 170 More actions · Answer 7

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

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 8

Steve Jones - SSC Editor

SSC Guru

Points: 736478

April 30, 2016 at 12:12 pm

#1875766

ER tools: Erwin, and ER/Studio.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 9

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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 10

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)

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 11

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.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 12

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)

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 13

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 😛

wdmm Old Hand Points: 321 More actions · Answer 14

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