We help IT Professionals succeed at work.

MS-SQL Scalability

sctb1
sctb1 asked
on
270 Views
Last Modified: 2010-03-19
I have an application developed in PowerBuilder 5.0.02 using Sybase SQL Anywhere as the database engine.  This was fine because all sites up to now have had less than 30 users.  I now have a requirement to be able to handle 200+ concurrent users and I know that SQL Anywhere could never handle this.  My question is can MS-SQL handle this many users?  Will my application crawl and have too many records locked for this to be a realistic goal?  The application is a fat client with no middle tier so I don't think I can use any transactions processors like MTS to gain performance.

Any advice is greatly appreciated.
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
vvk

Commented:
You can also use Enterprise Edition of SQL server. It can support clustering to ensure that you can get fully scalable solution.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.