I would increase the time you take a log backup to let's say every 30 mins. And as Scott said, you should set the tLogs to grow in MB as...

Hi Jared,

Thanks for taking a look. We currently partition the table because the database is extremely large (4tb) and in order for it to have better performance we purge...

That is exactly what I was thinking Lynn. I am reviewing the process and for my developers I always ask for other opinions so they don't think I shoot...

Thanks guys, Here is some more info:

Step 1 marspurgeforQA runs procedure exec p_maint_usp_MarsPurgeForQA

This step took 12 hrs 50 mins the last time it ran

Step 2 rebuild indexes and update statistics

This step took...

Broke this up -- So after creating a temp table (as opposed to @table) I wrot the first portion like this:

Select init.loannum,

init.submitdate,...

ALZDBA,

Thanks I have cleaned up the brackets (good grief) and you betcha we a have an open rec for a senior level dba developer... (whew)

I appreciate the advice, I think...

Journeyman & Grasshopper, Thanks awesome tips...

For the life of me, there are several things I see glaring as well, the first was the variable table vs the temp table.

I...

MegaDBA,

I don't understand your response. If you don't want honest feedback then you shouldn't plop down hundreds of lines of code and ask for feedback. -Dude no one comes...

Hey thanks,

I did change the variable to a temp table...and I recompiled, this gave us immediate gratification and then it started hanging again...

i will implement the other hints...remove that "like"...

Thanks Grant, and I did take your comment with humor, I mean believe me, I know that code is a mess, lol

I think what Joe points out is just what...

Wow guys you were super critical here...We bought a company, and yes they had legacy code and ill if any at all standards...That being said, we are trying to fix...

Not asking for you to rewrite and I am sure i did not pose my question that way...

To those of you who have been most understanding and helpful, thank you....

Thanks everyone, I know it stinks, believe me I am all over the dev regarding it, but I'm not to hard on him because its a legacy piece of code...

So i think i have a cluster set up on each node..

Node A-- i have a BAM instance (manual)

Node B --I have MSGBOX. (manual)

...But how is that active/active...I...

OK, I was able to run repair, then successufully remove the node...So I am back at stage one. Thanks for all your assistance...I'm sure I'll be back.:-D