August 23, 2010 at 8:03 am
We would like to limit the # of connection to some sql server 2008 database What is the best way of doing it .....concurrent connections....
August 23, 2010 at 8:54 am
Change the "user connections" value in sp_configure
sp_configure 'user connections', Value
Value is the number of users that you want to restrict to
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 23, 2010 at 8:58 am
Will that stop users from accessing the database from a web app also
August 23, 2010 at 8:59 am
Will that stop users from accessing the database from a web app also
August 23, 2010 at 9:03 am
that would limit all connections, whether from your web app or form Management Studio; remember your web server will try too pool connections, so it'll be reusing some of those connectiosn for subsequent web requests.
what exactly are you trying to accomplish? Why limit the # of connections? I'm guessing you think that too many connections are hurting performance? Maybe you are trying to tackle a problem the wrong way...
Lowell
August 23, 2010 at 9:04 am
That's a server level setting, not a DB level setting. You can only restrict user connections at the server level. And it's global, meaning maximum number of SPIDs that get created.
August 23, 2010 at 9:19 am
Lic #
We have users accessing over the lic # limit
August 23, 2010 at 9:41 am
Lic #
We have users accessing over the lic # limit
August 23, 2010 at 10:57 am
Please
If you know of a better way to deal with this please let me know
Lic #
We have users accessing over the lic # limit
August 23, 2010 at 11:04 am
Hate to sound snarky, but yeah, the better way of dealing with it is to license per processor if you are using a web app. Best practices specifically recommend against using user CALs for a web app for exactly the reason you are encountering here. Web apps should always be processor-based unless it's behind a firewall and you know exactly how many users will be hitting the server.
August 23, 2010 at 12:02 pm
You didnt sound snarky to me. This isnt my area !!!
I guess I will do some more research on this best on what you say
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply