<div>
Impossible to know without seeing query plans.<br />
<br />
But you may be able to avoid the cursor and give yourself vastly better speed overall anyway. &nbsp;Can't say for sure w/o seeing the code.
</div>


Impossible to know without seeing query plans.

But you may be able to avoid the cursor and give yourself vastly better speed overall anyway.  Can't say for sure w/o seeing the code.

<div>
could there be issues with memory on the server?
</div>


could there be issues with memory on the server?

<div>
the code is too huge to be posted.
</div>


<div>
Like Scott said, it's impossible to know what the problem is without seeing your queries and plans. <br />
The code &quot;being too huge to be posted&quot; is never a good sign... Can you save it to file and attach it?
</div>


Like Scott said, it's impossible to know what the problem is without seeing your queries and plans.
The code "being too huge to be posted" is never a good sign... Can you save it to file and attach it?

<div>
Has an index &quot;disappear&quot; ?
</div>


<div>
<div class="content wysiwyg-content">
I have a SP which loads about 1.7 million records into a temp table, and then fetches each of those records and performs few checks to update records in physical tables<br />
<br />
The part which loads records in temp table is quick - 1 min. however the remaining part is taking very long all of sudden.<br />
<br />
Previously, entire SP used to query records in 3 mins. Now it takes 4-5 hours.<br />
<br />
Any idea what could be causing this and what should I look for to get this sorted?<br />
<br />
Thanks
</div>
</div>


I have a SP which loads about 1.7 million records into a temp table, and then fetches each of those records and performs few checks to update records in physical tables

The part which loads records in temp table is quick - 1 min. however the remaining part is taking very long all of sudden.

Previously, entire SP used to query records in 3 mins. Now it takes 4-5 hours.

Any idea what could be causing this and what should I look for to get this sorted?

Thanks

SP with Cursor all of sudden very slow

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.