snapshot replications sql 2005

there is a snapshot replication that is refreshed nightly. The snapshot is now requiring significantly long time to complete. Is there anything to look for? or anything that can help speed up the process?
LVL 1
sqlserverdbaAsked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
"The snapshot is now requiring significantly long time to complete"
We need some context here...

1. Define "significantly long" in chronological terms
2. Is this "Long" time something new (all of a sudden), or has this been increasing faster that expected

I mean, if when you first ran this 5 years ago, with 1000 records it was fast.
But now 5 years later with "Millions of records, "it is now requiring significantly long time to complete"...
...Then this may just be normal...

(Consider Archiving some data perhaps...?)
0
All Courses

From novice to tech pro — start learning today.