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.