Best SQL Server 2008 R2 implementation

Hello,

i am going to install a new SQL Server 2008 R2 Standard, but i don´t know what is the best implementation for this. Our first option is install on a Windows 2008 R2 Standard virtualized over VMware, but we have free phsysical servers to install.

My questions are:

* Install over Physical server or virtualized server (vcpu, vram) ?
* What are the best disk RAD/partition for installation?

Thanks in advance!
LVL 8
fundacionrtsAdministrador de SistemasAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

darasunilCommented:
Hi,

1. If load on your server is not very high than go for virtualized environment.
2. Raid 10 for TL and Raid 5 for Database ( if you can afford go for Raid 10 for both)
borkiCommented:
It depends:

The benefits of virtualisation typically outweigh the advantage of a dedicated physical host. However, if your VM Host server is already fully loaded you may consider putting it on a the spare physical server, but make the spare physical machine another VM host server using a free hypervisor such as ESXi 5 or Hyper-V server, then put the OS and SQL server in a VM.

What is the load for your SQL server, eg. user, database size? your CPU and RAM configuration really depend on this.

Depending on number of disks available, I prefer RAID 10 then RAID 5 then RAID 1. For SQL I typically use only 2 vdisks, one for OS and related software and 1 for the database files. If you run a high load, you want a separate vdisk for the transaction logs. Of course you should make sure that the vdisks are on separate spindles and that disks are 15k drives, preferably SAS 6.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
RAID 10 is best.

Here are the best practice documents for SQL on VMware

Best Practices for SQL Server
http://communities.vmware.com/docs/DOC-8964

It depends on the specification and requirements for your SQL server, size of database, number of connections, number of users.

Why would you want to virtualise it, if it's only one server, are you going to virtualise more servers in the future?

What is the Server you have, CPUs and Memory?

Is the server on the HCL?

Check the VMware HCL (Hardware Compatability Lists) here

http://www.vmware.com/go/hcl
fundacionrtsAdministrador de SistemasAuthor Commented:
The license we have is SQL Server 2008 Standard, and the primary use of the installation is database for Microsoft Dynamics NAV 5.0. Our current database size is aprox. 8 GB (in a dynamics database file format). The aximun number of users that can access MS NAV is 55.
darasunilCommented:
go for VM..
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.