July 2, 2008 at 8:56 am
I have the storedprocedure which is already in Sqlserver2000. It is taking 9 minutes to execute the StoredProcedure.
But When I execute the same procedure it is taking 1 hour.
I have done all the changing like remove Subquery etc to improve the performance. Please Provide the Solution as soon as possible.
Many Thanks in advance
Thanks
Karuna
July 2, 2008 at 9:19 am
Perhaps you could post the stored procedure and the execution plans from both servers.
July 2, 2008 at 11:54 am
Have you run UpdateUsage and CheckDB and updated all the statistics in the 2005 version of the database? (Assuming this is a migration from 2000 to 2005.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 2, 2008 at 12:11 pm
No way in the world to even suggest a solution without at least the execution plan.
"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 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply