This video shows how to access the SQL Server extended events, which has replaced SQL Server Profiler, and setup and activate sessions to track events.
Hey there, God bless your efforts. I have a simple enquiry as a new sql learner. How is sessions handled in sql applications? Are sessions related only to transactions or it is much broader than that? Thanks a lot.
You establish a session when you connect to the server. Your session then stays active as long as you are connected. A transaction is a specific piece of work that you do while you are connected. You can have multiple transactions within a single session.
Hey there,
God bless your efforts.
I have a simple enquiry as a new sql learner.
How is sessions handled in sql applications? Are sessions related only to transactions or it is much broader than that?
Thanks a lot.
You establish a session when you connect to the server. Your session then stays active as long as you are connected. A transaction is a specific piece of work that you do while you are connected. You can have multiple transactions within a single session.