TheSQLGuru (7/22/2013)

---

For me the biggest limitation in Standard Edition is the RIDICULOUSLY LOW maximum memory. Fortunately you can supplant that with SSD storage to some degree, although I will caution anyone who thinks that is a magic bullet. PageIOLatch_xx can still get you, but they will be less onerous than the tens to perhaps thousands of milliseconds you may see with rotating media and too little RAM. The other biggie, and I mean potentially non-functional application biggie, is deadlocks. I have had several clients that have started throwing a blizzard of deadlocks after moving to SSD storage, including one that had to roll back to rotating media to get their system reusable!!