SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Sql Server Connection
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

d17may
Starting Member

7 Posts

Posted - 07/06/2006 :  04:26:44  Show Profile
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 07/06/2006 :  04:43:02  Show Profile
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 - 07/06/2006 :  08:28:56  Show Profile
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
Flowing Fount of Yak Knowledge

India
5509 Posts

Posted - 07/06/2006 :  08:40:00  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message
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 - 07/06/2006 :  08:56:12  Show Profile
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 07/06/2006 :  11:22:13  Show Profile
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 - 07/07/2006 :  00:50:55  Show Profile
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

Denmark
384 Posts

Posted - 07/07/2006 :  01:10:26  Show Profile  Send PSamsig a Yahoo! Message
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 07/07/2006 :  01:35:27  Show Profile
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000