I am performing backend ( SQL Server2008) stress testing using VSTS2008.TI have a web application which pointing to CRM DB(SQL Server2008).
My Approach is:
1.Seaching an item from the portal.
2.Log in to the DB Server and capture the Stored Procedure from the SQL Server Profiler.
3.I am using that stored procedure to create a DB Unit test.
4.Using this Db Unit test, i am creating a load test.
5.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)
Error 2:More than 1000 errors of type 'TestError' and sub type 'TestError' have occurred; additional errors of this type will not be reported.
1.How can i findout why this occurs.
2.How i will find the threshold beyond which the number of connection error start showing up in CRM DB.
3.What can be done to fix/tuning?
View Complete Post