Orion 9.5 Database Maintenance

Have you opened a support ticket to investigate?

Not yet, I installed the upgrade Sunday afternoon so we had this issue early Monday AM and now this morning.  I just narrowed it down to DB Maint being the issue a few minutes ago.  I posted here first to see if anyone else had seen it in 9.5.  My next step is support.

The maintenance is hanging on summarizion data from Response Time.  My overnight employee tells me it had been on that section since 4 AM and I shut it down at 8 AM and it was still there.

Opened case 98037 regarding this issue.  I will follow up here when I have a fix so others can apply if they have the same issue.

I am having the same issue.  About an hour into database maintenance a process starts blocking and crushes the server.  I killed the process being blocked and the job is continuing to run.  Please post their solution when you have it.

There are a few procedures used in the Database Maintenance that are limited to 100 rows.  If it has a large number of rows to delete it has to loop over and over again.  This is what is slowing down the process.

Simple increases of that limit will speed up the process greatly.  I will have to look it back up all the ones that I found but one of them was "dbm_InterfaceErrors_DeleteStale".  (There were one or two others that have that same limit.)  After that limit was increased the Database Maintenance finished without issue for me.

I am having the same issue.  About an hour into database maintenance a process starts blocking and crushes the server.  I killed the process being blocked and the job is continuing to run.  Please post their solution when you have it.

I have recieved some requests from support to gather some data which I will work on tomorrow.  I would hope you would also open a ticket so they can see your logs to help determine if it is something in the build.

We are having the same issue.  We originally thoght is was the 2G limit of SQL 2005.  We increased the limit to 6G and not the CPU bets maxed out when the database maintenance starts.  The process never dies until we restart the SQL server.  I have opened a case and provided the diagnostics and the SQL deadlock trace.  I hope there is an answer soon as this is causing impacting our ability to monitor our network.

Is there a way to disable the DB maintenance for now?

There is a variable "@chunksize = 100" in the stored procedures that the DB maintenance uses this set a limit of 100 records per loop.  If you have a large amount of records to proces then this will take forever.

I ended up changing 3 of them to 100,000. (dbm_ResponseTime_DeleteStale dbm_InterfaceTraffic_DeleteStale dbm_InterfaceErrors_DeleteStale) After the change the first time the DB maintenance ran it took a few hour to complete but after that it now runs and completes in a reasonable amount of time

You may need to change more of the stored procedures depending of the size of your database but it seems any table over 400 MB will take a large amount of time to complete with the 100 row limit set.

Is this due to a change in 9.5?  never had this issue until we upgraded last week. 

Where are you making these changes?