How to clear SQL Server extended events that are stored in a file? Background Where are the files for SQL Server Extended Events Event File target stored? I want to delete months worth of log fi...

When I am trying to run Extended Event: CREATE EVENT SESSION [Loading] ON SERVER ADD EVENT sqlserver.sql_statement_completed(SET collect_statement=(1)) ADD TARGET package0.event_file(SET filenam...

I want SQL Server to create a log file recording of all (successful) logins/connections to the database. The log should contain minimally: IP address and port of the connecting client application...

I'm trying to find out what is updating the value of a column and i have very little knowledge of the application. At a quick glance I've noticed about 90% of the applications business logic is han...

I've set up SQL Server extended events to catch the last 1000 failed queries in a specific database into a ring buffer: Create Event Session [Errors] on Server Add Event sqlserver.error_reported ...

I am capturing locks_lock_timeouts_greater_than_0 events using Extended Events in SQL Server. The event session is following: CREATE EVENT SESSION MyQuery ON SERVER ADD EVENT sqlserver.locks_lock...

Can anyone suggest options we might have in capturing all SQL statements being sent to our SQL Server, outside of running Profiler? I'm aware of a couple ways of doing it, but want to make sure I'm...