Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
The database 'IM' is not enabled for SQL cache notification.My confusion is that I believe cache notifications were discontinued after 2005 and replaced with a new service in 2008 R2. Is this correct? If so, what do I need to do to allow for caching with dependency out of the SQLDataSource?
To enable a database for SQL cache notification, please use the System.Web.Caching.SqlCach
eDependenc yAdmin.Ena bleNotific ations method, or the command line tool aspnet_regsql. To use the tool, please run 'aspnet_regsql.exe -?' for more information.
<asp:SqlDataSource ID="custItemsDS" runat="server" ConnectionString="<%$ ConnectionStrings:IMConnectionString %>" SelectCommand="...select command..." UpdateCommand="...update command..." EnableCaching="True" SqlCacheDependency="IM:ct_CustItem"> ...parameters... </asp:SqlDataSource>
<system.web> <caching> <sqlCacheDependency enabled="true"> <databases> <add connectionStringName="IMConnectionString" name="IM" pollTime="1000"/> </databases> </sqlCacheDependency> </caching>
|Enabled trace flag 4135 or 4199 - SQL SERVER||2||22|
|Dictionary and array of [N] size - performance tuned||12||40|
|How to keep a record with the highest value||3||38|
|Application.cfm not found issue||2||31|