September 24, 2009 at 10:09 pm
Question 1 - Disk, Raid Groups and File Group layout:
---------------------------------------------------
Environment:
SQL Server 2005.
Developing new enterprise web application
We have 3 San Disks.
One application working against this db
Standard edition
Is it beneficial to have 6 filegroups or just 3 is good enough.
Here is the plan. Is it making sense. Please advice.
---------------------------------------------------
Tables Data_FG J:/Data RAID 10
History tables History_FG J:/History RAID 10
Primary (System tables) Primary_FG J:/Primary RAID 10
Images & Text columns Image_FG N:/Images RAID 10
(need to be in DB)
Indexes Index_FG N:/Indexes RAID 10
Log Log_FG L:/Logs RAID 1
Question 2 - Cluster:
--------------------
Also we have one web application and SQL Server 2005 Standard Edition. Since Cluster cannot provide any load balancing, I think Single-Instance 2 Node Active-Passive cluster is all what I need. Let me know if setting cluster any differently can be beneficial or advisable.
ANy benefit of using Active-Active (will need atleast 2 licenses)
Any Benefit of Multi Instance (Have only one application working against this db)
Any Benefit of using more than 2 nodes (even if I can move Standard edition to enterprise)
Topic Next Topic
September 25, 2009 at 2:21 am
Refer following link for Physical design of DB.
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/PhysDBStor.doc
If you do have only one application with one sql instance Active - Active will not be possible. You can go with Active - Passive.
Also consider DB size, future growth, Transactions etc. while designing.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 25, 2009 at 8:54 am
I tried to put all details and wanted to confirm with experts..
September 26, 2009 at 10:39 am
Q. So Is Active Active awlays beneficial even if there is only single application and single cluster db.
Q. Isn't Single instance 2 node cluster is as good as 2 instance 2 node cluster and will give same performance for single application.
Q. Is it good idea to put on same file group & disk but diff folder
Tables, History Tables (Data Auditing) , System tables
Q. Is it good idea to put on same file group & disk but diff folder
Image Data andText Data , Indexes
Q. Is it good idea to put Logs on seperate file group on Raid 1
September 28, 2009 at 4:56 pm
Any replies??
September 29, 2009 at 7:28 am
My reply is that you should hire an expert to assist you with this matter. There are MANY things you need to do right to get optimal and reliable setup of this system, and you have touched just the tip of the proverbial iceberg. There is some missing information too such as the underlying configuration of the 3 SAN drives. Can't advise how to carve those up without knowing things like how many spindles are in each LUN. I would also recommend (and a consultant would help you perform) IO testing to see what configuration is optimal - SQLIO is the tool to use here.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 29, 2009 at 8:08 am
dinky (9/28/2009)
Any replies??
To be honest, you have way too many questions on the configuration that you are after and as mentioned you are missing some fundamental questions that should be asked. You would be better off having someone on site, as any replies to your questions will just cause more questions.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 29, 2009 at 8:37 am
I'd add a third note that you need to get a consultant on site to help you understand this. Your questions indicate that you don't really understand what you are dealing with, and it would be easy for you to make big mistakes by relying on a little advice here from these forums.
I would recommend you read up on clustering to understand how it works and what it intent is. Your questions show that you haven't worked with this enough. Not a big deal, but trying to learn here for a production system is a bad idea.
It isn't as simple as telling you that a is a good or bad idea. What you need is to better analyze your system and understand how it's used before you make decisions. That's a substantial amount of work and your company should pay someone to help you learn more about this.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply