news:%23boYuWUFGHA.1676@TK2MSFTNGP09.phx.gbl...
>
> Under the server properties>> connections tab. I have an option "max
> concurrent user connections set to 0"
> Can some one plase tell me what is this for? and what should i set it to?
> This is a shared server with 150 databases belonging to different domains,
> and is excessible from the internet.
> Also is there a way to limit the amount of data transfered per database?
>
> Thank you
>
>
>

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:ePvHazUFGHA.3200@tk2msftngp13.phx.gbl...
> That option is just what it states. It will limit the server to x many
> concurrent connections. A setting of 0 means infinite or no limit and
> should probably not be touched. No there is no way in SQL Server to limit
> the amount of data transferred.
>
> --
> Andrew J. Kelly  SQL MVP
>
>
> <rve***@rogers.com> wrote in message
> news:%23boYuWUFGHA.1676@TK2MSFTNGP09.phx.gbl...
>>
>> Under the server properties>> connections tab. I have an option "max
>> concurrent user connections set to 0"
>> Can some one plase tell me what is this for? and what should i set it to?
>> This is a shared server with 150 databases belonging to different
>> domains, and is excessible from the internet.
>> Also is there a way to limit the amount of data transfered per database?
>>
>> Thank you
>>
>>
>>
>
>

news:ep93k0fFGHA.2704@TK2MSFTNGP15.phx.gbl...
> Thanx Andrew, is there any other way or tools to limit data trasnfer.
>
> --
> Robert Vegas
> System Administrator
> Hostopia.com, Inc.
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:ePvHazUFGHA.3200@tk2msftngp13.phx.gbl...
>> That option is just what it states. It will limit the server to x many
>> concurrent connections. A setting of 0 means infinite or no limit and
>> should probably not be touched. No there is no way in SQL Server to limit
>> the amount of data transferred.
>>
>> --
>> Andrew J. Kelly  SQL MVP
>>
>>
>> <rve***@rogers.com> wrote in message
>> news:%23boYuWUFGHA.1676@TK2MSFTNGP09.phx.gbl...
>>>
>>> Under the server properties>> connections tab. I have an option "max
>>> concurrent user connections set to 0"
>>> Can some one plase tell me what is this for? and what should i set it
>>> to?
>>> This is a shared server with 150 databases belonging to different
>>> domains, and is excessible from the internet.
>>> Also is there a way to limit the amount of data transfered per database?
>>>
>>> Thank you
>>>
>>>
>>>
>>
>>
>
>

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:OI42EYgFGHA.3036@tk2msftngp13.phx.gbl...
> None that I know of from a db by db standpoint. There is a feature in
> Win2003 called WSRM that you may want to look at. It allows you to set
> limits on CPU, Memory consumption etc. for an application but not for
> individual users or dbs within a single SQL Server app.
>
> --
> Andrew J. Kelly  SQL MVP
>
>
> <rve***@rogers.com> wrote in message
> news:ep93k0fFGHA.2704@TK2MSFTNGP15.phx.gbl...
>> Thanx Andrew, is there any other way or tools to limit data trasnfer.
>>
>> --
>> Robert Vegas
>> System Administrator
>> Hostopia.com, Inc.
>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
>> news:ePvHazUFGHA.3200@tk2msftngp13.phx.gbl...
>>> That option is just what it states. It will limit the server to x many
>>> concurrent connections. A setting of 0 means infinite or no limit and
>>> should probably not be touched. No there is no way in SQL Server to
>>> limit the amount of data transferred.
>>>
>>> --
>>> Andrew J. Kelly  SQL MVP
>>>
>>>
>>> <rve***@rogers.com> wrote in message
>>> news:%23boYuWUFGHA.1676@TK2MSFTNGP09.phx.gbl...
>>>>
>>>> Under the server properties>> connections tab. I have an option "max
>>>> concurrent user connections set to 0"
>>>> Can some one plase tell me what is this for? and what should i set it
>>>> to?
>>>> This is a shared server with 150 databases belonging to different
>>>> domains, and is excessible from the internet.
>>>> Also is there a way to limit the amount of data transfered per
>>>> database?
>>>>
>>>> Thank you
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>