FIX: Dynamic Snapshot Generation May Experience Slow Performance (327637)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q327637 BUG #: 361560 (SHILOH_BUGS) SYMPTOMS Dynamic snapshot generation for a publication may
experience performance problems that might cause the dynamic snapshot process
to take longer than expected.
CAUSE If the publication contains a large number of articles (say
around 100), and each article has dynamic filters defined on them, the snapshot
process does not optimize the underlying query (a system generated view that
creates the BCP OUT file for the msmerge_contents table). Therefore, the dynamic snapshot process slows down.
RESOLUTION To resolve this problem, obtain the latest
service pack for Microsoft SQL Server 2000. For additional information, click
the following article number to view the article in the Microsoft Knowledge
Base: 290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack : The following hotfix was created before the release of Microsoft
SQL Server 2000 Service Pack 3. The English version of
this fix has the file attributes (or later) that are listed in the following
table. The dates and times for these files are listed in coordinated universal
time (UTC). When you view the file information, it is converted to local time.
To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name
------------------------------------------------------
08/07/2002 09:29 36 KB QFE361560.sql
08/05/2002 22:24 8.00.0672 277 KB Rinitcom.dll
NOTE: Because of file dependencies, the most recent hotfix or feature
that contains the files may also contain additional
files. STATUSMicrosoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
This problem was first corrected in Microsoft SQL Server
2000 Service Pack 3.MORE INFORMATION With this fix a new snapshot option, UsePerArticleContentsView, has been added. The UsePerArticleContentsView option takes a value of 1 for ON and a value of 0 for OFF. When
the UsePerArticleContentsView option is turned on, the system generated view will BCP OUT one
article at a time and append it to the same .bcp file. By doing this, it avoids
generating an un-optimized system generated view, thereby leading to faster
execution of the dynamic snapshots.
You can also specify the UsePerArticleContentsView option as a profile parameter for the Snapshot Agent.
| Modification Type: | Minor | Last Reviewed: | 9/27/2005 |
|---|
| Keywords: | kbHotfixServer kbQFE kbbug kbfix kbSQLServ2000preSP3fix kbSQLServ2000sp3fix KB327637 |
|---|
|