Problem with bacth processing

Question

Post reply

Problem with bacth processing

Bermo-498612

SSC Rookie

Points: 28
More actions
September 26, 2007 at 9:11 pm

#181665

what are the things i need to consider when creating a batch process in my server??

Viewing 12 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Ninja's_RGR'us

SSC Guru

Points: 294069

September 26, 2007 at 9:28 pm

#736589

What is that process doing?

Bermo-498612 SSC Rookie Points: 28 More actions · Answer 2

It insert, update and delete more than 100,000 records..

this is the scenario: i have a web application made in ASP NET 2003 that executes the batch processing. when the user connect to my web application, im in an intranet only, then start the batch processing by clicking on the "Process Batch" button on my web page. a process id (for example spid 57) on Sql Server will run and start doing the INSERT, UPDATE and DELETE.. by the way my SQL Statements is inside my DLL not in STORED PROCS.. so the one executing it is a thread. but after 30mins a new process id will run (spid 59) at the same time and do the same thing... now 2 process id is running at the same time.. my question is why does sql server create a new process id???

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

How big is the worked table??

Sometimes it's just faster to truncate / reload.

Jeff Moden SSC Guru Points: 1004639 More actions · Answer 4

If it's only 100K rows, lock the table when you do the delete... it'll take less than 10 seconds if you do it right.

Of course, if you have 72 indexes on 26 columns with 42 delete triggers, then you might have to consider a slightly different approach 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

I'm feeling a real life story comming from you Jeff... right about now ;).

Jeff Moden SSC Guru Points: 1004639 More actions · Answer 6

Yeah, huh? Can you feel the love there? :laugh:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

Ninja's_RGR'us

SSC Guru

Points: 294069

September 26, 2007 at 10:15 pm

#736617

Not at this hour... need to go to bed :hehe:.

Bermo-498612 SSC Rookie Points: 28 More actions · Answer 8

please help me on this issue.. this is my YM id "berm0"

Jeff Moden SSC Guru Points: 1004639 More actions · Answer 9

Already did... look at my previous post... the one where I tell you to just lock the table. Also, Remi asked how many total rows are in the table... we're waiting for an answer on that...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Bermo-498612 SSC Rookie Points: 28 More actions · Answer 10

my problem is that after 30mins why does SQL create another process that executes the same procedures...

by the way i have only 1gb memory... does it affect the processing??

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 11

That me be a solution but I wouldn't start there. PLEASE answer the questions we asked, we need that to go on and help you.