Cannot write an XEL file to my C drive from an Extended Events session

• eddiecejb

  Grasshopper

  Points: 11

  More actions

  October 11, 2013 at 1:04 pm

  #299043

  CREATE EVENT SESSION query_performance ON SERVER

  ADD EVENT sqlserver.sp_statement_completed(

  ACTION(sqlserver.query_hash)

  WHERE sqlserver.database_id = 13 AND sqlserver.query_hash <> 0),

  ADD EVENT sqlserver.sql_statement_completed(

  ACTION(sqlserver.query_hash)

  WHERE sqlserver.database_id = 13 AND sqlserver.query_hash <> 0)

  ADD TARGET package0.event_file(SET filename = N'C:\Temp\Traces\query_performance.xel');

• sqlsurfing

  SSCarpal Tunnel

  Points: 4883

  More actions

  October 11, 2013 at 6:02 pm

  #1658051

  Could it be possible your SQL Server service acct does not have permissions to the folder? (Try checking permissions to verify?)

  --------------------------------------------------
  ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀