13:26:21.116 Parameter values obtained from agent profile: LogJob History (SRVDB01\SQL2005-JOBNAME-6) When running the Log Reader Agent I receive following message in the Log File Viewer: "PROFILENAME" 2 1 17 -MessageInterval 3600
"PROFILENAME" 2 1 17 -LogScanThreshold 500000 "PROFILENAME" 2 1 17 -HistoryVerboseLevel 1
Profile_name agent_type type profile_id parameter_name valueĭefault agent profile 2 0 2 -HistoryVerboseLevel 1ĭefault agent profile 2 0 2 -LoginTimeout 15ĭefault agent profile 2 0 2 -LogScanThreshold 500000ĭefault agent profile 2 0 2 -PollingInterval 5ĭefault agent profile 2 0 2 -QueryTimeout 1800ĭefault agent profile 2 0 2 -ReadBatchSize 500 It retrieves following results which correspond to the values I entered in the GUI (the profile with id 17 is applied, the others given for completeness): WHERE parameter_name LIKE '%ReadBatchSize%') WHERE pr.profile_id IN (SELECT profile_id JOIN MSagent_parameters pa ON pa.profile_id = pr.profile_id SELECT pr.profile_name, pr.agent_type, pr.type, pa.* Im quite confused meanwhile: please consider following statement retrieving all parameters from agent profiles which contain the "ReadBatchSize" parameter: Use Replication Monitor to view the details of this agent session.
10:36:49.627 Parameter values obtained from agent profile: in the log file viewer I see the following entry: is my ReadBatchSize being overwritten from somewhere with 500000?!? If so, where could that be? Thanks! Thanks for your prompt answer! I am currently trying (from default values QueryTimeout=1800 ReadBatchSize=500) QueryTimeout=65534 (max.