SqlWebEventProvider Class
Implements an event provider that saves event notifications to an SQL database.
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 ref class SqlWebEventProvider : public 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.
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. |
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>
- 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.
System.Configuration.Provider::ProviderBase
System.Web.Management::WebEventProvider
System.Web.Management::BufferedWebEventProvider
System.Web.Management::SqlWebEventProvider
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.
Note: