January 13, 2010 at 2:14 pm
I am upgrading a SQL 2000 server 2.33 ghz quad processor 4 gb ram running windows 2000 to SQL 2005 Windows 2003 same processors and ram. Both servers are run on VM on the same server and same set of disks. After the upgrade is done there is significantly more activity on the processor. With only 3 – 4 users hitting the server all 4 processors are pegged at 100% and the users are seeing degraded performance. The SQL 2000 box had no issue with processors pegging. When I upgraded I set the databases to 2005, updated the statistics and reindexed them. I am just looking for some help on what could be causing the system performance issues I am seeing with 2005. Let me know if there is additional information you need and Thanks in advance for any help you can provide.
January 14, 2010 at 3:57 am
Did you updated the statistics after upgrading?
I hope that the below links wil help you:
http://www.sql-server-performance.com/tips/performance_monitor_cpu_counter_p1.aspx
January 14, 2010 at 5:23 am
We had performance issues after upgrading to 2005. Some of them were resolved after closely looking at the joins and finding we needed to modify or add the CONVERT functions between dissimilar data types. Not sure why, but it seemed as though 2000 was more forgiving of data type differences in joins. Look at some executions plans for areas to tune.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply