January 29, 2009 at 12:21 am
Max (1/28/2009)
.... Does anyone still do that or is it all fibre optic SANs.
This is still a best practise.
SANs may help you on reliability, provide means of backup, ease of drive expansion, ..., but there are tons of things that will not perform if you just configure it as a big bucket of raid5 or more.
SAN managers need to understand and configure the options they have to support your typical database characteristics needs.
Maybe when very speedy SSDs are common stuff, we'll get over this.
So, for the moment, yes, you stell have to configure your logical drives and split them physically if you have the option.
Ehm ... and yes .... the biggest gains are to be found in optimising the code and in optimal data usage.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 29, 2009 at 7:38 am
Yip, ssd's are still a wee bit tiny for enterprise databases, was looking into os boot partitions though, at least it'll be a snap to get a server up and running again and reduce statistical downtime :D.
Who's post have we hijacked again...
Max
January 29, 2009 at 8:08 am
:w00t::hehe::D
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 5, 2009 at 9:17 am
ALZDBA, further to SSD's...
There's a white paper here from Texas Memory Sysems if you're keen: http://txmemsys.com/AD-SQLsP-Txt.php. Register and then scroll to the bottom of the page (would attach the pdf but that might be pushing the boundaries on copyright).
Website: http://www.superssd.com/
Disclaimer: Please note that I do not have any affiliation with TMS or it's partners and I do not have any practical experience in the environments they mention here: http://www.superssd.com/products/ramsan/solutions/applications/database.htm, just an academic interest in watching this arena, please don't jump on me ;).
Max
February 6, 2009 at 12:12 am
Thank you Max for the very informative refs.
More reasons for our devs _not_ to do decent db design 😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 6, 2009 at 3:13 am
Well, not all devs are cast in the same forge but if they are and they've got lots of money, I've eseen reports that the 0.5tb goes for btw $275k - $290k, that's just a bit ridiculous.
If you really want to be blown away: http://searchstorage.techtarget.com/news/article/0,289142,sid5_gci1337186,00.html - I think I'm going to have to get another 1.5kw psu (well I can at least afford the psu).
Max
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply