Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

snapshot replications sql 2005

Posted on 2011-09-16
1
Medium Priority
?
199 Views
Last Modified: 2012-08-13
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
Comment
Question by:sqlserverdba
1 Comment
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 36551167
"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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question