Hi,

I have a big server (W2008R2 64-bit 32GB 8CPU)
It is designed to be used as a dedicaced SQL Server 2008 64-bit
for many applications.
My question is:
Is it better to have a single big instance
or to have several smaller instances ?

Thanks in advance

Few instances means less to manage. Unless you have compelling reasons to
use multiple instances, I suggest you stay with just the one. That said,
there are some cases where you need to set something instance-wide:

collation
degree of parallelism
trace flags
error messages

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"bob123" <bob123 (AT) gmail (DOT) com> wrote

Hi,

I have a big server (W2008R2 64-bit 32GB 8CPU)
It is designed to be used as a dedicaced SQL Server 2008 64-bit
for many applications.
My question is:
Is it better to have a single big instance
or to have several smaller instances ?

Thanks in advance

collation can't be set at database level ?

It can. However, server collation determines the collation of the system
databases.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"bob123" <bob123 (AT) gmail (DOT) com> wrote


collation can't be set at database level ?