Thanks Guys. These are all good ideas if you have another server to restore to.

Gail thank you again for you help!

Thank you very much! 🙂

Thanks. I was also trying to confirm that I understood what he said. I guess I did. Thanks again.

🙂

Hey Jeffrey,

So what you are saying is that I should set:

16Gig instance:

min=14336

max=16384

8Gig instance:

min=6044

max=8192

I failed to mention that the instances are 64bit Enterprise Edition.

The server has 64Gig installed.

Did you ever find out? I right where you are asking the same question.

Thanks for your reply. Your links are for SQL 2000/2005. It's different with SQL 2008 R2.

What is stored on the LUN?

How big do you make the LUN for msdtc? Do you know if it required or recommended to be setup? I'm getting the impression it is recommended to...

Okay. I will run that SQL. Looking up what a VLF is right now. I don't recall that in any of my reading at the moment

You all are the best. Most appreciated those you replied. I will implement what you have suggested.

Thanks that is sort of what I am finding. I found this blog that says that. If you want to use the above sql you have to update...

That doesn't tell me if it is licensed per cpu or by cals.

Thanks for that note. I read your post and also your experience. I'm going to read up on the 2005 to 2008 procedure.

I'm waiting to find...