Hi friends,
Recently i configured merge replication with pull subscriber the snapshot
agent ran successfully but merge agent failed(never started)raising the
problem . any help would be appriciated.
Message posted via http://www.droptable.com
One posibility is that the job owner is invalid - if the job owner is a
domain login, try changing it to sa and restart the job.
Rgds,
Paul Ibison
|||Thnaks for reply but that didn't work.
when we see merge agent history shows nothing.
Message posted via http://www.droptable.com
|||sql server could not start error:22022
can any one tell the solution please.
Message posted via http://www.droptable.com
|||OK - I've found this article which hopefully explains what is happening:
http://support.microsoft.com/?kbid=870674
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql
Showing posts with label ran. Show all posts
Showing posts with label ran. Show all posts
Friday, March 23, 2012
merge agent displaying never started
Labels:
agent,
configured,
database,
displaying,
failed,
friends,
merge,
microsoft,
mysql,
oracle,
pull,
ran,
replication,
server,
snapshotagent,
sql,
subscriber,
successfully
Wednesday, March 7, 2012
Memory pressure while running Perfmon?
I ran a perfmon trace with Memory counters (part of periodic monitoring
effort). I noticed that the SQL Server:Buffer Manager, Free pages
counter had dipped to 317, 203, etc (nromal values> 10000). The first
time this happened today coincided with the time I started the Perfmon
trace (run from another server and inserted into a DB on this second
server).
Does Perfmon cause Memory pressure on the server whose counters it is
capturing - even if it isn't running on that server?
Thanks.<smithabreddy@.gmail.com> wrote in message
news:1148050087.274820.88350@.j55g2000cwa.googlegroups.com...
>I ran a perfmon trace with Memory counters (part of periodic monitoring
> effort). I noticed that the SQL Server:Buffer Manager, Free pages
> counter had dipped to 317, 203, etc (nromal values> 10000). The first
> time this happened today coincided with the time I started the Perfmon
> trace (run from another server and inserted into a DB on this second
> server).
> Does Perfmon cause Memory pressure on the server whose counters it is
> capturing - even if it isn't running on that server?
>
No. It does not.
David
effort). I noticed that the SQL Server:Buffer Manager, Free pages
counter had dipped to 317, 203, etc (nromal values> 10000). The first
time this happened today coincided with the time I started the Perfmon
trace (run from another server and inserted into a DB on this second
server).
Does Perfmon cause Memory pressure on the server whose counters it is
capturing - even if it isn't running on that server?
Thanks.<smithabreddy@.gmail.com> wrote in message
news:1148050087.274820.88350@.j55g2000cwa.googlegroups.com...
>I ran a perfmon trace with Memory counters (part of periodic monitoring
> effort). I noticed that the SQL Server:Buffer Manager, Free pages
> counter had dipped to 317, 203, etc (nromal values> 10000). The first
> time this happened today coincided with the time I started the Perfmon
> trace (run from another server and inserted into a DB on this second
> server).
> Does Perfmon cause Memory pressure on the server whose counters it is
> capturing - even if it isn't running on that server?
>
No. It does not.
David
Memory pressure while running Perfmon?
I ran a perfmon trace with Memory counters (part of periodic monitoring
effort). I noticed that the SQL Server:Buffer Manager, Free pages
counter had dipped to 317, 203, etc (nromal values> 10000). The first
time this happened today coincided with the time I started the Perfmon
trace (run from another server and inserted into a DB on this second
server).
Does Perfmon cause Memory pressure on the server whose counters it is
capturing - even if it isn't running on that server?
Thanks.<smithabreddy@.gmail.com> wrote in message
news:1148050087.274820.88350@.j55g2000cwa.googlegroups.com...
>I ran a perfmon trace with Memory counters (part of periodic monitoring
> effort). I noticed that the SQL Server:Buffer Manager, Free pages
> counter had dipped to 317, 203, etc (nromal values> 10000). The first
> time this happened today coincided with the time I started the Perfmon
> trace (run from another server and inserted into a DB on this second
> server).
> Does Perfmon cause Memory pressure on the server whose counters it is
> capturing - even if it isn't running on that server?
>
No. It does not.
David
effort). I noticed that the SQL Server:Buffer Manager, Free pages
counter had dipped to 317, 203, etc (nromal values> 10000). The first
time this happened today coincided with the time I started the Perfmon
trace (run from another server and inserted into a DB on this second
server).
Does Perfmon cause Memory pressure on the server whose counters it is
capturing - even if it isn't running on that server?
Thanks.<smithabreddy@.gmail.com> wrote in message
news:1148050087.274820.88350@.j55g2000cwa.googlegroups.com...
>I ran a perfmon trace with Memory counters (part of periodic monitoring
> effort). I noticed that the SQL Server:Buffer Manager, Free pages
> counter had dipped to 317, 203, etc (nromal values> 10000). The first
> time this happened today coincided with the time I started the Perfmon
> trace (run from another server and inserted into a DB on this second
> server).
> Does Perfmon cause Memory pressure on the server whose counters it is
> capturing - even if it isn't running on that server?
>
No. It does not.
David
Subscribe to:
Posts (Atom)