Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Jul 16, 1999

Max users

Question:
I have 20 user licenses. During some activities, users are being logged in two or three times. Thus I can hit a max user limit with only 9 actual users. Any suggestions on what to look for to minimize this? We are running SQL Server 6.5 and 7.0 as "back-end" linked to Access via ODBC as "front-end".

Answer:
There are technologies now that allow something called pooling, where connections are shared between users. MTS keeps connections alive after they are used so that they can be re-assigned to new users. Also, your application's architecture could have an influence on how many connections are created and how they are used.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap