| Simon Harvey 2006-03-05, 8:24 pm |
| Hello SQLCatz,
> Hello,
>
> Have a few questions regarding SQL Server 2005.
> (a) What is the maximum number of SS2005 instances that can exist on a
> single server. (SS2000 it was 16)?
was just a guide that MS officially supported - it wasnt enforced :-)
[color=darkred]
> (b) What is the maximum number of active connections in SS2005 on
> Windows
> 2003 DC?
You can configure this manually. Again I dont know if there is a hard limit
- I'm sure you would run out of bandwidth before hitting any arbitary limit.
To give you an idea, my server is configured to limit the number of connections
to 4000
> (c) Processor and Memory affinity.
> Can these settings be changed without stopping and starting the
> instance?
time settings from within the OS as opposed to in SQL server I think. Hmmmm.
Maybe not the affinity, but the processor time certainly
[color=darkred]
> Dynamically between instances?
> Cheers
> SQLCatZ
|