Hi
My application connects to 3 databases .
I need to know how many connections are made by my application to each database
There are two applications servers. Basically what i need is to know how many connection to each database from each application server.
(that is how many connections from application server 1 to database 1,2 &3 and how many connections from applications server 2 to database 1 ,2 & 3)
Can this be done ..?
How to do it ?
Please help me in regard to this
Thanks in advance.
I would have a look at SQL Profiler, with this tool you will be able to run a trace on each of the databases and then count the connections to the database.
|||Hi
Thanks for the reply.
I need to know whether is there any parameter which i can use to monitor the same.
i suppose @.@.connections gives me the number of connections made to the server and not the databases. ?
Is there any parameter in SQL 2005 which i can use to monitor.
Please help....
Thanks in advance.
|||There is no parameter that you can use, but you could tag into the performance counters on the machine, or set up a view or function to sort the activity tables in the master database... Have a look at the stored proc sp_who2.
|||In SQL Server 2000 Enterprise Manager, open Management/Current Activity/Process Info and look for the logins the app uses (under column "User") and the databases (under column Database). In this way you can identify the connections. (Each process is a connection.) "Host" column may also help, this is the name of computer the application is running on.
In SQL Server 2005 Management Studio its similar, except you open Management/Activity Monitor.
|||In SQL Server 2000, query sysprocesses (e.g., select * from sysprocesses). Use loginname or nt_username to specify the login the app uses. You may want to translate dbid to the database name, sysdatabases gives you the "name" for each "dbid".