Re: limit connections option

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanx Andrew.


--
Robert Vegas
System Administrator
Hostopia.com, Inc.
"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OI42EYgFGHA.3036@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>
> <rvegas@xxxxxxxxxx> wrote in message
> news:ep93k0fFGHA.2704@xxxxxxxxxxxxxxxxxxxxxxx
>> Thanx Andrew, is there any other way or tools to limit data trasnfer.
>>
>> --
>> Robert Vegas
>> System Administrator
>> Hostopia.com, Inc.
>> "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
>> news:ePvHazUFGHA.3200@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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
>>>
>>>
>>> <rvegas@xxxxxxxxxx> wrote in message
>>> news:%23boYuWUFGHA.1676@xxxxxxxxxxxxxxxxxxxxxxx
>>>>
>>>> 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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages