Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Sql Server Connection

Author  Topic 

d17may
Starting Member

7 Posts

Posted - 2006-07-06 : 04:26:44
How many connections can sql server can support at at time.one of my colleague told me it is only 8 .I search bol but didn't find what i want.


Thanks
d17may

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-06 : 04:43:02
max user connections is 32,768 or so. Was your friend referring to MSDE instead? MSDE has a workload governor that limits the system to having 8 concurrent operations executing on the same instance. However, you can still have up to 32,768 connections to the instance.

btw, here are the capacity specs for SQL 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx



-ec

Go to Top of Page

d17may
Starting Member

7 Posts

Posted - 2006-07-06 : 08:28:56
quote:
Originally posted by eyechart

max user connections is 32,768 or so. Was your friend referring to MSDE instead? MSDE has a workload governor that limits the system to having 8 concurrent operations executing on the same instance. However, you can still have up to 32,768 connections to the instance.

btw, here are the capacity specs for SQL 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx



-ec




8 concurrent operations executing on the same instance.
It means that not more than 8 query can be executed on the server at a time .Can u plz explain more

Thanks
d17may
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-07-06 : 08:40:00
quote:
Originally posted by d17may

quote:
Originally posted by eyechart

max user connections is 32,768 or so. Was your friend referring to MSDE instead? MSDE has a workload governor that limits the system to having 8 concurrent operations executing on the same instance. However, you can still have up to 32,768 connections to the instance.

btw, here are the capacity specs for SQL 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx



-ec




8 concurrent operations executing on the same instance.
It means that not more than 8 query can be executed on the server at a time .Can u plz explain more

Thanks
d17may




Which version of SQL Server you are referring to? 2000 or 2005? Are you talking about multiple connections or multiple queries in same connection?


Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

d17may
Starting Member

7 Posts

Posted - 2006-07-06 : 08:56:12
We use sql server 2000.what is the result in both conditions (i.e. mutiple connections and multiple queries in same connection)

Thanks
d17may
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-06 : 11:22:13
both SQL Server 2000 and 2005 have a maximum of 32,768 connections. All 32,768 connections can be executing queries at the same time.

the workload governor is only a feature of MSDE. MSDE is just the engine from SQL Server 2000 and it lacks many of the high end features found in the full product. MSDE is a separate product from SQL Server 2000 and it is free.

anyway, the workload governor only allows 8 of your 32,768 connections to be running a query at any given time.



-ec
Go to Top of Page

d17may
Starting Member

7 Posts

Posted - 2006-07-07 : 00:50:55
quote:
Originally posted by eyechart

both SQL Server 2000 and 2005 have a maximum of 32,768 connections. All 32,768 connections can be executing queries at the same time.

the workload governor is only a feature of MSDE. MSDE is just the engine from SQL Server 2000 and it lacks many of the high end features found in the full product. MSDE is a separate product from SQL Server 2000 and it is free.

anyway, the workload governor only allows 8 of your 32,768 connections to be running a query at any given time.



-ec



Thanks a lot now my doubt is clear.

Thanks
d17may
Go to Top of Page

PSamsig
Constraint Violating Yak Guru

384 Posts

Posted - 2006-07-07 : 01:10:26
And just for completeness, MS killed the governor in MSDE´s sucsessor, the free SQL Server 2005 Express edition.

-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those.
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-07 : 01:35:27
quote:
Originally posted by PSamsig

And just for completeness, MS killed the governor in MSDE´s sucsessor, the free SQL Server 2005 Express edition.



Good point. I just wanted to make the connection back to the question about SQL being limited to only 8 concurrent connections. I think that myth originated from misunderstanding the workload governor used in MSDE.



-ec
Go to Top of Page
   

- Advertisement -