SQL Server
Configure SQL Dependency
SQL Dependency can be used in two modes, i.e., the Default mode or Custom mode. In the Default mode, the SQL Dependency creates a default service and queue at run time for the SQL server. In the case of Custom mode, a customer-defined SQL Dependency service and queue will be created and used by NCache. In this case, NCache will connect with the pre-created service and queue with the following naming convention:
NCacheDBService-[IP-Address]
NCacheDBQueue-[IP-Address]
You can change the SQL Dependency service and queue name prefix by specifying it against the NCacheServer.NCacheDBServicekey
and NCacheServer.NCacheDBQueue
key.
<add key="NCacheServer.NCacheSQLNotificationService" value="NCacheSQLService"/>
<add key="NCacheServer.NCacheSQLNotificationQueue" value="NCacheSQLQueue"/>
See Also
Configure Caches
Cache Settings
Server Connectivity
Windows Events
Logging