SQL Server Performance Forum – Threads Archive
146GB vs. 72GB Sustained read speeds
I’m looking to purchase a new HP ML370 G5, with the external MSA50 enclosure. I’m debating between the 72GB and 146GB 2.5" 10,000 RPM drives. The 72s provide adequate storage, but I’d like the know if the 146s have a higher sustained read speed. I thought they had twice as many platters, which would indicate they could sustain double the read speed. Are my assumptions way off? Thanks.How about database growth?
How about accessibility on Application, any highs or lows?
Is database design optimized to serve the resource intensive queries? http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=16995 fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Our database is about 80GB and grows a GB or less per month. A 10 drive RAID 10 array will give me 360GB (using 72s), which is plenty. So 146s are way overkill. But, if they were able to sustain higher sequential read IO then it might be worth the extra $1100 per cage. I’m mainly trying to serve the large reporting queries that come through a few times per hour. The rest of the time the CPU and disks sit idle.
drive capacity and performance completely separate topics
there is no substitute for multiple IO adapters/channels and disk drives
preferable 60+ drives for a good 2 socket system for any given disk drive generation & speed,
capacity differences: ie, 73 & 146 GB
are creates with platters inside the disk drive
so the 73G has 1 platter, the 146 has 2 there are no differences in performance characteristics
Joe, Thank you very much! I’m glad to know capacity does not dictate the speed. I’m going to purchase an ML370 G5
1 x 2.66 Quad core chip
8GB Ram
P400 /512 for 8 internal drives (OS, Backup, Log)
E500 /256 for MSA 50 with 10, 72GB 10k drives. RAID 10 for data
Maybe a 2nd MSA 50 for the other port on the E500, same as above. Is this a problem with regards to card/bus saturation. Does anything above seem out of alignment? Too much DISK IO, too much CPU, too little RAM, etc. Our DB is 80GB. Very little concurrency. Mostly for 20 people that generate a few reports per day. Thanks for your expertise.
you might consider something like:
2 drives for OS, 2 for logs in the first internal 8-bay
8 drives for data in second internal bay, 8-10 drives in MSA 50 for data
or a second MSA 50 in lieu of the 8 internal drives
or 8 internal + 2 MSA50 no reason not get 3+ controllers, they are realatively inexpensive compared to the storage chassis + disks I prefer to carve the data drive/arrays into 3 partitions
1. for data files
2. for tempdb data
3. for backup also, consider buying the second 2.66GHz proc anyways,
even if your initial license is for 1 SQL Server socket
then if you decide you need more power, the processor is already there
Howabout going for the 15k rpm disks in the server?
Hi JO, If we have 8 cores, do we need to have 8 temp data files. if so how do we place?
according to MS, if your app makes extensive use of temp tables, or other use of the tempdb, which could be queries with worktable, ie, hash, sort, and other intermediate results it could generate a lot of writes to the tempdb system tables
in which case, multiple tempdb data files are preferred however, it was never clearly explained as to whether it actually helps to create multiple files to the same disks so, if you configured your system for adequate storage performance,
ie, 2-4 controllers, 2-4 racks of external storage
you will probably have 4-8 arrays any ways.
in which, place one tempdb data file on each array, same with data
]]>