Book a Demo

Author Topic: sizing a DBMS server  (Read 5377 times)

Robert Sheridan

  • EA User
  • **
  • Posts: 105
  • Karma: +0/-0
    • View Profile
sizing a DBMS server
« on: February 24, 2014, 10:42:34 pm »
Hi,
We want to get a DBMS server set up, the admins are wanting sizing information and the answer 'do not worry, wont use a huge amount of space' is not good enough. The model will start as just being busines architectue.

The data I have to gleaned to date is the following:
Network latency no greater than 100 m/s
200 Mb RAM should be sufficient for even a large repository

Can anyone give me any figures on the amount of disc space used by their repositories and a guess at whether their repository is small, medium or large.  this will also help us estimate how much disc space might be needed in the future.

Thanks
Robert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: sizing a DBMS server
« Reply #1 on: February 24, 2014, 11:02:06 pm »
I once setup a MySQL server on a desktop for some 20 modelers working on a (I'd say) medium size model. Actually the resources were so modest that remembering them was not worth while. DB admins always expect some huge customer database. Compared to that an EA repository is nothing minus 10.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: sizing a DBMS server
« Reply #2 on: February 25, 2014, 05:55:07 pm »
Our biggest model (about 100.000 elements) reports a size of 1.5 GB on SQL Server.

I think this might be one of the biggest models out there.

Geert

Robert Sheridan

  • EA User
  • **
  • Posts: 105
  • Karma: +0/-0
    • View Profile
Re: sizing a DBMS server
« Reply #3 on: February 25, 2014, 06:11:07 pm »
Thanks guys, just need something to keep the admins happy.

Robert