Database Reference
In-Depth Information
Summary
This chapter introduced the concepts of in-memory tables and natively compiled stored procedures. These are
high-end methods for achieving potentially massive performance enhancements. There are, however, a lot of
limitations on implementing these new objects on a wide scale. You will need to have the Enterprise version of SQL
Server and a machine with enough memory to support the additional load. You're also going to want to carefully test
your data and load prior to committing to this approach in a production environment. But, if you do need to make
your OLTP systems perform faster than ever before, this is a viable technology.
The next chapter shows you how to set up the ability to automate the testing of your performance using
Distributed Replay.
