September 25, 2009 at 2:22 pm
Hi friends,
We have some stored procedures (173 proc) which import data from external system to our data warehouse. Those procedures are written in sql 2000. This import process taking whole night.
The steps are as follows...
1. Retrieve the recent updated records (last 3months records )
2. Dropping indexes on the target table
3. adding additional fields apart from the fields importing
4. additional manipulations on the imported data
5. inserting to target table or updating if the records already exists
6. recreating indexes
I am given a task to modify the stored procedures in sql 2008 and to improve the performance.
What is the best way to increase the performance. What changes I should concentrate from the existing SPs.
thanks in advance
September 26, 2009 at 4:56 pm
I think it is more better and so fast to act performance tuning plan using DTA especially for complex steps then apply these enhancements of indexes and statistics on related tables to get best hoped performance.
From my experience , I always get great Performance enhancement reached to 90% for more than 50% of SQL Statements occurred on database.
[font="Arial Black"]Performance Guard[/font]
[font="Courier New"]Just ask me to get 0 sec for all queries[/font]
September 27, 2009 at 8:32 am
173 stored procedures? That just doesn't seem right somehow and it smacks of RBAR. How many rows do each of these stored procedures handle... one?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply