SQL 2008

I have a database on the same server as 2 applications that use the DB. Is there any way i can find out how many connections there are from the application to the db?

Running into performance issues with one of the applications but not the other.

LVL 1
Epic7Asked:
Who is Participating?
 
DrewKjellCommented:
SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame

You won't necessarily be able to tell which connections are from which application if you use the same DB Credentials however.

Drew
0
 
jorgedeoliveiraborgesCommented:
sp_who 'account1'
sp_who 'account2'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.