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)

[AspNetHostingPermissionAttribute(SecurityAction.LinkDemand, Level = AspNetHostingPermissionLevel.Minimal)]
[AspNetHostingPermissionAttribute(SecurityAction.InheritanceDemand, Level = AspNetHostingPermissionLevel.Minimal)]
[PermissionSetAttribute(SecurityAction.InheritanceDemand, Unrestricted = true)]
public class SqlWebEventProvider : BufferedWebEventProvider

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 How to: Implement the Health Monitoring Custom Provider Example.

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 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

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

Community Additions

ADD
Show:
© 2014 Microsoft