question

Matt Whitfield avatar image
Matt Whitfield asked

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! :/
programmingtoolsmanageability
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
Hmm must set tag limit to 15k.....
3 Likes 3 ·
DaniSQL avatar image DaniSQL commented ·
@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?
1 Like 1 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
When you say 'got put off by Confio Ignite' what do you mean - got put off writing a perf analysis tool? Why?
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
@DaniSQL - what I mean is that I don't think I could do a better job than Ignite, really...
0 Likes 0 ·
Scot Hauder avatar image Scot Hauder commented ·
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
0 Likes 0 ·
DaniSQL avatar image
DaniSQL answered
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:-)
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
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 :)
0 Likes 0 ·
DaniSQL avatar image DaniSQL commented ·
@Matt Also please add Script Library to the tool while you're at it:-)It will be a true personal DBA Diary
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
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...
0 Likes 0 ·
DaniSQL avatar image DaniSQL commented ·
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.
0 Likes 0 ·
Mark avatar image
Mark answered
A Visual Pivot Tool. Yes, and one that's even better than Excel's!
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
:) I'll knock that one up in a few minutes!! Ahem...
0 Likes 0 ·
Blackhawk-17 avatar image Blackhawk-17 commented ·
Slap together a front-end for DMVs while you're at it :)
0 Likes 0 ·
Scot Hauder avatar image
Scot Hauder answered
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
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
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!
0 Likes 0 ·
Scot Hauder avatar image Scot Hauder commented ·
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!
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
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?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.