Logins With More Than One Session


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

1

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.

SELECTlogin_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

2

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?

SELECTlogin_name ,

COUNT(session_id) AS session_count

FROM sys.dm_exec_sessions

GROUP BY login_name

ORDER BY login_name

3

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.

SELECTsession_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.

0 Comments

Anonymous avatar x30
Guest

Sign Up with Email