Creation of an environment based on a SQL Server storage

[lmazurie]

Hi,

The creation of my environment under a new SQL SERVER instance has been running for 4 hours in my VM on WINDOWS SERVER 2012 R2  Standard with an Intel Xeon CPU 3,07 GHz, RAM 4 GB.

I will upgrade it to 8 GB.

A large duration of installation with RDBMS storage is normal ?

Thanks for information and tuning tips,

Regards,  

[jhorber · Accepted solution]

With GBMS storage, the systemdb is pre-built.

It has been build by MEGA and is only uncompressed when creating the environment: this takes a few minutes

With RDBMS storage, the systemdb is build dynamically when creating the environment by importing various files.

This can take several hours.

[lmazurie]

Hi Jérôme,

I was quite surprised and I think it would be nice to talk about it in the guides.

i am going to perform a performance test

Our installation was OK.

Thx 

[jhorber · Accepted solution]

Hello Lionel

The creation of a new environment with RDBMS storage (Oracle, SQL) lasts more than one hours (usually 1 or 2 hours)

Duraction can vary mainly with 

• The performances of the machine where is started the environment creation (sql client)
• The latency (<1 ms expected) and bandwidth between the sql client and the database server