Admin GUI for SQL Server

  • I want to build an admin GUI for SQL Server.

    I know what you're thinking. "There's this little known piece of software called 'Enterprise Manager', moron!" Maybe I should have said I want to build a better Admin GUI for SQL Server in a multi-Server environment.

    I like EM well enough but once you have more than 20 or 25 sql servers it gets annoying. So people start creating scripts that pull together various info. For instance, in the morning and periodically throughout the day I view an html page that is a variation on a script that I pulled off of this marvelous site.

    It's pretty simple, it's an active-x script in a DTS job that just pulls data on failed jobs for a dated time period and writes them to an HTML table.

    It's scheduled to run every half hour or so and works fine. But I want more.

    What would be great would be if Enterprise manager would allow you to add views to it like task pad but that provided aggregate data from multiple servers.

    I've read about the SQL Server Digital Dashboard. Is this anything similar? Anyone out there implemented the DDRK?

    Has anyone built anything like this that is willing to share?

    Does anyone want to start a group project to create some software that could be provided as freeware? Maybe with SQLServerCentral's name plastered all over it for a little more advertising. It could be some sort of web template where you could plug in modules that people submitted


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • I am interested. let me know in more details (rahuularya@yahoo.com).

  • Quite interesting, Keep me in the loop...heda_p@yahoo.com

    Prakash

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • I created a blog for people interested in joining the project. If you want to join just send me an email at brenbart@yahoo.com.

    http://sqlservergui.blogspot.com


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • Hi BrenBart,

    quote:


    I created a blog for people interested in joining the project. If you want to join just send me an email at brenbart@yahoo.com.

    http://sqlservergui.blogspot.com


    maybe I missed it, but what programming language are you thinking of?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • It's up in the air really. I'm totally starting from scratch. My preference is something web based and ASP is sort of a minimal effort when it comes hosting on MS servers.

    Then again as far as web programming goes I like PHP better.

    My thought is to have something as a framework such as the login, main menu and alerting. Then set some sort of standard where people could plug in other components.

    For instance, if you have a VB program that performs a task you do frequently that is related to databases then you should be able to link that application to the admin gui. Whether it's just a link that fires up a vb program or even better something that can interact with that program.

    (I'm fleshing this out as I go along so pardon any duplication on my part.)

    These are the main components are what I'd like to see:

    ~Summary data

    -job status

    -disk space

    -maintenance plan status

    ~Scheduling

    -Jobs on all servers

    -Maintenance plans

    -Performance monitoring

    -Personnel tracking

    -Hardware Maintenance

    -Projects

    ~Documentation

    -Contact info

    -DBAs

    -Database Owners

    -Vendors

    -Application developers

    -Issue Tracking

    -Procedural documentation

    -If X goes wrong then contact Y and

    run the script to adjust the

    Johnson Rod.

    -If you want to change a maintenance

    plan you need to get permission

    from...

    Primarily I want these items integrated together so that the DBA can see and be notified of problems before being notified by the database owners or application people.

    I want to be able to open this tool, be alerted to an issue, click a link that will take me to the problem area, allow me to fix the issue and log all the relevant information.

    Obviously that's asking for a lot. However, most of the individual parts are simple enough and many have scripts right here in the script library.

    I want a GUI that is a basic template but is easily customizable. I want an inexperienced DBA to be able to download it, connect it to his servers and be saying "Oh, it's monitoring the such and such. I didn't even realize I should be watching that."

    Ok, way more information than you asked for but as I said I'm sort of hashing this out as I go along.


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • Oh yeah, and we need a name. Preferably something that is short or has an acronym.

    MAGI - Multiserver Admin Graphic user Interface

    DAMIT - Database Admin Manager Interface Tool


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • quote:


    Then again as far as web programming goes I like PHP better.


    yak, I'm struggling with PHP on my own website, but PHP hosting is cheaper than ASP hosting here. Couldn't say right now if I like it.

    quote:


    DAMIT - Database Admin Manager Interface Tool


    actually I like this on. No one can tell if you mean a program or something else if you shout it out loud

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • There may be some overlap with this project:

    http://sourceforge.net/projects/asp-ent-man/

  • I just found that yesterday. It's also at http://www.aspenterprisemanager.com

    It seems like a logical starting point but then too, I'd have to learn ASP.Net...

    I suppose though, with Yukon right around the corner...


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

Viewing 10 posts - 1 through 9 (of 9 total)

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