March 9, 2007 at 1:49 pm
What type of query can I use to see what is the "Read Batch Size" of the Log Reader Agent used for Transactional Replication. By default, from my readings/knowledge, Batch Size is either default as 500 or 1000 Transactions/Commits, but this value can be set for individual implementations. Batch Size can be used for both the Log Reader Agent and the Distribution Agent in Transactional Replication.
Is there any queries out there can I can use to check what is currently this value. Any help will be greatly appreciated.
Thanks,
SQL Server DBA
MCTS
March 11, 2007 at 12:11 am
select *
from msdb..MSagent_parameters
where profile_id = 1
OR
you can right click the log reader agen and click agent profile...
MohammedU
Microsoft SQL Server MVP
March 13, 2007 at 10:37 am
Sorry, this post is no longer up to date, I have added some comments to my posting at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=350384#bm351189 . Please check and respond there, thank you and sorry for any confusion.
Thanks,
MCTS
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply