Edit

Share via


SqlWebEventProvider Class

Definition

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

public ref class SqlWebEventProvider : System::Web::Management::BufferedWebEventProvider
public class SqlWebEventProvider : System.Web.Management.BufferedWebEventProvider
type SqlWebEventProvider = class
    inherit BufferedWebEventProvider
Public Class SqlWebEventProvider
Inherits BufferedWebEventProvider
Inheritance

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>   

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.

Constructors

SqlWebEventProvider()

Initializes a new instance of the SqlWebEventProvider class.

Properties

BufferMode

Gets a value indicating the buffering mode used by the provider.

(Inherited from BufferedWebEventProvider)
Description

Gets a brief, friendly description suitable for display in administrative tools or other user interfaces (UIs).

(Inherited from ProviderBase)
Name

Gets the friendly name used to refer to the provider during configuration.

(Inherited from ProviderBase)
UseBuffering

Gets a value indicating whether the provider is in buffered mode.

(Inherited from BufferedWebEventProvider)

Methods

Equals(Object)

Determines whether the specified object is equal to the current object.

(Inherited from Object)
EventProcessingComplete(WebBaseEventCollection)

Called when event processing is complete.

Flush()

Moves the events from the provider's buffer into the event log.

(Inherited from BufferedWebEventProvider)
GetHashCode()

Serves as the default hash function.

(Inherited from Object)
GetType()

Gets the Type of the current instance.

(Inherited from Object)
Initialize(String, NameValueCollection)

Sets the initial values for this object.

MemberwiseClone()

Creates a shallow copy of the current Object.

(Inherited from Object)
ProcessEvent(WebBaseEvent)

Processes the event passed to the provider.

ProcessEventFlush(WebEventBufferFlushInfo)

Removes all events from the provider's buffer.

Shutdown()

Performs tasks associated with shutting down the provider.

ToString()

Returns a string that represents the current object.

(Inherited from Object)

Applies to

See also