Friday, March 30, 2012

One general q?

Helo all,
i have one general q about sql server and MSDE.
for how many users can i configure MSDE to work for?
i mean connection per second, or something like that?
thanks in advance!
-k.p.There is no such config in MSDE. Just leave the sp_configure settings as they are. MSDE is
throttled, when you have more than 5.8 queries *executing at the same time* a delay is introduced
for each I/O operation.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.|||There is no hard limit for the number of users that can connect to MSDE, but
as a rule of thumb you can assume that performance will degrade with more
than about 20 users connected concurrently.
--
Jacco Schalkwijk
SQL Server MVP
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.|||Thanx Tibor and Jacco for reply!
"gorostas" wrote:
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.|||http://www.aspfaq.com/2343
"gorostas" <gorostasREMOVE_THIS@.hotmail.com> wrote in message
news:FDD47216-3E4D-411C-96BA-33AC0ABA28F9@.microsoft.com...
> Helo all,
> i have one general q about sql server and MSDE.
> for how many users can i configure MSDE to work for?
> i mean connection per second, or something like that?
> thanks in advance!
> -k.p.

No comments:

Post a Comment