swwg69 (11/6/2013)
Everything old is new again. Back in the day, I packed a machine with RAM, created a VDisk and assigned tempdb to the VDisk. The machine's performance jumped!I tried putting some of the smaller lookup tables there. But that that made rebooting the server a pain. Now they are putting ALL the tables into RAM. How long does a reboot take?
I imagine most databases out there would benefit very little if any from this. But there are some cases that I think I could make some customers a little happier with the performance gain.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events