September 11, 2007 at 11:25 pm
Hi,
Ive got a bit of a curly horror. I have a production box (2005 SP2 Std) that the owners want impacted as little as possible. Hence we've implemented a nightly backup and restore to a reporting box (2005 SP2 Std). Nice and simple, not much impact on the prod box. Now the users want a more real-time reporting solution. They don't want to use replication as they say the impact is too great on the prod box (thousands of articles), even with a remote dsitributor and a pull subscription. I'm pretty sure that for a remote distributor the Log Reader agent runs at the distributor machine, and for pull subscriptions the distribution agent runs at the subscriber machines so the only overhead should be the snapshot agent on initialization. So anyway, I'm down to log shipping to the reporting server in Standby mode. This is fine while users are asleep as the logs restore happily. When they're awake however they connect and run chunky reports, hence stopping the logs from being restored. The logs queue up and when all users get off, the logShip restore job locks them out for hours applying the backlog (sic) of shipped log. Is there anyway around this, or should I be forcing them down the repl route? Does a remote distribution and pull subscription trans repl setup cause any extra stress to the publisher machine?
gnashings of teeth and tearings of hair
thanks
Matthew
September 12, 2007 at 1:07 am
Matthew,
since you posted this under 2005 General discussion I assume you're using that version. So as an alternative to logshipping you can setup Mirroring and create snapshots on the mirror database. You're reports can than access the DB_Snapshot. Of course you still need to refresh the snapshot once in a while, but the interruption for users should be much shorter than the tlog restore.
Logshipping is intended as availability solution, not for scaling out reporting activities. So unless you have clearly defined restore windows, you will keep your current problems.
Markus
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply