MSDE Performance

[Glasgow]

I have a SQL script that takes 13 seconds to run in standard SQL 2000 (development edition) and takes over 2 minutes under MSDE - using Query Analyser.

I am aware that MSDE effectively restricts to 'five concurrent workloads'. Would this be relevant in this context. What defines a 'workload' and when would these be concurrent. Would each 'GO' within the script generate such a workload?

Thanks in advance.

 

[sugarthans]

According to my understanding 5 Workloads in MSDE denotes to 5 concurrent conenctions and the performance degrades with moe connections.

MSDE implements something called as workload governer..It is used to limit the performance of application. That too when the workload goes up it will affect the performance of application.

After all MSDE is free. you cant expect it to perform as good as sql 2000

Sugarthan

 

[Glasgow]

Thanks Sugarthan.

Agreed on MSDE vs SQL 2000 performance - I may be missing something but surely this script is working through only one such connection - I'm trying to establish whether, perhaps, connection=batch in this context.

 

[sugarthans]

I think if it takes 13 seconds in sql-2000 it should take little more time in MSDE. but 2 min is somethign which you have to probe into. The 'GO' statement is mereley to differentiate it into many batches.it doesnt have anything to do with performance i believe.

Sugarthan