How many people using in this connection

Posted by Jayakumars under ASP.NET AJAX on 2/26/2018 | Points: 10 | Views : 1886 | Status : [Member] [MVP] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi

How to find how many people use my mssql connections

not a user based only connection based

which place they from connected in my mssql server

how to find ?

then how to find incoming process from in my mssql server?

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Sheonarayan on: 2/26/2018 [Administrator] HonoraryPlatinum | Points: 25

0	You need to use few other things apart from Microsoft SQL Server Management Studio. 1. use Sp_who or sp_who2 to know the number of connection, user etc. 2. Use Resource Monitor (Task Manager > Performance >) and look at the Network, process related connectivity, memory consumption etc. Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

You need to use few other things apart from Microsoft SQL Server Management Studio.

1. use Sp_who or sp_who2 to know the number of connection, user etc.
2. Use Resource Monitor (Task Manager > Performance >) and look at the Network, process related connectivity, memory consumption etc.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts