Hi I have an inventory Table that is updated every 1 hr on our stage
database. This then replicates down to our reporting server using
tranactional replication . We have web pages that access the inventory table
on our reporting server and when reporting from this, this is sometimes blank
due to the transactional updates going on. The transactional updates takes 10
to 20 minutes. Does any one have any suggestions where I can keep a table for
reporting services but not in a state when it is not available for longer
then 5 mins or so.
thanks
Sammy
Sammy,
you could issue NOLOCK hints in the reporting query, or force the
distribution agent to work out of hours.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment