data mining structure processing issue

Question

Post reply

data mining structure processing issue

kbatta

SSCrazy

Points: 2274
More actions
May 24, 2008 at 2:28 pm

#190993

I am trying to do a full process on a data mining structure with 2 models (decision trees and naive bayes) where the main table is small (3000+ rows). It is the MovieClick exercise in the book "Data Mining with SQL Server 2005" by Tang and MacLennan. The processing has been running for over 7 hours and has been in the status "Reading cases: 0 cases read" for almost all of that time.
Here is what "View Details" contains:
I am using the developer edition on my home pc.
What should I check to identify the problem?
Thanks!

Viewing 8 posts - 1 through 7 (of 7 total)

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

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

Please check you post... can't see what you posted for the "view".

--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)

kbatta SSCrazy Points: 2274 More actions · Answer 2

Thank you. I see one cannot just copy and paste things into the message. The text was there when I hit Post Reply. I have since cancelled the job so cannot resend it.

ccasaca Newbie Points: 1 More actions · Answer 3

I have the same error.... on same exercise...

Do you already know how to over come this?

Thanks

kbatta SSCrazy Points: 2274 More actions · Answer 4

Not yet. I wish there was a way to reach the authors.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 5

We're still waiting for you to post something that can actually be troubleshot...

--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)

ipekguven SSC Rookie Points: 45 More actions · Answer 6

I've had the same problem and solved following the instructions in this thread:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3560853&SiteID=1

You can read the reason and detailed explanation of the problem but at the end you have to make this changes:

"

.....................

A change like below will solve the thread starvation problem:

- CoordinatorExecutionMode from -4 to -16

- ThreadPool\Process\MaxThreads from 64 to 128

- ThreadPool\Process\Concurrency from 2 to -4

Changing the CoordinatorExecutionMode from -4 to -16 allows for running 16 concurrent tasks per CPU, enough to complete the processing of the 7-nested tables model mentioned above

"

Above the mentioned ones I couldn't find a property "ThreadPool\Process\Concurrency" even in the advanced categories. But changing the other two properties solved my problem.

kbatta SSCrazy Points: 2274 More actions · Answer 7

kbatta

SSCrazy

Points: 2274

July 8, 2008 at 4:13 pm

#839809

Thanks! I will give it a try.