August 19, 2008 at 9:51 am
Hello Room,
I read the “Should you buy a SAN?” article by Andy Warren posted 2003/03/28.
Can anyone advise on the training classes?
I ‘m Dallas, Texas.
Thanks,
Edwin
August 19, 2008 at 9:59 am
which vendor do you plan on using?
your chosen vendor will supply any training you may need
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 10:35 am
Dell
What kind of specific training the vendor will provide?
What kind of training should I ask?
Please advice on this?
Thanks a lot for your kind help.
Edwin
August 19, 2008 at 11:58 am
Edwin (8/19/2008)
DellWhat kind of specific training the vendor will provide?
dunno, contact them and find out
Edwin (8/19/2008)
What kind of training should I ask?
how much do you think you need?
what do you know already about SAN's
you should really be speaking to your vendor 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 1:06 pm
Perry,
I ‘m a newbie on Storage Area Networks. I need to pick it up a lot and I only read some SAN articles on this forum.
We are planning to implement Storage Area Network and SQL Server Database.
The physical hardware:
Server
Dell Poweredge R900, 2X Quad Core E7310 Xeon, 1.66GHZ.
Storage
•Dell EquallLogic PS5000E with 8TB capacity,
•16 x 500GB, 7.2KSATA,
•Dual Controller (341-6478)
The architecture:
Server
^
|
V
Fibre Channel Switch
^
|
V
Storage
I have many questions:
1.What is the best RAID configuration on this environment?
2.Once the RAID configured. How to configure the SQL Server installation?
a.E.g.: SQL Data file installed in Disk??
b.SQL Log file install in Disk?
3.What is the minimum SQL data files need to be created?
4.How to configure the PAE and AWE to optimize this environment?
5.We are planning to install Window Server 2003 Enterprise and SQL Server 2005 Standard
edition. Any advise on this?
August 19, 2008 at 4:30 pm
Edwin,
Based on your architectural diagram you won't need the Fibre Channel Switch. The SAN you listed is an iSCSI solution so you only need Gigabit switched ethernet.
Also, you might want to check the options for training offered through Dell and/or EqualLogic on that. Or, just contact them since they have probably tested many configurations and could give you some insight and recommendations.
http://www.dell.com/content/topics/global.aspx/services/tnc/dell_equallogic?c=us&cs=555&l=en&s=biz
August 19, 2008 at 5:09 pm
One of the most specs for SAN is Disk speed.
you get SAN with 16 x 500GB, 7.2KSATA
For OLTP , it is preferred to use SAS with 15K RPM (or 10K ) , with disk of small size capacity e.g 300 GB/160 GB
LUNs:
LUN for data RAID 10 (or RAID 5)
LUN for log (RAID 10 best or RAID 1)
LUN for tempdb (RAID 10 best or RAID 1)
LUN for temprary backup (RAID 0 )
every LUN is separate disks. Don't share disks with more than one LUN
The Most Important is Aligning SAN, so: block size 64 K, stripsize 256 k
August 20, 2008 at 6:45 am
Edwin (8/19/2008)
Perry,I ‘m a newbie on Storage Area Networks. I need to pick it up a lot and I only read some SAN articles on this forum.
We are planning to implement Storage Area Network and SQL Server Database.
The physical hardware:
Server
Dell Poweredge R900, 2X Quad Core E7310 Xeon, 1.66GHZ.
Storage
•Dell EquallLogic PS5000E with 8TB capacity,
•16 x 500GB, 7.2KSATA,
•Dual Controller (341-6478)
The architecture:
Server
^
|
V
Fibre Channel Switch
^
|
V
Storage
I have many questions:
1.What is the best RAID configuration on this environment?
2.Once the RAID configured. How to configure the SQL Server installation?
a.E.g.: SQL Data file installed in Disk??
b.SQL Log file install in Disk?
3.What is the minimum SQL data files need to be created?
4.How to configure the PAE and AWE to optimize this environment?
5.We are planning to install Window Server 2003 Enterprise and SQL Server 2005 Standard
edition. Any advise on this?
to follow on from the other guys, for Windows 2003 Ent you dont need to worry about /PAE switch. How much RAM do you intend to put in the server? Have you considered 64 bit windows\sql server?
RAID 10 offers the best but at disk cost, RAID 5 for sql data files and RAID 1 for logs and RAID 1 for NOS is fine. How much storage i\o do you anticipate, if its going to be heavy then RAID 10 is your best option?
AWE on 32 bit requires you set the min and max instance memory properly, this is based on how much RAM you have and how many sql instances. Also you'll need to set the "Lock pages in memory" local security policy for the user account the sql services run as
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2008 at 1:16 pm
Thanks to Todd, Moh and Perry help and advice.
Hi Todd,
Thanks for the Dell links.
I contacted the Dell Sales person and asked about the SAN training classes. He informed me that I did not need Dell SAN EqualLogic training classes . I disappointed and did not agree with him.
Hi Moh,
Can you send me some sample or white paper how to setup from starch/begin until completed?
My email: tjedwin@gmail.com
Hi Perry,
We are planning to put in 32 GB RAM with Window Server 2003 Enterprise 32-bits edition.
Yes, I am considering the Window Server 2003 Enterprise 64-bits edition.
The databases size are 100++ GB average size.
Where can I find the AWE Switch in O/S?
I am planning to have 20 SQL Server instances.
Where can I find and set the “Lock pages in memory”?
Can you advice on SQL Server 2005 Standard or Enterprise in my case?
Thanks,
Edwin
August 20, 2008 at 2:29 pm
Hi Perry,
How to add the AWE on 32 bits in boot.ini.
For example:
boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect
Thanks,
Edwin
August 21, 2008 at 4:29 am
Edwin (8/20/2008)
Hi Perry,
We are planning to put in 32 GB RAM with Window Server 2003 Enterprise 32-bits edition.
Yes, I am considering the Window Server 2003 Enterprise 64-bits edition.
The databases size are 100++ GB average size.
Where can I find the AWE Switch in O/S?
I am planning to have 20 SQL Server instances.
Where can I find and set the “Lock pages in memory”?
Can you advice on SQL Server 2005 Standard or Enterprise in my case?
Thanks,
Edwin
AWE is enabled at application level (per sql instance) inside SQL server
Why so many sql instances?
Lock pages in memory is a local seurity policy under administrative tools
Depends on what you require but sql 2005 std may do what you need. Check the MS website for the sql2005 features comparison to see what edition you require
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2008 at 2:17 pm
Perry,
The plan is 20 instances. My advice is 2 instances.
I checked with SQL Training books indicated that both SQL Server 2005 std and enterprise can take advantage of the maximum memory supported by the host operating systems.
In my scenario, I have 8TB with 16 drives.
What is the best practice database configuration for RAID 10? Would you please give me some hint and a sample layout.
Regards,
Edwin
August 21, 2008 at 4:09 pm
theres no point in RAID 10 for the OS thats just a waste of disks (these would be local disks anyway presumably).
Use RAID 1 for OS
all depends on how the disk trays are configured on the SAN.
RAID 10 LUN for the sql data files
RAID 10 LUN for SQL logs
also for better performance split out the Tempdb to a separate RAID 10 LUN.
as i said it all depends on how many disks you have to play with in the first place and what your SAN can support. Disk storage for SQL server has many different configs depending on the amount\type of disks you have available. Bear in mind each server connecting to the SAN will need at least 2 HBA's each (multi homing) for load balancing\redundancy.
Remember, RAID 10 offers best performance but the disk cost is higher
8TB and 16 disks! Hmm, smaller disks and more trays would be better but cost is obviously higher. Disks should be striped\mirrored across trays to provide better fault tolerance. SAN's are not cheap but the performance and fault tolerance is unbeatable. How important is your data???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply