sp_Blitz® Result: Hekaton Tables In Use

Hekaton is a new way of storing data in SQL Server 2014. This part of our SQL Server sp_Blitz® script checks your tables to see if any Hekaton tables are in use.

Hekaton can actually be really cool. Here’s some of its advantages:

  • It stores data differently in a way that eliminates latch waits
  • If your stored procedures use a subset of T-SQL commands, they can get compiled to native code and run much faster
  • If you don’t need to persist the data to disk, you can skip disk writes altogether and just have some RAM-only tables

But you need to understand the limitations for SQL Server 2014. Click on the links to learn more about each restriction:

Whew! That’s a lot of limitations – make sure you understand those fully, because it impacts how you manage a database with Hekaton tables. Things got better in 2016, though.

To Learn More About Hekaton

List out the Hekaton tables to identify:

  • Their table sizes (keeping in mind their projected growth, 2014’s 250GB limit, and the double-memory requirement)
  • Their data storage (they may not be persisted to disk, so you’ll have an ugly surprise when rebooting the server)

Watch Brent’s DBA Reactions Guide to Hekaton

Return to sp_Blitz® or Ask Us Questions