| || |
sqlserver has been optimized for 8 concurrent user
When i run a script for login and logout to an VB application that is pointing to MSDE 2000, it throws error stating "The SQL SERVER has been optimized for 8 concurrent queries. This limit has been exceeded by 2 queries and performance maybe adversely affected".
Iam testing the application with ODBC settings and running the test under controller and an agent without giving any simulation time for the test.
Cud anyone help me why this error is coming even when i split the vuser to 4 each in controller and agent having its separate DSN pointing to the same database server.I need to run the test concurrently.
Re: sqlserver has been optimized for 8 concurrent user
If you running multiple iterations, possibly you are executing more then 8 queries simultaneously.
Or someone also connecting to the MSDE.
Check how many users queries running at the same time when you're getting this error.
MSDE does not have it's own Profiler tool which allows you to log activities.
You can use SQL Admin tool, if you have a full blown SQL server.
OR, while executing a single user, run netstat -an and look how many sockets are open for connection with MSDE, then compare how many are open when you are getting an error.
If its more then 8x times as much, you have more then 8 users connected