January 4, 2011 at 11:25 pm
Hai,
I am using SQL Server 2005 Standard edition with OS Windows Server 2003 64 bit.
previously i am using SQL Server 2005 with SP 2 and everything is ok
until yesterday I upgrade with SP 4 then it becomes running so slow without blocking execution
and high CPU usage
please help
Thank you
January 5, 2011 at 12:55 am
Question is not having more details on issues to narrow down the issue.
if performance issue is with few queries:
1. check execution plan and address pain points
2. update statistics
3. check server and database settings are configured in optimal way
if all queries are taking more time than expected:
suggest you to run extensive set of DMVs available in below link to assess server performance in different areas. analyse top 5 records to get better clue.
Here is some discussions on similar performance issues after upgrade
http://www.sqlservercentral.com/Forums/Topic1027752-146-1.aspx
http://sql-server-performance.com/Community/forums/p/6753/40256.aspx
http://sql-server-performance.com/Community/forums/p/22930/130711.aspx
March 1, 2011 at 10:02 am
Hi,
Any resolution to your issues? I am seeing a big drop in query performance since I installed 2005 sp4, queries taking tens of hours instead of a couple of hours.
Not to be a naysayer but all the links from the first reply to this post refer to SQL 2000
Thanks
March 1, 2011 at 11:41 am
I could see some answers in below links...have a try
http://www.sqlteam.com/article/notes-from-an-upgrade-to-sql-server-2005
http://www.sqlservercentral.com/Forums/Topic1027752-146-1.aspx
http://www.mssqltips.com/tip.asp?tip=1230
suggest you to
1. rebuild indexes, update statistics of all user tables
2. run glennberry's extensive set of DMV's to find serverlevel and database level pain points
3. all your queries are taking too much time? or only few queries?
4. if only few queries, what execution plan says? indexes are used as expected?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply