magarity kerns (4/8/2010)

---

Has anyone here tried SQL Server on something like the ram drives from Texas Memory Systems? They aren't persistent when the machine is off like SSD's...

reply to ian-707364:

"A solid state SAN won't come close - maximum bandwidth per slot is 4Gbps (500MB/s). Plus you have the added latency from the fabric switches, etc. But the...

Besides these entry level plug-in SSD cards, for IO demanding SQL Production environments I would recommend products like the DSI3600 units; (http://www.dynamicsolutions.com/dsi3600)

- Up to 5TB storage capacity,...

Hi Kim,

free performance tip: long time ago I discovered that when you FORMAT your -In Memory- RAMDRIVE to 64 KB NTFS instead of using the default...

hello Robert,

correct, it's 4x Raid-1 ; (see attached picture )

Hi Steve,

We use a production style disk configuration for the WR;

Some background information on the setup and findings:

- SQL2008 BulkInserts can write large 256 KB IOs ; ...