SELECT Statement in OLEDB source of SSIS package taking long time

Hi iam having an SSIS package with simple SELECT statement  in OLEDB source of an SSIS package, previously it runs fast but now a days it is increasing time day by day even there is no DATA to pull. 

We have increase the RAM size and 4  processors to 6 processors, changed maxdop settings even though there is no change in it.

Is there any way to optimize this , please let me know if having any resolution

Thanks in advance

April 27th, 2015 7:45am

Hi

1.Indexes might be fragmented,rebuild all indexs and try to update stastics at table/database level

Free Windows Admin Tool Kit Click here and download it now
April 27th, 2015 9:00am

Can you show us the statement? BTW , have you ran your SELECT in the SSMS to make sure that's a problem?

How much data does it  return?

April 27th, 2015 9:05am

Whats the source? Is it SQLServer or some other RDBMS?
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2015 9:27am

Update stats will work for you. 

Exec Sp_updatestats 

If that won't help too. Try to rebuild query plans, you can do that on a specific table by

EXEC sp_recompile 'yourTableName'

Hope this will help.

April 27th, 2015 11:38am

Hello Varun,

As other experts suggested, the problem is NOT with your ram or system processor, It is your DB and SQL statement.
To resolve this issue, do these checks:

* Check the query execution plan
* Re-build your indexes
* Update statistics of tables

I hope, this will surely solve your problem.

Free Windows Admin Tool Kit Click here and download it now
April 28th, 2015 1:43am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics