Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
WoodHouse
Posting Yak Master
211 Posts |
 Posted - 2010-03-09 : 02:22:11
|
| How to limit the number of sessions/Connections for a specific login and host(Machine name)?Why I am asking this questions is to manage the developers not to use more than n sessions / Connections from their machine (Host)? One more questions : What is the difference between sessions and connections ? is it one to one or one to many or many to many relations?Help on this Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
WoodHouse
Posting Yak Master
211 Posts |
Posted - 2010-03-10 : 01:29:57
|
| Thanks a lot tara |
 |
|
|
WoodHouse
Posting Yak Master
211 Posts |
Posted - 2010-03-10 : 01:40:16
|
| Hi tarawhy Microsoft has to maintain two DMVs.Sys.dm_exec_sessions and sys.dm_exec_connections. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
number of sessions