Solved

Activity not captured by System Monitor (aka perfmon) when using the Log Reader Agent command line execution

Posted on 2011-09-06
4
193 Views
Last Modified: 2012-06-04
When running the LogRead.EXE instead of the SQL2k5 native Log Reader Agent UI, it appears that the System Monitor is not collecting the data points (the values are 0). Is there a way to collect these points?
However, when the Agent UI runs we see the collected data under the SQL Server: Replication Logreader Delivered Cmd/sec and Trans/sec counters. Here is the sample command line that is being executed every 10sec via SQL Job scheduler. As an aside, if anyone knows a way to execute the SQL job less than 10sec via the SQL Scheduler - please inform on it too :)
logread -Publisher S1 -PublisherDB DB1 -Distributor DB2 -DistributorLogin distributor_admin -DistributorPassword xxxxxxxxxxxx -MaxCmdsInTran 20000
0
Comment
Question by:DaJazzer
4 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36502402
With regard to the job execution less than 10 seconds, as you know, the gui won't allow this.   You could schedule two job tasks offset by X seconds, but you need to be sure they don't overlap.

You could also get around the SQL Server Agent scheduling problem by using windows:
http://stackoverflow.com/questions/2809442/sql-server-job-with-precise-timing
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 36512639
Or you could just write your own sql in a infinite while loop
something like
while 0=0
begin
         --start job here or
         EXEC your_sp_name
end

only thing you need to exit/break somehow the execution and there are ways for that in BOL.


also check the level of logging you pass when you execute it manualy:

"This switch has between 3 and 5 logging levels depending on which command you are running.  0 (zero) is basically no logging, and as the number goes up more data will be shown.  The distrib.exe, replmerg.exe and snapshot.exe takes 0-2, while the logread.exe takes 0-4."
http://itknowledgeexchange.techtarget.com/sql-server/tag/logreadexe/


0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Remove row and column 3 50
Problem to open text file 11 73
File Sharing with Apple and Windows 7 43
Why pdf file doesn't open ? 7 47
NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now