January 22, 2013 at 12:42 am
Hi All,
I am a newer in this forum. We are using SQL Server 2008 R2 Enterprise Edition in our Company. We are using single instance in our server. I have 500+ databases in my server.
Now my question is that how many user can access concurrent database per instance? Are 60+ database users can access this concurrently?
If not what will be the remedy?
January 22, 2013 at 1:09 am
i dont think there is any limitation of connections .SQL Server will handle large numbers of connections without a problem. A more important question is whether your database schema and application code will be able to handle it.
More users trying to access and modify the same data at the same time will likely lead to a lot more request blocking from all the table/row locking in the database. The performance of the app may slow to a crawl with that sort of usage. Without seeing your database schema, it's hard to tell. Although assuming you just did a simple conversion from Access to MS-SQL, it's likely you're not taking advantage of things a real RDBMS is good at like constraints, foreign keys, and indexing.
FYI SQL Server allows a maximum of 32,767 user connections.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply