Concurrent Database Access Per Instance

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Concurrent Database Access Per Instance

Concurrent Database Access Per Instance

Rate Topic

Display Mode

Topic Options

Author

Message

niladri.primalink

Posted Tuesday, January 22, 2013 12:42 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, May 12, 2013 11:35 PM
Points: 20, Visits: 45

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?

Post #1409837

Bhuvnesh

Posted Tuesday, January 22, 2013 1:09 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1409846

« Prev Topic | Next Topic »

Permissions