MS SQL Server

Author

MSDE

Samuel Shulman

2006-10-24, 6:28 pm

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

Andrea Montanari

2006-10-24, 6:28 pm

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/d...ar_sa2_6dip.asp
http://msdn.microsoft.com/library/d...ar_sa2_0neh.asp
http://msdn.microsoft.com/library/d...ar_sa2_5fs6.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
--------- remove DMO to reply

Samuel Shulman

2006-10-24, 6:28 pm

Thank you,
Samuel

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:4n7c9vF8o9bsU1@
individual.net...
> hi Samuel,
> Samuel Shulman wrote:
>
> 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/d...ar_sa2_6dip.asp
> http://msdn.microsoft.com/library/d...ar_sa2_0neh.asp
> http://msdn.microsoft.com/library/d...ar_sa2_5fs6.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> --------- remove DMO to reply
>

Sponsored Links