Reindex Maintenance Plan starts with 15hours delay

Hey there,

on a SS2005 Build 3152 i've scheduled a mp with reindexing a 120 GB db. The mp is scheduled to start every sunday at 08.00am.

In the agents history log i can see that it start its job at 8.00am, but the first reindex starts at 11:xxpm. In the mp history log i can see that it starts at 11:xx pm.

Why do I have such a big delay? Is the job waiting because of some locks, or does the job have to check some things before reindexing? But 15 hours? Is it a bug in mp?

Any ideas?

Thanks in advance
tobiasHi,

does nobody have an idea?

regards
tobias
|||

I would like to know what options you have selected on the MP when you have scheduled this job. Also I would ask whether you have applied SP2 for SQL.

120GB database I would expect it will take some time to finish the maintenance tasks and also check what other processes are running.

|||SP2 and http://support.microsoft.com/kb/933097/en-us are applied.

Other jobs are regular transaction-protocol-backups. The workload on sundays is very low, just a view automatic tasks write to the db.

The MP has to tasks.

1. Reindex
o Connection: Local Server
o Databasese: The ERP Database
o Objects: Table & Views
o Selection:
o % Freespace per Page: 10%
o Sort in TempDB: No
o Index Online: No

2. History Cleanup
o cleans everything older than 4 Month

Regressor Flag

I am trying to build a decision tree algorithm with multiple regressors. I am having trouble changing the properties for the input variables to regressors (the only multiple flag choice is "not null"). I created a mining model using the DMX query thinking I could change the code to include multiple regressors, however I get a syntax error when trying to execute the model. Also, I am wondering if you can view the dmx code for a model built using the mining wizard.

My query is as follows:

CREATE MINING MODEL BVRSlotq1052

(Machine Long Key,

[Banksize] LONG CONTINUOUS REGRESSOR ,

[Cabinet] Text Discrete,

[CUID] Long Continuous PREDICT_ONLY,

[Denom] Text Discrete,

[Gametype] Text Discrete,

[Max Coins] Text Discrete,

[Par] Long Continuous,

[Pos] Text Discrete,

[Progressive] Text Discrete,

[Type]Text Discrete)

Using Microsoft_Decision_Trees

You need to change the one line to

[Banksize] LONG REGRESSOR CONTINUOUS ,

That is, putting REGRESSOR before CONTINUOUS.

The following tip shows a sproc for generating a CREATE MINING MODEL statement from a server model
http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3352.aspx

This tip shows a sproc for generating CREATE MINING STRUCTURE and ALTER statements for server structures
http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3652.aspx

|||thanks!