Using Extended Events

Constraints

• All RDS for SQL Server 2008 versions do not support extended events because Microsoft SQL Server 2008 does not support extended events.
• The etw_classic_sync_target type is not available for extended event targets.
• When an extended event is created or updated, only the path D:\RDSDBDATA\Log\error is supported. The file name can be customized.

Creating an Extended Event

1. Start the SQL Server Management Studio (SSMS) client and log in to it as user rdsuser.
2. Choose Management > Sessions > New Session.
   Figure 1 Creating an extended event
   

3. Click General and enter a session name.
   Figure 2 Entering a session name
   

4. Click Events and select an event.
   Figure 3 Selecting an event
   

5. Click Configure on the page displayed in 4.
   Figure 4 Configuring an event
   

6. Click Data Storage to configure the data storage.
   

   The file name can be customized. There is no need to click Browse because you can only browse the file system of the client where the SSMS is located, but not the file system of the RDS for SQL Server server. RDS for SQL Server supports the D:\RDSDBDATA\Log\error path only, so you only need to change the file name.

   Figure 5 Configuring the data storage
   

7. Click Advanced to configure the file generation policy.
   Figure 6 Configuring the file generation policy
   

8. Use the script to generate SQL statements. After confirming that the SQL statements are correct, run the SQL statements to create an extended event.

   -- Example SQL statements generated
   CREATE EVENT SESSION [temp_name] ON SERVER
   ADD EVENT sqlserver.lock_deadlock(
   ACTION(sqlserver.session_id,sqlserver.sql_text,sqlserver.username))
   ADD TARGET package0.event_file(SET filename=N'temp_name')
   GO