NSQuantumFailures (Transact-SQL)
Returns information about failed generator quanta. Notification Services considers a quantum failed if the quantum cannot complete required processing.
Syntax
[ application_schema_name . ] NSQuantumFailures
Return Code Values
None
Result Sets
The NSQuantumFailures result set is ordered by QuantumId.
| Column Name | Data Type | Description |
|---|---|---|
QuantumId |
int |
Unique ID of a quantum. You can supply this ID to the NSQuantumDetails stored procedure to obtain additional information about the quantum. |
QuantumStatusDescription |
nvarchar(255) |
Text that describes the current status of the quantum. |
QuantumStartTime |
datetime |
Start time, in UTC, of the time period that the quantum represents. |
QuantumEndTime |
datetime |
End time, in UTC, of the time period that the quantum represents; the end time is the start time plus the quantum duration. |
ExecutionTimeInMS |
int |
Number of milliseconds to process the quantum. |
ExecutionStartTime |
datetime |
The real date and time, in UTC, at which the generator started processing the quantum. |
ExecutionEndTime |
datetime |
The real date and time, in UTC, at which the generator finished processing the quantum. |
Remarks
Notification Services creates the NSQuantumFailures 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, the db_owner fixed database role, and the sysadmin fixed server role.
Examples
The following example shows how to create the failed quantum report for an application.
The application uses the default SchemaName settings, which places all application objects in the dbo schema.
EXEC dbo.NSQuantumFailures;
See Also
Reference
Notification Services Stored Procedures (Transact-SQL)
Other Resources
Notification Services Performance Reports
SchemaName Element (ADF)