SQL server background updates / backplane setup

[percramer]

Hi all,

i was wondering what others might use in the following situation. I have got distributed cache + backplane running. Now there are also some stored procedures running scheduled on my SQL server and an external application that has got database access (out of my control) through some selected stored procedures.

How do you handle cache updates in this situation? Automatically somehow? I could create a service that uses change tracking of query notification from SQL server to monitor for these types of changes.

So just wondering if there are others that have dealt with this already :-)