Answered by:
CRM 2011 - SQL 2008 Enterprise or Standard

Question
-
Is there any advantage between running SQL 2008 standard and SQL 2008 enterprise as far as CRM is concerned?
Regards, BillThursday, March 31, 2011 3:06 PM
Answers
-
Shouldn't matter, according to the implementation guide you can use either, but only 64 bit.
SQL Server editions
Any one of the following Microsoft SQL Server editions is required and must be installed on a Windows Server 2008 64-bit or later version, running, and available for Microsoft Dynamics CRM:
- Microsoft SQL Server 2008, Standard Edition, x64 SP1 or later version
- Microsoft SQL Server 2008, Enterprise Edition, x64 SP1 or later version
- Microsoft SQL Server 2008 Datacenter x64 SP1 or later version
- Microsoft SQL Server 2008 Developer x64 SP1 or later version (for non-production environments only)
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 3:58 PM
Thursday, March 31, 2011 3:25 PMModerator -
As far as I know, the only difference that has an effect in CRM is that CRM will partition the audit tables if it's installed on SQL Enterprise; this is for performance reasons, and this functionality is only available with SQL Enterprise
Microsoft CRM MVP - http://mscrmuk.blogspot.com http://www.excitation.co.uk- Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 3:58 PM
Thursday, March 31, 2011 6:24 PMModerator -
Here is a comparison,
http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx
The PDF at the bottom of the screen goes intomore depth also.
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 3:58 PM
Thursday, March 31, 2011 6:25 PMModerator
All replies
-
Shouldn't matter, according to the implementation guide you can use either, but only 64 bit.
SQL Server editions
Any one of the following Microsoft SQL Server editions is required and must be installed on a Windows Server 2008 64-bit or later version, running, and available for Microsoft Dynamics CRM:
- Microsoft SQL Server 2008, Standard Edition, x64 SP1 or later version
- Microsoft SQL Server 2008, Enterprise Edition, x64 SP1 or later version
- Microsoft SQL Server 2008 Datacenter x64 SP1 or later version
- Microsoft SQL Server 2008 Developer x64 SP1 or later version (for non-production environments only)
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 3:58 PM
Thursday, March 31, 2011 3:25 PMModerator -
Thanks. Not being a SQL guy, I am wondering what are the differences between standard and enterprise?
Regards, BillThursday, March 31, 2011 3:33 PM -
As far as I know, the only difference that has an effect in CRM is that CRM will partition the audit tables if it's installed on SQL Enterprise; this is for performance reasons, and this functionality is only available with SQL Enterprise
Microsoft CRM MVP - http://mscrmuk.blogspot.com http://www.excitation.co.uk- Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 3:58 PM
Thursday, March 31, 2011 6:24 PMModerator -
Here is a comparison,
http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx
The PDF at the bottom of the screen goes intomore depth also.
Jamie Miley
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
- Marked as answer by Jamie MileyModerator Tuesday, February 14, 2012 3:58 PM
Thursday, March 31, 2011 6:25 PMModerator -
Thanks David. Are you referring to the case where CRM and SQL are installed on the same box?
Regards, BillThursday, March 31, 2011 6:58 PM -
Bill, it makes no difference if CRM and SQL are on the same box, or different ones
Microsoft CRM MVP - http://mscrmuk.blogspot.com http://www.excitation.co.uk- Proposed as answer by Jamie MileyModerator Friday, April 1, 2011 9:47 PM
Thursday, March 31, 2011 8:51 PMModerator