I am performing backend (SQL Server2008) stress testing using VSTS2008.I am using some select quires in my Database Unit testing and using this in my load Test script.
I have run the load test for 200, 100 and 50 Virtual users. Each time i am getting below errors.
Error 1:DatabaseUnitTest1.DatabaseTest1 threw exception: System.Data.SqlClient.SqlException: The query processor could not start the necessary thread resources for
parallel query execution.(error Count 1000)
As the description says, processor could not start the necessary thread resources for parallel query execution, so, there might be a cause that, Parallel queries execution
is much slower. So i have included hint: Option (MAXDOP 1) in the Database Unit Test.
Hint: Option (MAXDOP 1)
The Max Degree of Parallelism or MAXDOP is a configuration indicating how the SQL Server optimizer will use the CPUs. Option (MAXDOP 1)
is a hint. This will run the query much faster. When SQL Server uses parallelism, it runs slower. This is a server wide configuration that by default uses all of the CPUs to have the available portions of the query executed in parallel. So the query is executing
much faster and there is no thread allocation issue.
Again i ran the load test script starting 50, 75,100,150,200,250,300,400 users. The entire test run successfully without any performance related issu
View Complete Post