I have read the paperwork on MSDE, it's limits, governor, etc., and I am
wondering for a real-world perspective if 25 - 30 users is fine or if it we
would experience problems using this? With SQL2005 just around the corner I
don't want to have my client order SQL2000 and then be told they need to
upgrade X months down the road.
Thanks,
Chris
hi Chris,
Chris Marsh wrote:
> Hi,
> I have read the paperwork on MSDE, it's limits, governor, etc., and I
> am wondering for a real-world perspective if 25 - 30 users is fine or
> if it we would experience problems using this? With SQL2005 just
> around the corner I don't want to have my client order SQL2000 and
> then be told they need to upgrade X months down the road.
you actually have to test your scenario... it really depends on code
standards, data load, hardware, but application rules too...
by the way, SQL Express will not have the Query Governor, but other kind of
limits, such as only 1 cpu (MSDE 2000 allows 2), and 1 GB ram (MSDE 2000
allows 2) use, so my understanding is that things will not change
drammatically with the new product...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you! Unfortunately, I cannot test 30 users in my own office (just not
that big) so the only option is to try live at a client site. If this would
fail, what would I expect just slower performance?
Also, if you are saying that Express and MSDE will have similiar performance
results due to different crippling approaches then if I have my app running
in an enviornment where it's already a single processor and 1GB RAM and it's
running fine there then this might be a mute point - correct?
Again thanks
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3f1t3jF5iiqrU1@.individual.net...
> hi Chris,
> Chris Marsh wrote:
> you actually have to test your scenario... it really depends on code
> standards, data load, hardware, but application rules too...
> by the way, SQL Express will not have the Query Governor, but other kind
> of limits, such as only 1 cpu (MSDE 2000 allows 2), and 1 GB ram (MSDE
> 2000 allows 2) use, so my understanding is that things will not change
> drammatically with the new product...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Chris,
Chris Marsh wrote:
> Thank you! Unfortunately, I cannot test 30 users in my own office
> (just not that big)
:D
>so the only option is to try live at a client
> site. If this would fail, what would I expect just slower
> performance?
you should check for time out problems too in your application code... as
you already know, when the Governor kicks in, all active batches are slowed
down, with performance "problems" (:D) ...
> Also, if you are saying that Express and MSDE will have similiar
> performance results due to different crippling approaches then if I
> have my app running in an enviornment where it's already a single
> processor and 1GB RAM and it's running fine there then this might be
> a mute point - correct?
did not made actual performance tests, and SQL Express is till in beta, but
I think the 2 environments, from a performance point of view, should be
pretty similar... but, all this, IMHO..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks - guess it's just a game of guessing
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3f3qcuF5q44jU1@.individual.net...
> hi Chris,
> Chris Marsh wrote:
> :D
>
> you should check for time out problems too in your application code... as
> you already know, when the Governor kicks in, all active batches are
> slowed down, with performance "problems" (:D) ...
>
> did not made actual performance tests, and SQL Express is till in beta,
> but I think the 2 environments, from a performance point of view, should
> be pretty similar... but, all this, IMHO..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
No comments:
Post a Comment