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 |
|
reoaran
Starting Member
20 Posts |
 Posted - 2010-08-03 : 13:20:13
|
| I was asked to find the total number of users accessing a db. I just right clicked the database and found "number of users" to be 15 and hence sent 15. But they told me there are more than 1000 users accessing the db. Am i looking in the wrong end or Is there any other specific way to find this out ?. What is the use "number of users" in the database properties ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
reoaran
Starting Member
20 Posts |
Posted - 2010-08-03 : 13:48:02
|
| Yes Tara.. we could check for the connections there ... But any specific way to find the number of users accessing the db ? Any way to find them indirectly using sys.dm_tran_locks or exec requests ... ? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
reoaran
Starting Member
20 Posts |
Posted - 2010-08-03 : 14:15:39
|
| I also get status apart from RUNNING and the connections that are inactive. And i have a small clarification if you can help... If there are 1000 users accessing the application in the front end that is connected to this database, then how many connections it would show in the sysprocesses |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
reoaran
Starting Member
20 Posts |
Posted - 2010-08-03 : 14:24:39
|
| ok Tara.. great.. I ran the query sysprocesses you provided and i had an output of just 12. But they tell me that there are more than 1000 users connected to this database. Hope they are connected indirectly or the one you told Application pooling... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Number of users accessing the Database