Skip to Content
0

Anyway to drop an individual cached statement in ASE 16+

Aug 01, 2017 at 05:35 PM

61

avatar image

I thought I remember seeing a command to drop an individual cached statement (or was it a query plan?). I know there's a command to flush the whole statement cache. That's a separate thing.

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mark A Parsons Aug 01, 2017 at 07:16 PM
2

Not sure about 16+ specific commands, but since 15.5 there's dbcc purgesqlcache(sqlid)

And a (very) brief tidbit in the ASE WIKI : dbcc purgesqlcache

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I've enhanced the wiki entry a bit more, including how to determine the sqlid number.

-bret

0