Re: limit connections option

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