General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only