Solved

Best SQL Server 2008 R2 implementation

Posted on 2012-04-02
6
270 Views
Last Modified: 2012-04-11
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!
0
Comment
Question by:fundacionrts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 3

Assisted Solution

by:darasunil
darasunil earned 125 total points
ID: 37795288
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)
0
 
LVL 9

Accepted Solution

by:
borki earned 250 total points
ID: 37795296
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.
0
 
LVL 10

Expert Comment

by:Bawer
ID: 37795298
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 120

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 125 total points
ID: 37795324
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
0
 
LVL 8

Author Comment

by:fundacionrts
ID: 37824486
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.
0
 
LVL 3

Expert Comment

by:darasunil
ID: 37826371
go for VM..
0

Featured Post

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A procedure for exporting installed hotfix details of remote computers using powershell
When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed." When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question