Sql server hardware recommendations - Revision history

Trevor at 02:12, 13 September 2011

2011-09-13T02:12:29Z

← Older revision		Revision as of 02:12, 13 September 2011
Line 13:		Line 13:

	• SQL Server 2008 R2 standard edition x64 "per-processor licence model"		• SQL Server 2008 R2 standard edition x64 "per-processor licence model"


	Server Hardware:		Server Hardware:

	• Single, quad-core Intel processor		• Single, quad-core Intel processor

	• Minimum 16GB RAM, recommend 32GB		• Minimum 16GB RAM, recommend 32GB

	• Disk system is very important, ideally separate volumes:		• Disk system is very important, ideally separate volumes:

	o RAID 1 volume for O/S and applications		o RAID 1 volume for O/S and applications

	o RAID 1 volume for SQL server transaction log		o RAID 1 volume for SQL server transaction log

	o RAID 10 volume for SQL data (could be RAID 5 to reduce cost slightly)		o RAID 10 volume for SQL data (could be RAID 5 to reduce cost slightly)

	o Somewhere to store backups short-term before they are moved to separate media		o Somewhere to store backups short-term before they are moved to separate media


	''Note - you must purchase SQL Server licensed to be accessed by all your HO users AND allow a licence for every till in every store - AND accessed in real time by the web site if applicable. This is why you must buy a per-processor licence - and this why you should have a single, multi-core CPU (only need to buy one processor licence this way).''See Also:		''Note - you must purchase SQL Server licensed to be accessed by all your HO users AND allow a licence for every till in every store - AND accessed in real time by the web site if applicable. This is why you must buy a per-processor licence - and this why you should have a single, multi-core CPU (only need to buy one processor licence this way).''See Also:

Trevor at 02:11, 13 September 2011

2011-09-13T02:11:43Z

← Older revision		Revision as of 02:11, 13 September 2011
Line 11:		Line 11:

	• Windows Server 2008 R2 standard edition x64 - licence type to be recommended by your Microsoft licensing specialist		• Windows Server 2008 R2 standard edition x64 - licence type to be recommended by your Microsoft licensing specialist

	• SQL Server 2008 R2 standard edition x64 "per-processor licence model"		• SQL Server 2008 R2 standard edition x64 "per-processor licence model"

	Server Hardware:		Server Hardware:

	• Single, quad-core Intel processor		• Single, quad-core Intel processor
	• Minimum 16GB RAM, recommend 32GB		• Minimum 16GB RAM, recommend 32GB

Trevor at 02:11, 13 September 2011

2011-09-13T02:11:19Z

← Older revision		Revision as of 02:11, 13 September 2011
Line 9:		Line 9:

	Server Software:		Server Software:

	• Windows Server 2008 R2 standard edition x64 - licence type to be recommended by your Microsoft licensing specialist		• Windows Server 2008 R2 standard edition x64 - licence type to be recommended by your Microsoft licensing specialist
	• SQL Server 2008 R2 standard edition x64 "per-processor licence model"		• SQL Server 2008 R2 standard edition x64 "per-processor licence model"

Trevor at 02:10, 13 September 2011

2011-09-13T02:10:40Z

← Older revision		Revision as of 02:10, 13 September 2011
Line 19:		Line 19:
	o RAID 10 volume for SQL data (could be RAID 5 to reduce cost slightly)		o RAID 10 volume for SQL data (could be RAID 5 to reduce cost slightly)
	o Somewhere to store backups short-term before they are moved to separate media		o Somewhere to store backups short-term before they are moved to separate media

	''Note - you must purchase SQL Server licensed to be accessed by all your HO users AND allow a licence for every till in every store - AND accessed in real time by the web site if applicable. This is why you must buy a per-processor licence - and this why you should have a single, multi-core CPU (only need to buy one processor licence this way).''See Also:		''Note - you must purchase SQL Server licensed to be accessed by all your HO users AND allow a licence for every till in every store - AND accessed in real time by the web site if applicable. This is why you must buy a per-processor licence - and this why you should have a single, multi-core CPU (only need to buy one processor licence this way).''See Also:

Trevor at 02:10, 13 September 2011

2011-09-13T02:10:22Z

← Older revision		Revision as of 02:10, 13 September 2011
Line 3:		Line 3:

	'''General recommendations for SQL Server Hardware'''		'''General recommendations for SQL Server Hardware'''

	When obtaining hardware for a EEE server, the following is a “general” recommendation on how the server should be configured. This is a general recommendation only and your requirements may differ depending on the number of stores you have and the volume of data being retained.		When obtaining hardware for a EEE server, the following is a “general” recommendation on how the server should be configured. This is a general recommendation only and your requirements may differ depending on the number of stores you have and the volume of data being retained.

Trevor: Created page with "Created: 13 September 2011. Last Reviewed: 13 September 2011 '''General recommendations for SQL Server Hardware''' When obtaining hardware for a EEE server, the following is a..."

2011-09-13T02:10:05Z

Created page with "Created: 13 September 2011. Last Reviewed: 13 September 2011 '''General recommendations for SQL Server Hardware''' When obtaining hardware for a EEE server, the following is a..."

New page

Created: 13 September 2011. Last Reviewed: 13 September 2011

'''General recommendations for SQL Server Hardware'''
When obtaining hardware for a EEE server, the following is a “general” recommendation on how the server should be configured. This is a general recommendation only and your requirements may differ depending on the number of stores you have and the volume of data being retained.

Some general recommendations:

Server Software:
• Windows Server 2008 R2 standard edition x64 - licence type to be recommended by your Microsoft licensing specialist
• SQL Server 2008 R2 standard edition x64 "per-processor licence model"
Server Hardware:
• Single, quad-core Intel processor
• Minimum 16GB RAM, recommend 32GB
• Disk system is very important, ideally separate volumes:
o RAID 1 volume for O/S and applications
o RAID 1 volume for SQL server transaction log
o RAID 10 volume for SQL data (could be RAID 5 to reduce cost slightly)
o Somewhere to store backups short-term before they are moved to separate media
''Note - you must purchase SQL Server licensed to be accessed by all your HO users AND allow a licence for every till in every store - AND accessed in real time by the web site if applicable. This is why you must buy a per-processor licence - and this why you should have a single, multi-core CPU (only need to buy one processor licence this way).''See Also: