Re: Monitor Transaction log

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/28/04 

Date: Fri, 28 May 2004 07:08:30 -0400

You can set up a messagequeue and then via trigger for instance, write to
the queue when anything happens. On the client end you can poll to queue
which is much less intensive than querying the db. The new
querynotifications in ADO.NET 2.0 work similarly.

Instead of the queue you could use SQL Servers notification services to send
out a notification that data has changed. This probably won't be practical
for most scenarios unless you are really doing it in a limited scenario.

I know Casey had an example of doing this with Notification services at
www.brains-n-brawn.com .
HTH,

Bill 

-- 
W.G. Ryan MVP Windows - Embedded
http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/
"Chris Wagner" <so@hotmail.com> wrote in message
news:u$CbChHREHA.3140@tk2msftngp13.phx.gbl...
> Not really a publication but a simple monitoring tool to update another
app
> if anything changes on the SQL or Oracle (depends on each app). All I need
> is only a few tables (for update, insert, and delete) and monitor the
change
> log so I can see what changes and update other apps. Please advice. Thanks
>
>
> "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> news:%23k$$fZHREHA.628@TK2MSFTNGP11.phx.gbl...
> > If I understand you correctly, ADO.NET is probably not the way to go on
> > this
> > one.  Are you trying to build your own Publication?  Yikes.
> >
> > If so, what's the extent to what you need it to do?
> >
> > -- 
> > W.G. Ryan MVP Windows - Embedded
> >
> > http://forums.devbuzz.com
> > http://www.knowdotnet.com/dataaccess.html
> > http://www.msmvps.com/williamryan/
> > "Chris Wagner" <so@hotmail.com> wrote in message
> > news:e7f4cMHREHA.132@TK2MSFTNGP09.phx.gbl...
> >> Is there a way to monitor transaction log in SQL server and Oracle
server
> >> using .NET? I'd like to write in VB.NET to mimic the SQL server
> > replication
> >> (transactional publication) to use against SQL and Oracle to monitor
some
> > of
> >> the tables. Please advice. Thanks
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: Batch Requests/Sec counter
    ... The performance monitor shows it at the scale of 1000 so ... >I support the Professional Association for SQL Server ... >> The batch requests per second shown on the performance ... network card is only ...
    (microsoft.public.sqlserver.server)
  • Re: QUEUE READER - A FREQUENT PROBLEM!
    ... opinion what is the best choice: instal sp on sql server 2000 or install sql ... We are experimenting sql server 2005 replication making crash ... queue table and the same transaction coldn't be inserted at the ...
    (microsoft.public.sqlserver.replication)
  • Re: How can I make an efficient First-Come-First-Serve locking mec
    ... I am thinking that one thread reading from a synchronized queue and calling write after dequeing each message is the solution. ... the first thread to wait on the mutex ... I have considered using a waitHandle, Monitor, or a C# lock statement ... // I could of course simply create a stack of size N where N is the ...
    (microsoft.public.dotnet.general)
  • Re: Remote notification of presubmission queue exceeding set value?
    ... Why don't you use the script notification feature in ESM, ... > method of being remotely notified if the queue exceeds a set amount, ... when the SMTP service is plugged!? ... > I thought about getting another vendor's event log monitor that has it's ...
    (microsoft.public.exchange.admin)
  • Re: Multi threaded design patterns
    ... A factory to create a concrete descendant of FileProcessor depending on the file name / location. ... A dequeuer which has X number of worker threads which dequeues the next job from the queue. ... The classes above act as my "business domain", leaving the sole responsibility of the service to be to link them together and start/stop the dequeuer. ... When I stop the service I tell the monitor to stop looking for new files, I tell the dequeuer to empty its queues. ...
    (microsoft.public.dotnet.languages.csharp)