Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Insert issue

Author  Topic 

lenakarthike
Starting Member

5 Posts

Posted - 2009-03-09 : 01:44:22
I have insert command which is running in local server to fetch the data around 300 thousand of records from remote server and inserting into local server.

It take only 5 minutes to complete this task earlier.

Recently we had issue with sqlserver which is running in cluster environment.

After fixed the issue and It take around 10 hours for 300 thousand records

Is anybody answer for this...

Thanks,

karthik

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2009-03-09 : 16:11:03
What issue were you having and what did you do to fix it? Not a whole lot to go on based on your post. It's about the same as stating "My car won't start. Help" - Are you out of gas, is the battery working, do you have the key? More info is needed in order to provide meaningful responses.

Terry

-- Procrastinate now!
Go to Top of Page
   

- Advertisement -