Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Instances of SQL versus performance
Message
De
07/12/2007 10:54:26
 
 
À
07/12/2007 07:47:54
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01273867
Message ID:
01273966
Vues:
22
>Hi, again!
>Taking in attention performance (relative
>to RAM and processor) which option is the best:
>a) Have 4 databases in 1 instance of SQL;
>b) Have 2 databases at 2 instances of SQL.
>Thanks in advance
>******
>TONY Nascimento
>Cape Verde Islands
>West Coast Africa
>*********************

I think 4 databases in 1 instance of SQL is faster because you don't have the overhead in the server for the other copy of SQL Server running.

Maybe in a 64 bits machine or in a machine with 2 processors the answer varies.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform