SqlWebEventProvider Class (System.Web.Management)

.NET Framework Class Library

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)

Syntax

Visual Basic (Declaration)

<AspNetHostingPermissionAttribute(SecurityAction.LinkDemand, Level := AspNetHostingPermissionLevel.Minimal)> _
<AspNetHostingPermissionAttribute(SecurityAction.InheritanceDemand, Level := AspNetHostingPermissionLevel.Minimal)> _
<PermissionSetAttribute(SecurityAction.InheritanceDemand, Unrestricted := True)> _
Public Class SqlWebEventProvider _
    Inherits BufferedWebEventProvider

Visual Basic (Usage)

Dim instance As SqlWebEventProvider

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

Visual C++

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

JScript

public class SqlWebEventProvider extends BufferedWebEventProvider

Remarks

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.

Note:
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.

Note:

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.

Examples

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>

.NET Framework Security

SecurityPermission
for full access to the resource protected by the permission. Associated enumeration: PermissionState..::.Unrestricted
AspNetHostingPermission
for operating in a hosted environment. Demand value: LinkDemand; Permission value: Minimal.
AspNetHostingPermission
for operating in a hosted environment. Demand value: InheritanceDemand; Permission value: Minimal.

Inheritance Hierarchy

System..::.Object
  System.Configuration.Provider..::.ProviderBase
    System.Web.Management..::.WebEventProvider
      System.Web.Management..::.BufferedWebEventProvider
        System.Web.Management..::.SqlWebEventProvider

Thread Safety

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

Platforms

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.

Version Information

.NET Framework

Supported in: 3.5, 3.0, 2.0

Reference

SqlWebEventProvider Members

System.Web.Management Namespace

WebEventProvider

HealthMonitoringSection

Other Resources

profiles Element for healthMonitoring (ASP.NET Settings Schema)

Creating and Configuring the Application Services Database for SQL Server