使用c#启动SQL Server扩展事件会话

using System;
using System.Data.SqlClient;

class Program
{
    static void Main(string[] args)
    {
        // 创建连接字符串
        SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
        builder["Data Source"] = "your_server_name";
        builder["Initial Catalog"] = "your_database_name";
        builder["Integrated Security"] = true;

        // 创建事件会话
        using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
        {
            connection.Open();

            // 创建事件会话对象
            using (SqlCommand command = connection.CreateCommand())
            {
                // 设置扩展事件会话的名称和目标文件路径
                command.CommandText = "CREATE EVENT SESSION YourSessionName ON SERVER ADD EVENT sqlserver.sql_statement_completed (ACTION (sqlserver.database_name)) ADD TARGET package0.event_file (SET filename=N'YourTargetFilePath.xel', max_file_size=(5), max_rollover_files=(2))";
                command.ExecuteNonQuery();
            }

            Console.WriteLine("扩展事件会话已启动。");
        }
    }
}