Database Reference
In-Depth Information
Listing 28-4.
Examining global attributes
select
xp.name as [Package]
,xo.name as [Predicate]
,xo.Description
from
sys.dm_xe_packages xp join sys.dm_xe_objects xo on
xp.guid = xo.package_guid
where
(xp.capabilities is null or xp.capabilities & 1 = 0) and
(xo.capabilities is null or xo.capabilities & 1 = 0) and
xo.object_type = 'pred_source'
order by
xp.name, xo.name
Figure 28-8.
Global attributes that can be used in predicates
Predicates can use the basic arithmetic operations and comparison functions provided by the Extended Events
framework. You can examine the list of available functions by using the query shown in Listing 28-5. Figure
28-9
shows the partial output of this query in SQL Server 2012.
