.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Can i go ahead including hint: Option (MAXDOP 1) in my Backend Stress Test

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
 
Hi,   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


More Related Resource Links

Can i go ahead including hint: Option (MAXDOP 1) in my Backend Stress Test

  
Hi,   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

Can i go ahead including hint: Option (MAXDOP 1) in my Backend Stress Test

  
Hi,   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

Test Run: Stress Testing.

  

Stress testing is a fundamental quality assurance activity that should be part of every significant software testing effort. The key idea behind stress testing is simple: instead of running manual or automated tests under normal conditions, you run your tests under conditions of reduced machine or system resources.

Dr. James McCaffrey

MSDN Magazine May 2006


Visual Studio 2008 Web Test Option Missing

  
I initially installed Visual Studio 2008 Developer edition.  I then installed Visual Studio 2008 Suite edition, with 2008 Developer edition still on the PC.  When attempting to create a new Web Test, this option is not available to select when adding a new test in the solution.  The steps I followed: 1) Create new Project:  Test Project 2) Add "New Test" 3) At this point I would expect "Web Test" to be an option, I only have Ordered Test, Unit Test, and Unit Test Wizard.   Do I need to uninstall Visual Studio 2008 and start with a clean Visual Studio 2008 Suite to get the "Web Test" option to show?

Test your skill in SQL Server

  
You will be given a series of 10 SQL Server related questions that are randomly selected. Since the questions are randomly selected, you will receive a different set of questions each time you start a test. At the end of the last question, you will be given your score. You can then start a new test session if you like.

VS 2010 HTML validation "in CSS" option - where the hell is it?

  

In VS 2008 there is a very useful feature of background HTML validation - it checks if CSS class name is valid i.e. it exists in one of the linked css files. But VS 2010 Express does not do that any more. And the relevant setting in Options->Text Editor->HTML->Validation->in CSS is not there. Ok, maybe they made it paid for option? VS 2010 Professional? Not there. Or maybe VS 2010 Ultimate? Not a trace.

1. am I blind?

2. they decided it is too convenient to use and removed it?

3. they will "introduce" it in SP1?


What is going on? That one thing made me move back to VS 2008 web developer.

Maciej


Test Run: Fault Injection Testing with TestApi

  

Fault injection testing is the process of deliberately inserting an error into an application to determine whether it deals with the error properly. We'll explain how you can introduce faults into .NET applications at run time using the Managed Code Fault Injection APIs of the TestApi library

James McCaffrey

MSDN Magazine August 2010


Test Run: Generating Graphs with WPF

  

A common software-development task is generating a graph from a set of test-related data. But if you're doing it by hand and the underlying data changes frequently, this particular task can become quite tedious. James McCaffrey shows you how to automate the process using Windows Presentation Foundation technology.

James McCaffrey

MSDN Magazine June 2010


Test Run: Combinations and Permutations with F#

  

Understanding combinations and permutations is a fundamental skill in software testing. We show you how to work with combinations and permutations using code written in the new F# language.

James McCaffrey

MSDN Magazine May 2010


Test Run: Testing Silverlight Apps Using Messages

  

Silverlight greatly simplifies the process of building rich Web applications, and we'll walk through an example of using Messages as a quick method of interactively testing simple Silverlight apps.

James McCaffrey

MSDN Magazine March 2010


Test Run: WCF Service Testing with Sockets

  

There are many ways to test WCF services, but the socket-based approach is flexible and very useful for security and performance testing. We show you show you how to test a WCF service using a network socket based approach.

James McCaffrey

MSDN Magazine February 2010


Test Run: Web Application HTTP Request-Response Test Automation with JavaScript

  

Write a simple browser-based request-response test automation using JavaScript that's platform independent and useful when you are working in a highly dynamic environment.

James McCaffrey

MSDN Magazine January 2010


Generation Test: Automated Unit Tests for Legacy Code with Pex

  

Creating and maintaining a unit test suite for legacy code can be a challenge. Pex automatically produces a small test suite with high code and assertion coverage.

Nikhil Sachdeva

MSDN Magazine December 2009


Test Run: Pairwise Testing with QICT

  

In this month's column, James McCaffrey explains exactly what pairwise testing is and provides you with complete C# source code for a production quality pairwise testing tool named QICT.

James McCaffrey

MSDN Magazine December 2009


Extreme ASP.NET: Looking Ahead to ASP.NET 4.0

  

When Visual Studio 2010 and .NET 4 arrive next year, ASP.NET developers will have two mature frameworks for building Web applications: ASP.NET Web Forms and ASP.NET MVC. This article highlights some of the important new features for these two frameworks.

Scott Allen

MSDN Magazine December 2009


Test Run: Partial Anitrandom String Testing

  

This column presents an approach to Antirandom (AR) testing the author calls partial AR string testing, which can be used to test a wide range of software systems.

James McCaffrey

MSDN Magazine October 2009


Test Run: Request-Response Testing With F#

  

This month we show you how to use F# to perform HTTP request-response testing for ASP.NET Web applications.

James McCaffrey

MSDN Magazine July 2009


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend