May 24, 2007 at 11:55 pm
I have a scenario in which I have to transfer data from one schema to another schema, for that purpose I have created a SP which perform this task. Initially, time required to transfer data from one schema to another schema, was in seconds. But now said SP takes more than 2 hours and after that gives the error message of "Timeout Expired".
Environment which I have, is as follow
1- Database size is 10 GB.
2- Processor: Pantium 3 GHrz
3- RAM: 1 GB
I was thinking that the problem I am facing just because of tempdb but when I saw the size of tempdb it was just 10 MB. I don't what is the problem at my end but this problem is really critical for me, any help will be highly appreciated.
Thanks in advnace
May 25, 2007 at 1:00 am
It sounds like a blocking issue; other than analysing (sp_who, sp_lock, sp_kill etc) who is blocking who, you can increase (at least temporarily) the instance connection timeout. Other thing you can do is to use the least restrictive isolation level or nolock query hint in your sp if dirty reads is something acceptable when transferring data between dbs.
Hope this helps.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply