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.
| Author |
Topic |
|
stumbling
Posting Yak Master
104 Posts |
 Posted - 2007-04-02 : 22:25:15
|
| Hi AllJust out of interest i know there is a query governor in msde after 8 concurrent queries however is there a similar thing on other versions of sql?Cheers |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-03 : 03:28:48
|
| MSDE is a lightweight version of SQL Server (in fact it is just a database engine). It was designed to support limited workload and hence, it introduced query (or workload) governer to limit concurrent connections. Other editions of SQL Server doesn't require this limitation, hence they don't have query governer.In fact, query governer was kicked off from SQL Express also which is next version of MSDE.See more discussion on this hereHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
stumbling
Posting Yak Master
104 Posts |
Posted - 2007-04-06 : 00:55:39
|
| Thanks for that, i just could not remember if i had read something about 50 concurrent queries on some version of SQL. |
|
|
|
|
|
|
Just out of interest