Re: Need latency help for SQL 2K
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Wed, 30 Apr 2008 20:57:21 -0400
You can pipe sp_browsereplcmds to a results table (its the @results_table paramter). I suspect you have a batch operation which is generating a massive amount of inserts/updates/deletes and replication has to process all these commands.
"Kristy" <forums@xxxxxxxxxxxxxxxx> wrote in message news:OE1F5vvqIHA.4884@xxxxxxxxxxxxxxxxxxxxxxx
Anybody have any idea of things I can check with regards to latency on my replicated servers?
I have a production database with an MDF about 170GB and lots of continuous activity. All servers are running SQL Server 2K with SP4 on them. We use Transaction Replication to 2 servers - 1 at the same location as the production server and 1 in a different state.
For the last few months, I have noticed that during the middle of the night, nothing seems to be replicating and thus latency builds up. I have latency jobs in place to record the time to a text file, and thus I can nail it down to an approximate time that things start going haywire. By morning, latency is usually 11-12 hours behind and takes all day to catch up to its normal couple of second latency time. No one will admit to me what might have changed on the app side or if there is some other issue going on, so I have to track it down myself.
Any suggestions?
Thanks,
Kristy
.
- Follow-Ups:
- Re: Need latency help for SQL 2K- Hilary
- From: Kristy
- Re: Need latency help for SQL 2K
- From: Kristy
- Re: Need latency help for SQL 2K- Hilary
- Prev by Date: Re: NoSync expiration question
- Next by Date: Re: NoSync expiration question
- Previous by thread: Re: NoSync expiration question
- Next by thread: Re: Need latency help for SQL 2K
- Index(es):
Relevant Pages
|
