Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

snapshot replications sql 2005

Posted on 2011-09-16
1
Medium Priority
?
196 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

715 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