Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

smart_admin.sp_get_backup_diagnostics

Returns the Extended Events logged by Smart Admin.

Use this stored procedure to monitor Extended Events logged by Smart Admin. SQL Server Managed Backup to Windows Azure events are logged in this system and can be reviewed and monitored using this stored procedure.

Applies to: SQL Server (SQL Server 2014 through current version).

Topic link icon Transact-SQL Syntax Conventions

smart_admin.sp_get_backup_diagnostics [@xevent_channel = ] 'event type' [, [@begin_time = ] 'time1' ] [, [@end_time = ] 'time2'
VARCHAR(255) = 'Xevent',
@begin_time DATETIME = NULL,
@end_time DATETIME = NULL
@xevent_channel

The type of Extended Event. The default value is set to return all events logged for the previous 30 minutes. The events logged depend on the type of Extended Events enabled. You can use this parameter to filter the stored procedure to show only events of a certain type. You can either specify the full event name or specify a substring such as: ‘Admin’, ‘Analytic’, ‘Operational’, and ‘Debug’. The @event_channel is VARCHAR (255).

To get a list of event types currently enabled use the smart_admin.fn_get_current_xevent_settings function.

[@begin_time

The start of the time period from which the events should be displayed. The @begin_time parameter is DATETIME with a default value of NULL. If this is not specified then the events from the past 30 minutes is displayed.

@end_time

The end of the time period up to which the events should be displayed. The @end_time parameter is DATATIME with a default value of NULL. If this is not specified then the events up to the current time is displayed.

This stored procedure returns a table with the following information:

Column Name

Data Type

Description

event_type

NVARCHAR(512)

Type of Extended Event.

Event

NVARCHAR(512)

Summary of the event logs.

Timestamp

TIMESTAMP

Timestamp of the event that shows when the event was raised.

Permissions

Requires EXECUTE permissions on the stored procedure. It also requires VIEW SERVER STATE permissions since it internally calls other system objects that require this permission.

The following example returns all the events logged for the past 30 minutes

Use msdb
Go
EXEC smart_admin.sp_get_backup_diagnostics

The following example returns all the events logged for a specific time range.

Use msdb
Go
EXEC smart_admin.sp_get_backup_diagnostics @xevent_channel = 'Admin',
  @begin_time = '2013-06-01', @end_time = '2013-06-10'

The following example returns all the analytical events logged for the past 30 minutes

Use msdb
Go
EXEC smart_admin.sp_get_backup_diagnostics @xevent_channel = 'Analytic'
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.