Never mind found the resolution. Here is a KB article that zoned me into the problem. Client is currently on SP1 but latest service pack out is SP3...

fyi user account 'NA\MajService' is a domain account and has admin rights on sql and local box.

yes I believe it's on a SAN (IT guy is on vacation). This happens when we restart the service only and not the server.

So what was your...

Thanks George, I ran dbcc checkdb turned out fine. Funny thing though is it forced me to turn the db into single user mode which I thought was odd...

sorry for the confusion. i meant multiple .ndf files NOT .ldf huge difference. =)

ok i think here is an article that helped clear things up. Read the "Transaction Log Architecture" section. Basically, the trans log is a endless circle and the...

Oh interesting that would explain it! This client does have their own trans log backup system and one of my concerns was that they had hourly trans log back...

Thanks all for the information much appreciated. Yes, this will occur every hr for 24hrs. The select of 200,000 was not using the indexs properly so it took...

Harish, you the man i could kiss you! thank you so much worked like a charm i just added the "isnull()" function to the second "select" statement below to...

I got it. Here is the new sproc i created to test with. Below the sproc i have pasted the PL/SQL block of code that is saved when...

Thanks for the link much apprecaited. I will find if there were any changes thanks.

I was affraid you would say that. I only looked at he cpu, i/o and memory of the Oracle server. I unfortunately am not a Oracle dba. ...

Satish thanks a million it looks like exactly the problem we are having! We are going to first try and re-initialize it, because the stopping of the sql service...

awesome thank you everybody! soon as i posted this i found it online. central management servers did the trick! awesome stuff!

THank you so much for leading me in the right direction Chris! I have modified your script to run against all db's and return the necessary information...the query is...