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 |
|
|
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 moreThanks d17may |
|
|
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 moreThanks 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 AthalyeIndia."Nothing is Impossible" |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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. |
|
|
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 |
|
|
|