May 28, 2008 at 9:15 pm
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?
May 28, 2008 at 9:22 pm
BTW;
some database are for testting but not aware of it..
any softwares or application do i need for this?!?
i'm screwed..;p
May 30, 2008 at 10:23 am
anyone?!?
theres no ryt or wrong answer here.. i just want opinion...
or advice..
thnks
May 30, 2008 at 1:19 pm
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
May 30, 2008 at 1:37 pm
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
May 30, 2008 at 8:54 pm
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
May 31, 2008 at 2:22 pm
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
May 31, 2008 at 3:45 pm
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