March 14, 2012 at 1:22 pm
TheSQLGuru (3/14/2012)
Gianluca Sartori (3/14/2012)
TheSQLGuru (3/14/2012)
I would really question putting TEMPDB on a RAM disk in this scenario. FusionIO cards take up a LOT of system memory - which is obviously then not available for the SQL Server buffer pool (or any other system executable). Taking even MORE RAM away for a tempdb RAM disk would likely be counter productive.With a system like that, if you are not getting the performance you expect I would LOVE to come and do some consulting for you to find out what is going on!! I will even give you a discounted rate just so I can play on such awesome hardware! 😎
I would even give it for free, if you were in the same continent as me. 🙂
Well, I am pretty darn happy you live across the pond then!! 😛
Ahem... The OP never said where h or she is located...
Jared
CE - Microsoft
March 14, 2012 at 2:36 pm
SQLKnowItAll (3/14/2012)
TheSQLGuru (3/14/2012)
Gianluca Sartori (3/14/2012)
TheSQLGuru (3/14/2012)
I would really question putting TEMPDB on a RAM disk in this scenario. FusionIO cards take up a LOT of system memory - which is obviously then not available for the SQL Server buffer pool (or any other system executable). Taking even MORE RAM away for a tempdb RAM disk would likely be counter productive.With a system like that, if you are not getting the performance you expect I would LOVE to come and do some consulting for you to find out what is going on!! I will even give you a discounted rate just so I can play on such awesome hardware! 😎
I would even give it for free, if you were in the same continent as me. 🙂
Well, I am pretty darn happy you live across the pond then!! 😛
Ahem... The OP never said where h or she is located...
Nope - but I clearly have probability on "my" side! 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 20, 2012 at 4:22 pm
TheSQLGuru (3/14/2012)
............. FusionIO cards take up a LOT of system memory.........l:
I thought that FusionIO cards sat in the PCI slots on the motherboard and were not part of the ram? What have I missed. Just asking as it was an option I was seriously going to look at for a set of servers
March 21, 2012 at 8:15 am
They are not part of RAM but they require a certain amount of RAM to function properly, or so I am told.
CEWII
March 21, 2012 at 9:35 am
Devil's Bloody Advocate (3/20/2012)
TheSQLGuru (3/14/2012)
............. FusionIO cards take up a LOT of system memory.........l:I thought that FusionIO cards sat in the PCI slots on the motherboard and were not part of the ram? What have I missed. Just asking as it was an option I was seriously going to look at for a set of servers
The drivers for the FusionIO cards reserve system memory on boot, and that memory is no longer usable by anything else.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 21, 2012 at 11:48 am
SSD's do indeed need system RAM but with 1 TB of RAM.. well it doesn't really matter does it.
Have a look at Wesley Browns article on Fusion SSD's on SQLServerCentral.
http://www.sqlservercentral.com/articles/SSD+Disks/69693/
1K block size needs 2900 MB per 80 GB
2K block size needs 1500 MB per 80 GB
etc..
March 21, 2012 at 12:12 pm
Thanks for you comments.
So like any driver they need a small amount of CPU/ram to work. Surely thats going to be measured in a couple of MB and not 100's MBytes. Hopefully.
March 21, 2012 at 2:55 pm
Thanks for that and link to the artical. The memory mapping does seem to be an issue but still sounds ideal for TempDB. Hmm, I wonder.......
Sorry about my post seeming out of order. I, yet again, forgot to refresh the page before posting a reply after being distracted.
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply