You have to wonder what SQL Server 2005 Standard on a server with, say 48GBs of RAM and maybe high end WIN7 PRO with less RAM using something like
http://www.tigerdirect.com/applications/SearchTools/item-details.asp?EdpNo=6797313&CatId=8There are faster SSD PCIe cards. This one is nice since it is bootable no matter the motherboard. With Windows 7 you would probably have a BIOS to desktop bootup in less than 12 to 15 seconds.
So one way to get around the software would be SQL which could utilize 40GBs of RAM, which could save quite a few data pages of ePrescribing without deleting older data pages. So, since AC will look at SQL first to see if the page is cached first, it will have a better chance (just guessing 40 to 1 -- probably not that linear) of getting the data without going to the user database on the hard drive. But, if one did have to, then the data would be pulled from the database, but at much faster access speeds.
All of my clients were at around 90 IOPs. I have now upgraded five of the eight to SSD SATA 3 and theoretically should get 60,000 IOPs, just a tad more. An OCZ or Crucial PCIe card could get up to 330,000 IOPs.
Of course, some of the performance would still be with the client no matter how good the servers.
Just to give an idea (I don't know how this turned into my bragging
) but I can now open Word from the hard drive in under 0.5 seconds. I have no idea what Add-ins are in it since I can't see them. But, still the reboot times of 20 seconds from Windows to CTRL - ALT - DELETE is crazy.
