centralizing database administration

  • Situation:

    i have 4 business Unit; at least 8 Database server each and each server has an average of 10 databases each. lets say, i have 300 databases to monitor and administer.

    (mix of MS SQL 7 and MS SQL 2000) some has logshipping but no cluster and replication. so basicaly just some standard administration

    Problem:

    1. how many number of database do you think a dba can handle?

    2. is it possible to just have one database server where i can run scripts and have the reult for all server? can i run script to monitor database growth in server A but i want to execute it in server B.)

    (not sure if Linked server does)

    3. any idea to lessen my work load?

  • BTW;

    some database are for testting but not aware of it..

    any softwares or application do i need for this?!?

    i'm screwed..;p

  • anyone?!?

    theres no ryt or wrong answer here.. i just want opinion...

    or advice..

    thnks

  • A DBA can handle any number of databases but it depends on how he is handling...

    you can automate the job failure report/error log report/database and object growth report to write to one server and report off of that server using sql mail or db mail...

    You can do using tsql or you can purchase third party tools to do it for you...

    MohammedU
    Microsoft SQL Server MVP

  • if you have scripts that you want to run from a central location against many servers, you can use SQLCMD for that. It's very useful for that kind of thing, and it's easily automatable.

    ---------------------------------------
    elsasoft.org

  • lets say i'm in my local pc using my query analyser

    is it posible a stored proc that will retrive or insert info to diff instance name? or how will i do that?

    sorry for this noobish question.. im way too long in learning ms sql 2000 and now here comes sql 2005 and 2008..;p

  • I don't understand your question.

    SQLCMD is the replacement in 2005 for OSQL.exe if you are familiar with 2000 administration surely you know osql. sqlcmd is easy to learn if you know osql.

    both of these are command line tools. you don't use them from query analyzer, rather from a DOS prompt or batch file.

    ---------------------------------------
    elsasoft.org

  • paksyeet (5/28/2008)


    Problem:

    1. how many number of database do you think a dba can handle?

    2. is it possible to just have one database server where i can run scripts and have the reult for all server? can i run script to monitor database growth in server A but i want to execute it in server B.)

    (not sure if Linked server does)

    3. any idea to lessen my work load?

    #1 - It depends on what is expected per database. This is a really open-ended question.

    #2 - Yes. One possibility is to use linked servers from Server A. As mentioned, using SQLCMD will allow you, from the command line to run any query you want against any SQL Server you want to authenticate against. You could also use VBScript, PowerShell (provided you have it installed), or Perl (provided you have it installed) if you need to build more intelligence in.

    #4 - Automate everything you can. Only allow the alerts to come up that's truly important. Build scripts for repetitive tasks.

    K. Brian Kelley
    @kbriankelley

Viewing 8 posts - 1 through 7 (of 7 total)

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