November 22, 2007 at 12:23 pm
I have upgraded a server with 4 CPU's 1.7 Dual Core AMD opteron.
Running with 16 GB RAM, on windows server 2003 enterprize edition.
and my server has really slowed down ?
An i missing something need urgent help
November 23, 2007 at 11:02 am
What version of SQL Server? 32 or 64 bit? Was this just a hardware update or was software updated as well.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
November 23, 2007 at 11:10 am
Well it was a Software Upgrade only.
I had a 32 bit SQL Server Standard edition which I upgradeed to
a 32 bit SQL Server Enterprise Edition.
Does an upgrade cause all the indexes to be lost?
November 23, 2007 at 12:44 pm
Version upgrade shouldn't cause indexes to be lost (although you should compare current schema to a copy of the schema take prior to the upgrade). You DO have a schema copy, right??
I would recommend updating the statistics for all indexes and columns. See sp_updatestats or UPDATE STATISTICS in BOL.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
November 24, 2007 at 5:31 am
How do you know the server's slowed down?
More CPU usage?
Queries in general slower?
Some queries slower?
Something else?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 26, 2007 at 9:16 am
run a profiler session to see query performance and then make the adjustments
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply