Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-10-22 : 07:26:44
|
| madhavi writes "I am doing stress test for our application. When I am using Hypersonic as the databaseI am able to test with 30 users successfully but when connecting to MQ SQL I am able to test with just 5 users successfully and if I try to test with more number of users I am getting thefollowing error on some of the users: [java] java.lang.RuntimeException: com.meterware.httpunit.HttpInternalErrorException: Error on HTTP request: 500 Internal Error [http://localhost:8765/enlighta/dashboard]The same tests goes successfully for hypersonic but not MS SQL. Any suggestions would be greatly appreciated.Thanks,Madhavi" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-10-23 : 14:14:29
|
| Are you using the MSDE version of SQL Server? If so, you can only have 5 concurrent user connections. After that you have to upgrade. It cost bucks after that. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Stress test for a web application using MQ SQL