Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

SqlWebEventProvider Class

Implements an event provider that saves event notifications to an SQL database.

Namespace: System.Web.Management
Assembly: System.Web (in system.web.dll)

public class SqlWebEventProvider : BufferedWebEventProvider
public class SqlWebEventProvider extends BufferedWebEventProvider
public class SqlWebEventProvider extends BufferedWebEventProvider
Not applicable.

ASP.NET health monitoring allows production and operations staff to manage deployed Web applications. The System.Web.Management namespace contains the health event types responsible for packaging application health-status data and the provider types responsible for processing this data. It also contains supporting types that help during the management of health events.

This provider has a comprehensive set of configuration attributes that you can use to customize its behavior.

NoteNote:

In most cases you will be able to use the ASP.NET health-monitoring types as implemented, and you will control the health-monitoring system by specifying values in the <healthMonitoring> configuration section. You can also derive from the health-monitoring types to create your own custom events and providers. For an example of creating a custom provider, see ASP.NET Health Monitoring Custom Provider Sample.

The following example is a configuration file excerpt that shows how to specify a provider of type SqlWebEventProvider in the <healthMonitoring> section. The <add> element in the <rules> section specifies that the provider will handle audit events.

<healthMonitoring
  enabled="true"
  heartBeatInterval="0">
  <bufferModes>
    <add name="Analysis"
    maxBufferSize="1000"
    maxFlushSize="100"
    urgentFlushThreshold="100"
    regularFlushInterval="00:05:00"
    urgentFlushInterval="00:01:00"
    maxBufferThreads="1"
    />
  </bufferModes>
  <providers>
    <add name="SqlWebEventProvider"
    type="System.Web.Management.SqlWebEventProvider,System.Web"
    connectionStringName="LocalSqlServer"
    maxEventDetailsLength="1073741823"
    buffer="true"
    bufferMode="Analysis"
    />
  </providers>
  <eventMappings>
    <add name="All Audits"
    type="System.Web.Management.WebAuditEvent, System.Web" 
    />
  </eventMappings>
  <profiles>
    <add name="Default"
    minInstances="1"
    maxLimit="Infinite"
    minInterval="00:10:00"
    />
  </profiles>
  <rules>
    <add name="All Audits Default"
    eventName="All Audits"
    provider="SqlWebEventProvider"
    profile="Default"
    minInterval="00:00:30" 
    />
  </rules>
</healthMonitoring> 

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Windows 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft