Solved

Configuration of servers for sql server

Posted on 2010-11-27
4
357 Views
Last Modified: 2012-05-10
We currently have a SAN with a combination of SATA drives and fast fibre channel disks.  We have 4 host 2950 servers as hosts for virtual servers using vmware.

Our SQL servers are having performance issues and i wondered how people would configure their SQL servers.  We have a combination of heavy read and heavy write databases.

I have read you should not virtualize your SQL servers and other documents that you should.

What configuration should I use and should they be virtual or physical (my boss has decided that RAID 10 is not needed and RAID 5 is adequate because we are only a college)
0
Comment
Question by:WNottsC
[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
4 Comments
 
LVL 47

Expert Comment

by:dlethe
ID: 34224374
Well, since your knucklehead boss thinks  you are only a college so you don't need performance, then you should start by minimizing the amount of I/O you perform.

Since SQL Server does 64KB I/Os, you better make sure your RAID is configured for optimum IOPs using 64KB I/O size. Chances are that it is not.

You should really be using RAID1 for I/O intensive, and write intensive things like journals, temporary/scratch data space and log files.  Perhaps your boss will let you do that.  If not, maybe buy a small SSD?  For a few hundred bucks you can get a SSD that can maintain 20-30,000 RANDOM I/Os per second.   Use that for scratch table space and your performance problems may be a thing of the past.
0
 
LVL 7

Expert Comment

by:OxygenITSolutions
ID: 34224406
I would install Windows on two of the servers and cluster them. I have always found SQL performs better when installed Natively than when installed as virtual servers. You can use VMWare for your test/DR environment on the other servers.
0
 

Author Comment

by:WNottsC
ID: 34225002
at the moment I have no control over the way the SAN is configured.  It has two Raid 5 volumes one I am using for data and one I am using for logs with the temp and OS going on a raid 1 drive.

I have been looking at some of the dell MD3200 storage devices with 2 or 3 servers in a cluster at the front end.  Can anyone give any suggestions as to configuration or alternatives.

My company do not want to spend alot, see RAID 5 being ok,  but we are getting speed issues with some of our database applications and time outs
0
 
LVL 55

Accepted Solution

by:
andyalder earned 500 total points
ID: 34225187
RAID 5 is cheaper?

Let's assume you get 200 IOPS per disk (that's a little high but sums are easier):-

10 disks in RAID gives 1800 IOPS read or 500 IOPS write, average 1150 assuming 50:50
10 disks in RAID 10 gives 2000 IOPS read or 1000 IOPS write, average 1500 assuming 50:50

So for the same price you can get 1150 IOPS with RAID 5 or 1500 IOPS with RAID 10, in other words as far as speed is concerned RAID 10 is cheaper. dmittedly these are classroom sums but real world experience is similar.

As far as SAN Vs DAS you get more bang per buck with DAS, you can't cluster DAS but if you want high availability then you can use log shipping which is built into SQL anyway.

 Bear in mind that you can get away with slow SATA disks for transaction logs as long as they are dedicated, they're pretty good at sequential access, just pants for random access.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration, of the HP EVA 4400 SAN Storage. The name , IP and the WWN ID’s used here are not the real ones. ABOUT THE STORAGE For most of you reading this, you …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 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