Connections to sql server 2008

Question

Post reply

Connections to sql server 2008

cmf

SSC Enthusiast

Points: 102
More actions
August 23, 2010 at 8:03 am

#222982

We would like to limit the # of connection to some sql server 2008 database What is the best way of doing it .....concurrent connections....

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

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

cmf SSC Enthusiast Points: 102 More actions · Answer 2

Will that stop users from accessing the database from a web app also

cmf SSC Enthusiast Points: 102 More actions · Answer 3

Will that stop users from accessing the database from a web app also

Lowell SSC Guru Points: 323518 More actions · Answer 4

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 5

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.

cmf SSC Enthusiast Points: 102 More actions · Answer 6

Lic #

We have users accessing over the lic # limit

cmf SSC Enthusiast Points: 102 More actions · Answer 7

Lic #

We have users accessing over the lic # limit

cmf SSC Enthusiast Points: 102 More actions · Answer 8

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

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 9

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.

cmf SSC Enthusiast Points: 102 More actions · Answer 10

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