SQL Server 2008 R2 on WIndows Server 2008 R2 standard

Question

 Hi,

 Can any one please advise for the below .

 1. What are the limitations having SQL Server 2008  R2 (X64 bit) installed on Windows Server 2008 R2  'standard'  ? .

 2.  What are the limitations having SQL Server 2008  R2 ( X32 bit)  installed on Windows Server 2008 R2  'standard'  ? .

 I want to know will it affect any kind of replication,AWE or any other regular / performance factors. 

 We wanted to install two instances on the same box  one is for Dev and other is for UAT . Will it be okay ?.  I'm just concerning that even for Development  it may not be feasible but System analyst said it is what he has right now. 

 I also learnt that  on Windows server 2008 R2 standard supports only up to 32 bit . is it correct ?.  My machine is configured with 64 GB. 

 This is is for my develpment environment. Anyways we'll fo with all enterprise verisons for Production.

 Please advise if you have an idea.

 Thanks much..

Reg,

Vish.

Answer 1

Vish,

Answers to your first 2 questions are here - http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx

Your 3rd question - will it affect any kind of replication,AWE or any other regular / performance factors - i am not sure i understand the question, could you please add some more clarification ? 

Technically, installing multiple instances of SQL server on the same box is not a problem, so long as you have sufficient resources (mainly memory). You will however need to monitor it closely to keep on top of performance issues , if any arise as well as monitor space

windows server 2008 r2 standard edition supports 64 bit as well , however, the limit on memory is 32 GB - http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx#physical_memory_limits_windows_server_2008_r2

Hope this helps !

---

Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer. http://sqlwithsanil.com

Answer 2

Hi check this for the reference, it may help you.

http://aws.typepad.com/aws/2011/03/now-available-windows-2008-r2-on-amazon-ec2.html