NSQuantumsSkipped (Transact-SQL)

Returns information about skipped quanta in the Microsoft SQL Server Notification Services application. Quanta can be skipped if the generator falls behind and quantum limits are set in the application definition file (ADF).

Syntax

[ application_schema_name . ] NSQuantumsSkipped

Return Code Values

None

Result Sets

The NSQuantumsSkipped result set is ordered by StartSkippedInterval.

Column Name Data Type Description

StartSkippedInterval

datetime

Start date and time, in UTC (Coordinated Universal Time or Greenwich Mean Time), of the interval skipped by the generator.

EndSkippedInterval

datetime

End date and time, in UTC, of the interval skipped by the generator.

SkippedIntervalInSeconds

int

Number of seconds in the skipped interval.

NumberOfQuantums

int

Number of quantum periods skipped during the interval.

EventChronicleRuleFiringsSkipped

nvarchar(255)

Indicates whether event chronicle rule firings were skipped during the interval. Possible values are Yes and No.

SubscriptionRuleFiringsSkipped

nvarchar(255)

Indicates whether subscription rule firings were skipped during the interval. Possible values are Yes and No.

Remarks

Notification Services creates the NSQuantumsSkipped stored procedure in the application database when you create the instance. When you update the application, Notification Services recompiles the stored procedure.

This stored procedure is in the application's schema, which is specified by the SchemaName element of the application definition file (ADF). If no schema name is provided, the default schema is dbo.

Permissions

Execute permissions default to members of the NSAnalysis database role, db_owner fixed database role, and sysadmin fixed server role.

Examples

The following example shows how to run the NSQuantumsSkipped stored procedure for an application. The result set includes all skipped quanta since the application started.

The application uses the default SchemaName settings, which places all application objects in the dbo schema.

EXEC dbo.NSQuantumsSkipped;

See Also

Reference

Notification Services Stored Procedures (Transact-SQL)

Other Resources

Notification Services Performance Reports
SchemaName Element (ADF)

Help and Information

Getting SQL Server 2005 Assistance