DAB

We have about 9TB of data and I am looking to see how
many DBA we need to support that data ,Does any one have
way of finding out?
One good one or a whole bunch of not so good ones.
--=20
Keith
<anonymous@.discussions.microsoft.com> wrote in message =
news:1b0ab01c44fd4$cb4dc870$a601280a@.phx.gbl...
> We have about 9TB of data and I am looking to see how=20
> many DBA we need to support that data ,Does any one have=20
> way of finding out?
|||The DBA workload is likely to be dependent on factors other than simply the
size of your data. For example: the number of servers, users, developers and
development projects you need to support; the number and complexity of your
DB applications; whether you have to support features such as data loads,
replication, data warehouses or web servers, etc.
How do you manage the database administration today? If you don't already
have a DBA then hire someone with experience who can help you identify the
workload that is required - it's not something that can really be determined
from an online discussion.
David Portas
SQL Server MVP
|||Thanks, We do have nine DBAs now and about 90 servers,and
about Ten applications.

>--Original Message--
>The DBA workload is likely to be dependent on factors
other than simply the
>size of your data. For example: the number of servers,
users, developers and
>development projects you need to support; the number and
complexity of your
>DB applications; whether you have to support features
such as data loads,
>replication, data warehouses or web servers, etc.
>How do you manage the database administration today? If
you don't already
>have a DBA then hire someone with experience who can
help you identify the
>workload that is required - it's not something that can
really be determined
>from an online discussion.
>--
>David Portas
>SQL Server MVP
>--
>
>.
>
|||Hi,
The database size is not the determining factor here.How do you define
'support'? Is your DBA responsible only when someone cannot access the
databases or the server?Or, in addition, is he/she responsible for some
development,data modelling,setup or maintenance(administrative) work
too?Thus once you decide their course of work, do a estimation of the number
of hours per week/month/year they are supposed to work and whether you need
a DBA or groups of DBA for each above mentioned roles.The mentioned roles
could differ from company to company.If you dont know what all you want your
DBA to do, then consult with someone who does this kinds of staffing
business, like Microsoft Consulting Services or someone who is topnotch in
your location.You can also refer the Operations guide which should be
heldful in defining roles for the DBA:
'SQL Server 2000 Operations Guide'
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
<anonymous@.discussions.microsoft.com> wrote in message
news:1b0ab01c44fd4$cb4dc870$a601280a@.phx.gbl...
> We have about 9TB of data and I am looking to see how
> many DBA we need to support that data ,Does any one have
> way of finding out?