Logging Information

Question

Post reply

Logging Information

saidapur_satish

SSC Veteran

Points: 288
More actions
December 6, 2010 at 5:35 am

#242162

Hi Friends,
1. How do i find how many users are using my database?
2. It is possible how many users are loping through application or using the application?
Thanks & Regards
Satish Saidapur

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

Satish,

You should be able to get the requisite information using this query.

SELECT * FROM sys.dm_exec_requests where DB_NAME(database_id)='YourDBName'

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

saidapur_satish SSC Veteran Points: 288 More actions · Answer 2

Hi Pradeep,

That query will work for internal user's or application user's

Adiga One Orange Chip Points: 27284 More actions · Answer 3

That query will list *all* sessions open on a given database. Just tweaked the query. In the output you can filter out the "internal" and "external" sessions based on the "program_name" column.

SELECT a.* FROM sys.dm_exec_sessions a

left outer join sys.dm_exec_requests b

on a.session_id=b.session_id

where DB_NAME(b.database_id)='YourDBName'

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

saidapur_satish SSC Veteran Points: 288 More actions · Answer 4

Hi Pradeep,

It is possible through GUI for see the user........

Thanks & regards

Satish

Adiga One Orange Chip Points: 27284 More actions · Answer 5

Satish,

You can get that information using Activity Monitor

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

saidapur_satish SSC Veteran Points: 288 More actions · Answer 6

saidapur_satish

SSC Veteran

Points: 288

December 6, 2010 at 7:54 am

#1259033

Thank you Pradeep....