I use a RAM Disk for SQL TempDB on an ETL server. It works just fine (the server has 256GB of RAM), and it is fully supported, but in the upcoming re-architecture of the system I will be eliminating the RAM Disk and replacing it with SSD storage now that enterprise SSD storage is much more reasonable in cost than 2 years ago.
I would not place anything permanent in RAMDisk, but I'm reasonably comfortable hosting TempDB on it. Regards, Jim Jim Holmgren Director of Technology Infrastructure XLHealth Corporation The Warehouse at Camden Yards 351 West Camden Street, Suite 100 Baltimore, MD 21201 410.625.2200 (main) 443.524.8573 (direct) 443-506.2400 (cell) www.xlhealth.com<http://www.xlhealth.com/> From: Michael B. Smith [mailto:[email protected]] Sent: Wednesday, December 07, 2011 4:50 PM To: NT System Admin Issues Subject: RE: RAMDisk Prevalence? What a crock. If you have money to spare, put your temp files and pagefiles on SSD. Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com From: Sam Cayze [mailto:[email protected]]<mailto:[mailto:[email protected]]> Sent: Wednesday, December 07, 2011 4:29 PM To: NT System Admin Issues Subject: RAMDisk Prevalence? Our CRM reseller suggested I use a 1GB RamDisk for the part of the install that is accessed via the web clients. Haven't heard of the notion of using RAMdisks in AGES. Are people still using them? Are there still benefits? Is it supported by MS? I'm running the VM on Server 2008 R2 on a powerful ESX box with local 15K RPM Raid 10 storage. Will I really see a speed boost? Thoughts? Thanks, Sam ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin CONFIDENTIALITY NOTICE: This email, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or protected health information. Under the Federal Law (HIPAA), the intended recipient is obligated to keep this information secure and confidential. Any disclosure to third parties without authorization from the affiliate or as permitted by law is prohibited and punishable under Federal Law. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. NOTA DE CONFIDENCIALIDAD: Este facsímile, incluyendo lo adjunto, es para el uso exclusivo del destinatario(s) y puede contener información confidencial y/o información protegida de salud. En virtud de la Ley Federal (HIPAA), el destinatario tiene la obligación de mantener esta información segura y confidencial. Cualquier divulgación a terceros sin la autorización de los miembros de lo permitido por la ley está prohibido y penado en virtud de la Ley Federal. Si usted no es el destinatario, por favor, póngase en contacto con el remitente por teléfono y destruir todas las copias del mensaje original ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
