Space requirements for microsoft project server

[db]

We have about 1400 employees and about 25 will use microsoft project for
maintaining there projects.

I need to set up a database on sql server 2005 for storing project data.
How much disk space we will need (General estimate for three years).

Thanks

dbdba

 

[Ray McCoppin]

-- The requirements you are asking for are really hard to come up with.
Because the number depend in on the Project Server usage scenario. For
example a project server that is used for a professional services management
firm uses more than a Corporate planning system. In most cases for Project
Server 2007 a schedule that uses 100k in a file system MPP file will consume
800k in project server. You can get a good feel for how much space will be
used using this rule of thumb, but if the Project Server processes and
customization are very extensive you will consume more space. For example a
project server that has 8 custom task fields viruses a project server that
has 8 project custom fields will use up much more space depending on the
number of tasks and assignments that the custom task fields are used in.
Also timephased data consumes a lot of database space especially actual work
by day. So a time goes on you will see long running projects (over 12-18
months) get very large.
We have a report on our site that can show you the space used by projects.
Below is the link
http://www.randsmanagement.com/Prod...rtsPack/MyProjectsSize/tabid/149/Default.aspx

Hope this helps

Ray McCoppin

http://www.randsmanagement.com
Project Server 2007 Archive Tool
SSRS Reports
SRS gantt charts

 

[db]

Thanks Ray. Looking at the report can we say per user usage is 10 MB. For
20 users 200 MB.

Is 1 Gb space safe.

 

[Ray McCoppin]

It more of per project basis. how many project per year (or your archival
period). And how much space does a project use.
Then you have to deal with timephased data growth.


Hope this helps
--
Ray McCoppin

http://www.randsmanagement.com
Project Server 2007 Archival tool
SRS gantt charts

 

[Gary Chefetz]

I think the other major consideration in allocating drive space for Project
Server databases is log file size and, therefore, recovery method you plan
on using.