Percent, and the results of these operations will use to access the DMV sys.dm_exec_sessions. Before getting into the bit you want to talk about it from the DMV;
This DMV can find detailed information about the session. Etc. which uses time of login session i. access the data.
for example;
select
*
FROM
sys.dm_exec_sessions
As can be seen above, select the process that we apply to the DMV can reach a lot of detail.
However, there is a situation like the DMV system includes lerinide process.
I can see it in the screenshot above. So the data is less than 50 percent in the erismekteyiz Session Id.
So we have this information, what do we do if we want to not want to just see s User Process.
Then you shoot the ones column is_user_process s final conclusion that the system process reflection.
I pulled his own system, in summary form with the details below ACCESSING wrote the script.
SELECT
login_name ,
COUNT
(session_id)
AS
session_count
FROM
sys.dm_exec_sessions
WHERE
is_user_process = 1
GROUP
BY
login_name
ORDER
BY
login_name
Yusufk's fifth session that appears on the screen above, I have a test user to the first session I units are available.
So I wanted to see what the outcome would be lerinide system process?
SELECT
login_name ,
COUNT
(session_id)
AS
session_count
FROM
sys.dm_exec_sessions
GROUP
BY
login_name
ORDER
BY
login_name
As can be seen above, entered into the system process Leri conclusion.
Sometimes the script above, 'i can run the Login Name field blank and with the results by number of session against the kind of experience that it was empty when I run the script on the quiet that you can access the following information.
SELECT
session_id ,
login_name ,
original_login_name
FROM
sys.dm_exec_sessions
WHERE
is_user_process = 1
AND
login_name <> original_login_name
This is how many of the session in which the user logged on the system. Tion process, and how do we get the system, such as instant answers to the questions in this article we see how the session adedimizi have seen.