SqlWebEventProvider Class

.NET Framework (current version)

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

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

Inheritance Hierarchy

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

Syntax

C++

[<PermissionSetAttribute(SecurityAction.InheritanceDemand, Unrestricted = true)>]
type SqlWebEventProvider = 
    class
        inherit BufferedWebEventProvider
    end

Constructors

	Name	Description
	SqlWebEventProvider()	This API supports the product infrastructure and is not intended to be used directly from your code. Initializes a new instance of the SqlWebEventProvider class.

Properties

	Name	Description
	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

	Name	Description
	Equals(Object)	Determines whether the specified object is equal to the current object.(Inherited from Object.)
	EventProcessingComplete(WebBaseEventCollection)	This API supports the product infrastructure and is not intended to be used directly from your code. Called when event processing is complete.
	Finalize()	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.(Inherited from Object.)
	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)	This API supports the product infrastructure and is not intended to be used directly from your code. Sets the initial values for this object.(Overrides BufferedWebEventProvider.Initialize(String, NameValueCollection).)
	MemberwiseClone()	Creates a shallow copy of the current Object.(Inherited from Object.)
	ProcessEvent(WebBaseEvent)	This API supports the product infrastructure and is not intended to be used directly from your code. Processes the event passed to the provider.(Overrides BufferedWebEventProvider.ProcessEvent(WebBaseEvent).)
	ProcessEventFlush(WebEventBufferFlushInfo)	Removes all events from the provider's buffer.(Overrides BufferedWebEventProvider.ProcessEventFlush(WebEventBufferFlushInfo).)
	Shutdown()	This API supports the product infrastructure and is not intended to be used directly from your code. Performs tasks associated with shutting down the provider.(Overrides BufferedWebEventProvider.Shutdown().)
	ToString()	Returns a string that represents the current object.(Inherited from Object.)

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>

Version Information

.NET Framework
Available since 2.0

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.