jeudi 8 janvier 2015

How can I filter an extended event by database in SQL 2008 R2


If I do an extended event session like this in 2008 R2:



CREATE EVENT SESSION [Query tracing] ON SERVER
ADD EVENT sqlserver.rpc_completed
(
ACTION(sqlserver.sql_text)
WHERE sqlsever.database_name = 'master'


I get an error:



Msg 25706, Level 16, State 8, Line 8
The event attribute or predicate source, "sqlsever.database_name", could not be found.


The same occurs for WHERE sqlsever.database_id = DB_ID('master')


Is there any way to filter by database?





Aucun commentaire:

Enregistrer un commentaire