MSDE

I switched the database from a full version of SQL Server to MSDE 2000 and
the staff is complaining that the system is running slower (about 10 users)
Does it sound familiar?
Is there anything to do about that?
Thanks,
Samuelhi Samuel,
Samuel Shulman wrote:
> I switched the database from a full version of SQL Server to MSDE
> 2000 and the staff is complaining that the system is running slower
> (about 10 users)
> Does it sound familiar?
> Is there anything to do about that?
> Thanks,
> Samuel
MSDE includes a builtin query governor that kicks in when 8 concurrents
worloads are executing at the same time... this will result in a linear
performance degradation of all workloads... when the number of concurrent
workloads goes under that magic number, performances will be non longer
penalized..
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_6dip.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0neh.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply|||Thank you,
Samuel
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:4n7c9vF8o9bsU1@.individual.net...
> hi Samuel,
> Samuel Shulman wrote:
>> I switched the database from a full version of SQL Server to MSDE
>> 2000 and the staff is complaining that the system is running slower
>> (about 10 users)
>> Does it sound familiar?
>> Is there anything to do about that?
>> Thanks,
>> Samuel
> MSDE includes a builtin query governor that kicks in when 8 concurrents
> worloads are executing at the same time... this will result in a linear
> performance degradation of all workloads... when the number of concurrent
> workloads goes under that magic number, performances will be non longer
> penalized..
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_6dip.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0neh.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>