I want to Know How many Connection are open on Sql Server

Hello,

Any idea how to check how many connection open on sql server.

 

It is up to the hosting service, unless it is your own server.

Some information is available at Microsoft, http://support.microsoft.com/kb/321185

 

i want to know how many connection open at a instant & i have check the Microsoft link it is related to other things

 

i want to know how many connection open at a instant & i have check the Microsoft link it is related to other things

 

If you have the correct rights try

sp_who

or

sp_who2

However either of these can require some fairly high level rights which if your on a shared database you may (in fact should) not have.

Basically any other way of doing it would require those same rights, the only way to "get around it" would be for your hoster to create a stored procedure that you did have access to, that accessed that data.

The way sp_who/sp_who2 works varies on different versions of SQL Server, on 2005 is may work regardless of server rights but only return data relating to parts of the database you already have access to.

Jen

 

Ok

I got it i am looking for this stuff

 

Also, the is quite handy as well sp_lock, it shows what processes have locks on tables on the server.
Cheers
Mark

 

You can find out the connections are open in sql server

by using the sql query

SELECT SPID,
STATUS,
PROGRAM_NAME,
LOGINAME=RTRIM(LOGINAME),
HOSTNAME,
CMD
FROM MASTER.DBO.SYSPROCESSES
WHERE DB_NAME(DBID) = 'your database name' AND DBID != 0

Please mark it as answer if ok

 

It's good question about database connection.You got the particular answer then please reply me.

 

According to me We have the following settings in our web.config file to store session i am not sure but we could done using this one .