SQL Server 2019 CTP 2.3 added a few new columns to sys.databases, including is_result_set_caching_on:


It's not documented yet in the What's New in SQL Server 2019, nor in the ALTER DATABASE page.

I tried using the same syntax as Accelerated Database Recovery just for laughs:


But no luck:

Msg 5058, Level 16, State 12, Line 8
Option 'RESULT_SET_CACHING' cannot be set in database 'StackOverflow2013'.
  • 2
    This was mentioned in one of the SQL Bits presentations in the context of polybase I think – Martin Smith Mar 3 at 21:38
  • 4
    You're going to need some windbg skills there, bud. – DBArgenis Mar 4 at 16:30
  • 3
    @DBArgenis You'd need 11,907 WinDbg skills I'd reckon – Paul White Jun 8 at 19:03

Currently, in CTP 2.3, in so far as I can tell - you cannot enable this, even under DAC.

  • 10
    You can, it's just, uh...I'm... (loosens collar)...looking for someone willing to go on record with it publicly. :-) – Brent Ozar Mar 3 at 18:20
  • 4
    ;) 13 more to go – Sean Gallardy Mar 3 at 18:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.