none
SqlCacheDependency via Service Broker Notification in a WebEdition of SqlServer 2008 R2

    Frage

  • I would appreciate Your help:

    We are planing to buy SQL Server 2008 R2 Web Edition (we must this version), however we would also like to use a functionality of Service Broker for SqlCacheDependency - Notification Mode (NOT polling mode).

    On msdn.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx is said that Web Edition support for Service Broker (messaging) is : "Client only" - so some kind of short version.

    Our server-environment is:

    • one Http server with two web-application
    • one DataBase server with single instance of SQL Server 2008 R2 Web Edition.

    The idea is that: when new record is added to database table, sql server should notify both web-apllications and reset their caches (so we will have two integral caches). We are not planing to create a distributed cache (MemCache or sth)

    Is there any way to combine these two demands (SqlCacheDependency via Service Broker Notification in a WebEdition of SqlServer 2008 R2) ? Buy a module, or some server architecture tricks. Any ides ?

    Thanks in advance.



    Mittwoch, 13. Februar 2013 14:04

Alle Antworten