473,378 Members | 1,360 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

How to get a batchjob to run on more than 1 processor ?

I have an SQL2000 server running on a 4-cpu 4 GB Win2003 system with
hyperthreading. The batch is running on only one virtual processor. I
would like to utilize all the processors in parallell in order to
speed up the batch. How ?
Jul 23 '05 #1
2 1142
Ray
Since you posted in the ms-sql group I'm going to assume the Batch you are
running is a SQL Batch or you have a DOS batch file including calls to bcp
or osql. SQL Server will split a batch (or any sql query) across multiple
threads depending on the number of processors assigned to the SQL Server,
the degree of parrallelism, and how the optimizer calculates the most
efficient path.

If you are referring to DOS batch files, that would be best posted to
another group.

"Andreas" <ah@steria.no> wrote in message
news:cd**************************@posting.google.c om...
I have an SQL2000 server running on a 4-cpu 4 GB Win2003 system with
hyperthreading. The batch is running on only one virtual processor. I
would like to utilize all the processors in parallell in order to
speed up the batch. How ?

Jul 23 '05 #2
Andreas (ah@steria.no) writes:
I have an SQL2000 server running on a 4-cpu 4 GB Win2003 system with
hyperthreading. The batch is running on only one virtual processor. I
would like to utilize all the processors in parallell in order to
speed up the batch. How ?


Most likely, you can't.

First of all, if your batch includes multiple statements, those cannot
be run in parallell. What can happen is that the optimizer decides to
use several processors to run a query. However, far from all queries
can be evaluated with parallel plans.

What you can do, is to use sp_configure to check the setting of "max
degrees of parallelism". If this parameter is 1, then parallelism is
turned, and you could change it to 4. (Not 8.)

Note also that parallel plans are far from always Godsent. Sometimes
parallel plans are plainly ineffective. And even if a query does
execute faster with a parallel plan, other users on the machine may
suffer, as the query monopolize the CPU.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ola Natvig | last post by:
Hi all I'm working with a long running, threaded server which serves HTTP requests with content which are passed through a XSLT processor. The XSLT processor I'm using is the Pyana processor. ...
6
by: shailesh kumar | last post by:
Hi, I need to design data interfaces for accessing files of very large sizes efficiently. The data will be accessed in chunks of fixed size ... My data interface should be able to do a random...
10
by: Jason Gyetko | last post by:
I'm running DB2 v8.1 FP5 on a Server with 2 physical processors (4 virtual) and am wondering if there is a way to configure DB2 to use more processor. Right now I'm running a delete query to delete...
4
by: kaiteriteri | last post by:
I have a time-consuming VB.net application that i'd like to thread over 2 processors (that's all i've got in my machine!) and, hopefully, get it done in half the time. On running, the application...
11
by: sunil | last post by:
Dear All, I have created a .Net service in 2.0 and running it on a machine that has a Quad Processor. It is failing with the following error. "Error 1053: The service did not respond to the start...
5
by: nano2k | last post by:
Hi I need to protect my application in a way. Just a "soft" protection, not a very strong one. So, using WMI I get the processor ID and compare it against a key. Protection works well, until...
5
by: =?Utf-8?B?dWxpbGxpbGxpYQ==?= | last post by:
I've had two issues plaguing me for 4 months now and I haven't gotten anywhere. I'm into making 2D games and these things are essential to games. These are my issues: 1. I need timing precise...
168
by: broeisi | last post by:
Hello, Is there a way in C to get information at runtime if a processor is 32 or 64 bit? Cheers, Broeisi
6
by: Peter Graf | last post by:
Hi, I want to use to quadcore processor to calculate a matrix with a C++-program. The elapsed time for calculating one entry is very variably (approx. 1-30 min) and I'm not able to estimate the...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.