Home > Archive > MS SQL Server > March 2006 > User Connections









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author User Connections
rupart

2006-03-08, 3:23 am

Hi,
If i leave default value for this setting(which is 0 [unlimited], it is said
the server will handle it automatically. How the allocation handled by the
server? Do we usually set the value? Or it will assign max 32,767 and
consumes the resources?
TQ
Russell Fields

2006-03-08, 8:23 pm

Rupart, We usually leave it at 0 and allow the server to add or remove
connections as needed. - RLF
"rupart" <rupart@discussions.microsoft.com> wrote in message
news:47A226F9-08DA-434F-8B35- 73FB85C339DF@microso
ft.com...
> Hi,
> If i leave default value for this setting(which is 0 [unlimited], it is
> said
> the server will handle it automatically. How the allocation handled by the
> server? Do we usually set the value? Or it will assign max 32,767 and
> consumes the resources?
> TQ



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com