Can anyone tell me free tools for dba?

Question

Post reply

Can anyone tell me free tools for dba?

s1123

Mr or Mrs. 500

Points: 567
More actions
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.

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

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

s1123 Mr or Mrs. 500 Points: 567 More actions · Answer 1

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 2

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.

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 3

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]

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 4

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://www.sqlservercentral.com/articles/Miscellaneous/2959/

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

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

Ant-Green

SSC Guru

Points: 113507

March 9, 2012 at 2:30 am

#1457020

Thanks Markus, I will take a look at them.

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 6

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]

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 7

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)

Lowell SSC Guru Points: 323518 More actions · Answer 8

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!

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 9

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]

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

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)

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 11

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]

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

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)

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 13

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/

gil 17845 SSC Enthusiast Points: 132 More actions · Answer 14

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.