Post reply

DBA''s reference app

  • September 20, 2005 at 11:37 am

    #110016

    Question - does anyone here use a database / application to keep track of databases, servers, etc. that are supported by your DBA team?

    I'm a DBA in a large organization that employs many DBAs and we support many applications, databases etc.  Several years a go we developed a SQL Server database with an Access frontend to keep track of everything we support.  But our "application" is far from ideal.

    Do you use anything similar to this?  It yours home-grown, freeware, etc?  We need to store info about applications, databases, servers, accounts, passwords, etc.  Thanks

  • September 20, 2005 at 2:08 pm

    #591488

    We have a database that keeps track of servers, databases and anything we want for monitoring and reporting purposes.  We don't have front end support though, but since it is only used by DBAs, we all should know how to get the data out if we want more detail then what the report generate.  We don't keep track of user login or password though because it is their business to remember their password.  It is all home grown.

     

    mom

  • September 21, 2005 at 6:42 am

    #591694

    We have our own home-grown SS2k database for this which maintains information about the servers, the databases, the applications etc..  We support Oracle, SQL Server and DB2-UDB and have lots of servers and database instances in-house and hence there was a need to do this.  The home-grown application uses a very simple ASP application to allow making updates to this schema directly.  The monitoring and reporting is done based off this schema - in addition there are nightly jobs that run to see if there were any errors reported in the SQL Server Error logs, in the Oracle alert logs etc. and parses and logs those in tables in this schema.  Another nightly job checks this status and if there were errors, the DBA team gets notified about it.  Same is done for locking output and resource utilization snapshots.

    We ended up writing our own home-grown application for this since we did not find anything in the market that could do this for us.

Viewing 3 posts - 1 through 2 (of 2 total)

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