Posted: 2/14/2007 4:20:39 AM EDT
|
How many concurrent users will Microsoft SQL Server 2005 Enterprise Edition support? I have not been able to Google this and I cannot get to the MSDN webpage that may contain this little nugget of information... What is the absolute limit? Thanks |
|
SELECT @@MAX_CONNECTIONS AS 'Max Connections' Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. The number returned is not necessarily the number currently configured. To reconfigure SQL Server for fewer connections, use sp_configure. maximum according to BOL is 32,767 |
|
Thanks, Not actually using the software, just finishing up a paper comparing different database software packages. Don't know if you have any experience with these two pieces of software, but how would you compare IBM DB2 Data Ware House Edition against Oracle 10g? Not asking you to do my homework, just looking for an opinion from someone in the industry... |
i have 10g installed for some development work. used it very little. never seen db2. so i cant compare the two.. most sql dbs designed to meet the same requirements and therefore compete and more or less equal in general. its the little things, and perhaps thousands of little things that make each different. without actually doing some heavy lifting with each its hard to list the differences. i would suggest searching the net for sales literature for each where they have side by side comparisons.. i think btw that sql server 2005 enterprise is about 25k per cpu. oracle prolly similar as is db2. you can get a lot of stuff as a developer. thats what i have. a team architect version of vis studio 2005. |