Hello every one
I have differences in SQL 2005 in performance. I mean SQL 2005 on the
SBS2003 is slower than SQL 2005 enterprise, or standard (the same hardware
and database (10 GB and 10 user)). On this database it should be the same, I
think. Where should be the reason? Any suggestion?I believe there are some things that EE can do that other versions cannot.
But when you upgraded both, did you update statistics? This is a CRITICAL
step for performance that MANY people miss when they upgrade a database to
2005.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Ostry" <ostry11@.neostrada.pl> wrote in message
news:fb1q69$o5d$1@.atlantis.news.tpi.pl...
> Hello every one
>
> I have differences in SQL 2005 in performance. I mean SQL 2005 on the
> SBS2003 is slower than SQL 2005 enterprise, or standard (the same hardware
> and database (10 GB and 10 user)). On this database it should be the same,
> I think. Where should be the reason? Any suggestion?
>
Tuesday, February 14, 2012
Differences between SQLs 2005 (performance)
Labels:
database,
differences,
enterprise,
microsoft,
mysql,
oracle,
performance,
sbs2003,
server,
slower,
sql,
sqls,
standard
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment