I just got off a meeting where I found out that this is a licensing issue. Windows does not see the extra 4 cpus because of the way they licensed...

It's Windows Server 2008 R2 Enterprise. SQL Server is 2008. You are right, windows can only see 8 processors. That's the same number SQL can see. I assume they ere...

That's what I thought but why I only see 8 cpus? Does anything need to be done to SQL Server when cpus are added? I thought it recognized them automatically.

Thanks

Thank God it worked! I had serious doubts about the procedure but Microsoft reviewed it and insisted it was the only solution. Down time was just 20 minutes. Developers were...

I understand that and that is why I resisted pressure from the application manager to reboot the server but Microsoft stepped in and, after long hours yesterday, has recommended that...

I ended up calling Microsoft and their DBA made a very interesting discovery: the transactions were not really rolling back. They were orphans but had references to the calling server,...

I just had another wild thought. I know it's been a bad day probably not the best for ideas. :hehe: What if I change the databases to simple recovery mode...

That's what I was afraid you were going to say. 🙂 And what I suspected. It only took about 4 minutes more to restore but then there has been some...

Yes but this one has been running since yesterday. I just thought of something that I don't know if it would work or not but I am sure you would...

Running sp_WhoIsActive does not show waits for either of the rollback sessions. Is there anything else I can check?

Thanks

I'll try the second one first. The first one would get me more grief. 🙂

Thanks

That's what I was afraid. Developers and their managers will panic but... it is what it is and it is what I expected but, is there a way to speed...

One thing I thought I should add, both servers, the one having this issues and the other one where the processes worked, received recently a new array to accomodate the...

Thanks but I have already run DBCC CHECKDB and there were no errors found.

The account is the server administrator.

Thanks