Number of concurrent requests to SQL Server 2005

Question

Post reply

Number of concurrent requests to SQL Server 2005

pshaship

SSCertifiable

Points: 6125
More actions
March 31, 2010 at 3:59 pm

#222727

Hi,
We have SQL Server 2005 EE 64 bit with SP3 and have MOSS 2007 databases in it. I would like to know Number of concurrent requests to SQL Server 2005 instance.
Where can I find that information?
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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

george sibbald SSC Guru Points: 104210 More actions · Answer 1

its in BOL somewhere.

From memory its 2 to the power of 15 or 32,768, i.e the value is held in a two byte field

Will that be enough connections for you? 🙂

---------------------------------------------------------------------

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

You can have up to 32768 connections to the instance. That is per instance assuming you have adequate memory to support all of the connections. Each connection will require a nominal amount of resources.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Richard M. SSCertifiable Points: 7401 More actions · Answer 3

I am not sure, but I believe the OP meant to know the number of current requests on a SQL instance.

To obtain the number of current connected sessions you could run

SELECT

COUNT(*)

FROM

sys.sysprocesses

WHERE

SPID >50

Additionally you could refine this by adding/grouping based on different criteria of the fields of that view.

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Richard M. (4/1/2010)
I am not sure, but I believe the OP meant to know the number of current requests on a SQL instance.
To obtain the number of current connected sessions you could run
SELECT
COUNT(*)
FROM
sys.sysprocesses
WHERE
SPID >50
Additionally you could refine this by adding/grouping based on different criteria of the fields of that view.

That is quite possible what he meant after having re-read it. Best to cover the bases.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events