Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

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?
0
sqlserverdba
Asked:
sqlserverdba
1 Solution
 
Jeffrey CoachmanMIS 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now