April 21, 2011 at 2:55 pm
Hi,
I have upgraded SQL server 2005 to SQL server 2008 in 32 bit platform in Production database.
After upgrade now BI application team report a incident performance is very slow. Query normally takes 60 min max..
It will take now min 3 hrs.. Any simple query also perform very slow. I have checked with sp_who2,
some blocking was there. Also I have suggested to rebuild index was also done. But still performance issue
comes. Please advice the steps to resolve the issue.. How SQL Server performance will improve.. ??
Need your urgent reply.. - Bidyendu..
April 21, 2011 at 4:05 pm
It will be very difficult to help if you do not provide more information. Please have a look through this article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 22, 2011 at 5:31 am
Did you update the statistcs after the upgrade?
There are a few instances where queries, especially complex or convaluted queries, had different execution plans after the upgrade due to regressions. Have you looked at the execution plans on your queries to determine if they're behaving poorly?
After that, it's hard to know without a lot more information. Look at your wait states, waiting processes, blocking processes, queries and query plans. Standard performance tuning stuff.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply