• Webinars
  • Docs
  • Download
  • Blogs
  • Contact Us
Show / Hide Table of Contents

SQL Server

Note

This feature is only available in NCache Enterprise Edition.

Configure SQL Dependency

SQL Dependency can be used in two modes i.e. Default mode or Custom mode. In default mode, SQL Dependency creates a default service and queue at run time for SQL server. In 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 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/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

Back to top Copyright © 2017 Alachisoft