SQL Server Planning and Sizing

[Stephen ...]

Hi,

I am about to move all over our current and future models to a SQL Server host.

I am trying to get some information to help me size the infrastructure needed and to set up the SQL DB appropriately.

In order to try and calculate DB capacity to cover current and future usage the sort of information that I could do with is:

+ Generalised sizes for Small, Medium and Large models
+ Some indication of what you would consider to be a Small, Medium or Large model
+ Any size info for Small, Medium or Large team sizes, any db impact per user.

I’m going to have to provide some form of reasoning to my DB Admin for the amount of disk which I request.

I did put this question to the Sparx support team but the response was to open the EABase and EAExample models for some indication of size for a small and medium model respectively.  Surely there is some standard indicators for sizing SQL DB's to hold EA models.

All help appreciated,

Thanks,

Stephen ...

[Transition Technologies]

Hi Stephen,
Here are some suggestions by Sparx to upsizing the SQL Server:
http://www.sparxsystems.com/resources/corporate/sql_server_instructions.html
Maybe that can help You.

[Stephen ...]

Thanks for your reply,

I'd actually seen those instructions and although they give me a great starting point, I really need to get details on the storage requirements I'm going to need to support future design on models hosted on the SQL platform.

DB Administrators are (quite rightly) very picky about  that sort of thing.