Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot write an XEL file to my C drive from an Extended Events session Expand / Collapse
I am running the following Extended Events code to create a session but the .xel file does not get written to my C drive. Any suggestions??
Poll ResultsVotes
?
0%
0
Member Votes: 0, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Friday, October 11, 2013 1:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 9, 2014 12:51 PM
Points: 1, Visits: 20
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');
Post #1504126
Posted Friday, October 11, 2013 6:02 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:49 AM
Points: 129, Visits: 861
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
Post #1504175
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse