cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Creation of an environment based on a SQL Server storage

lmazurie
Honored Contributor

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,  

Lionel Mazurié
3 Replies

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.

Jerome

lmazurie
Honored Contributor

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 

Lionel Mazurié

jhorber
MEGA
MEGA

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

 

 

Jerome