April 7, 2008 at 9:16 am
hi,
Iam trying to limit no.of concurrent connections to a database to 10 ?
how can I do this task? where can I find this option/
thanx
April 8, 2008 at 5:19 am
Hi,
Try this method
In Object Explorer, right-click a server and click Properties.
Click the Connections node.
Under Connections, in the Max number of concurrent connections box, type or select a value from 0 through 32767 to set the maximum number of users that are allowed to connect simultaneously to the instance of SQL Server.
Restart SQL Server
April 9, 2008 at 2:53 am
Just for intrerest, why do you want to limit the number of connections? SQL Server can easily cope with hundreds of simultaneous connections.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 9, 2008 at 11:40 pm
Is there any way to limit the connection to single DB. I have SQL Server which act as central server and we have 9 db:) on it. Thanks.
April 10, 2008 at 12:29 am
Hi
Do you want all users to connect to connect to a single database or only one user to connect to a database?
Why do you need this restrinctions in the first place.
"Keep Trying"
April 10, 2008 at 2:18 am
i have a haevy transactions applications one of them is BlackBerry which uses almost 600 - 1000 :w00t: connection some time ... also few in-house applications which uses many connection ... though SQL Server is also high configuration 32gb ram 8 duo processor ect with active/passive ... so I really do not have performance issue ... but we get sometime login failure issues ... I am working on in house applications who are using many many connection but if I have some kind of control i would know exactly which DB is saturating the connections. Thanks 🙂
April 16, 2008 at 12:28 am
Hi
I dont think there is any configuration that allows you to restrict the number of connections per db.
How ever you can check for who are connected to a db using sp_who or sys.sysprocesses or other DMV's.
Using this info u can restrict the number of connections from your application.
"Keep Trying"
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply