x

What's missing from your toolbox?

I'm just finishing up on an app, and I was going to write a performance analysis tool next - but I kinda got put off by Confio Ignite...

So - what app is missing from your toolbox?

Thought I'd ask here, because it's getting a bit tumbleweed at the minute (!).

P.S. Kev - sorry about the tags - they're probably wrong! :/
more ▼

asked Jul 08, 2010 at 12:01 PM in Default

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

Hmm must set tag limit to 15k.....
Jul 08, 2010 at 12:05 PM Kev Riley ♦♦
When you say 'got put off by Confio Ignite' what do you mean - got put off writing a perf analysis tool? Why?
Jul 08, 2010 at 12:06 PM Kev Riley ♦♦
@Kev: It means Matt likes Confios product so much he thinks it is a wast of time trying to build another performance analysis tool =) Is that right @Matt?
Jul 08, 2010 at 12:23 PM DaniSQL
@DaniSQL - what I mean is that I don't think I could do a better job than Ignite, really...
Jul 09, 2010 at 02:07 AM Matt Whitfield ♦♦
Ignite is a good app which helps visualize waits and queues. This is a best practice in performance tuning. If anyone has not read the doc you can download it here http://technet.microsoft.com/en-us/library/cc966413.aspx
Jul 11, 2010 at 02:44 PM Scot Hauder
(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

Matt, I have this silly idea about a simple tool for DBA's: [Please Don't laugh:-) ]

You know how documentation sucks. There are different tools that can scan your environment and document your server, Instance and database configuration. But what I need is some kind of tool that I could register all of my servers and when I do something everyday, instead of writing that on excel sheet or on notpad, I will open the tool(Lets call it "**DBA Diary**") then type what changes I made. Make this searchable and also grouped by date, week or whatever is easy for looking back. Also include int he tool any thing that you think will go with this idea(I am sure there are many...like the tool records if there are any configuration changes)

So i will take a note whenever I create a new index, or delete a user/create a user why i did that(when I did that would be recorded by the tool)

This would certainly help me improve my documentation habits and make my life easier:-)

more ▼

answered Jul 08, 2010 at 12:37 PM

DaniSQL gravatar image

DaniSQL
4.9k 33 35 39

I like this idea - one of the tools that is on my 'to do' list is a database documentation tool... so I think this would be a nice extension to that... Good idea :)
Jul 09, 2010 at 02:08 AM Matt Whitfield ♦♦
@Matt Also please add Script Library to the tool while you're at it:-)It will be a true personal DBA Diary
Jul 09, 2010 at 05:03 AM DaniSQL
I'm accepting this because I like the idea a lot, and I may well implement it. Personally I think the script library is something that should be in your editor - most editors (mine included) cover that functionality in some way...
Jul 14, 2010 at 09:11 AM Matt Whitfield ♦♦
Thanks Matt. I would be the first one to buy it(unless you give me a free licence :-). In all seriousness though it would be a very helpful for every DBA out there. Good Luck with the project.
Jul 14, 2010 at 11:09 AM DaniSQL
(comments are locked)
10|1200 characters needed characters left
A Visual Pivot Tool. Yes, and one that's even better than Excel's!
more ▼

answered Jul 08, 2010 at 12:31 PM

Mark gravatar image

Mark
2.6k 23 25 27

:) I'll knock that one up in a few minutes!! Ahem...
Jul 09, 2010 at 02:10 AM Matt Whitfield ♦♦
Slap together a front-end for DMVs while you're at it :)
Jul 09, 2010 at 06:04 AM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

Great question. For me the ultimate tool, would be a very comprehensive security/connectivity troubleshooting tool. This would be a prohibitively large project. It would go something like this: Why can't app x on computer a connect to app y on computer b and tell me exactly the steps to resolve it--no ambiguous error messages where you need to spend the afternoon searching the internet. Eg

Connectivity

1 Eliminate the basic networking issues. Is the TCP/IP stack installed and working, are dlls missing, services not started, can it ping 127.0.0.1. Can it ping/telnet to the remote computer, are there problems with dns resolution, dns cache, arp. What is the farthest appliance tracert can detect. Is the local windows firewall blocking, the target firewall or a firewall in between. Is it the wire/hardware itself? Is there something wrong with the connection string and what. I remember wasting time troubleshooting connecting to MySQL and found a semicolon missing in the connection string. The error message should have told me cannot connect to the server "mysqluid=root" instead of "cannot connect to server".

Security

2 What is the security context from a to b and how is it changed/impersonated along the way. Is kerberos needed, is constrained delegation configured properly. Is there a problem with certificates. Why isn't integrated security working through a firewall? I would want the app to give me explicit options such as: Switch to sql authentication in the connection string or use the security sub-system, create a local account on the sql server that matches exactly the same account for the app pool the Web site is running under. etc...what groups or permissions do I need exactly, none of the: you do not have permissions to access... The OS probably does this by design as not to give hackers a step up so you would need to give your app admin permissions so it can do all the necessary checking.

I know it is a pipe dream but even a pared-down solution targeting a single protocol and app (SQL server) would be worth more than you can imagine
more ▼

answered Jul 10, 2010 at 11:51 AM

Scot Hauder gravatar image

Scot Hauder
6k 13 15 18

I've been thinking about this one, and this one is definitely phenomenally hard - seeing as a lot of the information isn't readily available from an application stack... I'll keep thinking though!
Jul 11, 2010 at 04:56 PM Matt Whitfield ♦♦
You would have to feed the app a server admin account/password. Eg. (I know this isn't really sql related) but if you were trying to diagnose a remote desktop connection problem the admin acct could connect and check the registry to see that remote connections are enabled. I've thought for a while about creating such an app but it would also have code blocks for different OS versions so it would be a never ending project!
Jul 11, 2010 at 09:51 PM Scot Hauder
(comments are locked)
10|1200 characters needed characters left

There are two very useful things missing from my toolbox:

(1) Money, with which to buy tools

(2) Time.

If you can build a tool that sorts out those problems, then...

Seriously, though, look to your own strengths before building a tool of some sort. What aspects of the SQL world are you particularly good at? Is it something that can be encapsulated? Alternatively, what problems are you regularly required to solve and that you have some useful scripts for? Would it be a useful thing for others? Can this be "genericised" and then encapsulated?
more ▼

answered Jul 11, 2010 at 12:21 AM

ThomasRushton gravatar image

ThomasRushton ♦
33.8k 18 20 44

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x20
x17
x4

asked: Jul 08, 2010 at 12:01 PM

Seen: 1563 times

Last Updated: Jul 08, 2010 at 12:01 PM