Re: Merge Replication Performance Issues/Trace Files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: SandiDBA (SandiDBA_at_discussions.microsoft.com)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 07:50:28 -0800

The update statement must have a where clause in it. I would like to know
what columns the where clause use to find the row to update. Then from
there, determine if an index is being used for optimization.

"Hilary Cotter" wrote:

> This update proc is being run in binary format.
>
> run this query in your subscription database
> select name from sysmergearticles where update_proc
> ='sp_upd_4FAB988B754745CDECFA93F09EC34073'
>
> to determine which table it is updating.
>
> Basically here are the parameters
>
> Rowguid=0x0000000000000000000000000080070000000000000000000000000000000000,
> metadata_type=3,
> lineage_old=0x00,
> generation=296,
> lineage_new=0xECFA93F002000000FF,
> colv= 0xECFA93F001000000ECFA93F001000000ECFA93F001000000ECFA93F00100000
>
> Then there should be a bunch of parameters whose values you have not
> supplied me with
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "SandiDBA" <SandiDBA@discussions.microsoft.com> wrote in message
> news:4946584E-0713-4190-BC0A-A35998E63CDA@microsoft.com...
> > We have a merge replication configuration with the distributor and
> subscriber
> > on one server and the publisher on another. The performance of the
> merge
> > slows down more and more as runs. The bandwidth between servers has
> already
> > been ruled out because there they run on a Sonet ring and T3 line between
> > them. We put SQL Profiler trace on the subscriber end of the merge
> process
> > using textdata and duration to try to pin point it down to the source of
> the
> > problem. However, the Textdata column has unreadable data, for instance
> >
> > exec([sp_upd_4FAB988B754745CDECFA93F09EC34073]
> > '8D8EF6A0-8EDA-4C71-934F-0FAE3E79AFFE',
> > 0x0000000000000000000000000080070000000000000000000000000000000000, 3,
> 0x00,
> > 296, 0xECFA93F002000000FF,
> > 0xECFA93F001000000ECFA93F001000000ECFA93F001000000ECFA93F00100000
> >
> > Does anyone know if there is any way to translate this into the actual
> query
> > executed? Otherwise, I don't see how this helps. I got the trace
> setup
> > from a Microsoft web site.
>
>
>

Relevant Pages

  • Re: Update a record in SQL Database from C#.NET
    ... SQ Server supports a data type called TIMESTAMP that can be used ... approach whether you are building your own UPDATE statement or if you ... > -In your WHERE clause, include all the original values of the fields. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to delete thousands of SQL records
    ... > crap out of the server, nearly pegging it for the duration. ... > With an actual test set, however, the service eat up almost 2GB of ram ... and the log file was never written. ... > clause generated more than a million rows and this is the problem. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Where exists in an update query
    ... appear in the Customers table. ... UPDATE supplier ... > one table in the UPDATE statement, you can use the EXISTS clause." ...
    (microsoft.public.sqlserver.programming)
  • Re: can avoid this rollback ???
    ... have a look at the transaction on the publisher which caused this process. ... It is probably a large update statement which is not being done as an update ... Looking for a SQL Server replication book? ... > We're testing Transactional replication with updatable subscriber. ...
    (microsoft.public.sqlserver.replication)
  • Re: Strange behavior of SELECTed data
    ... The order of a result set that has no ORDER BY clause depends on many ... hardware configuration of the server, ... >> You just can't rely on the mere resultset that you get after running the ... Retrieval order in the SELECT statement does not depend upon the ...
    (microsoft.public.sqlserver.programming)