Re: SQL Server Alert doesnt fire :(

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/01/05 

Date: Mon, 31 Jan 2005 21:26:38 -0500

I haven't tried it but I suppose that counter is referring to separate
transactions by session. Try multiple QA sessions and see how that works.
Also I don't know if your test actually counts since there is no data that
is actually being modified. You may want to modify a row in each session as
well. 

-- 
Andrew J. Kelly  SQL MVP
"LazyDBA" <LazyDBA@discussions.microsoft.com> wrote in message 
news:86BF54AD-ADA1-4BBE-B691-BCF188B5EF53@microsoft.com...
> Hi,
>
> I created a SQL Alert thru EM and the details are
>
> Type:              SQL Server  perfm condn alert
> Object:            SQL Server Databases
> Counter:          Active Transactions
> Instance:         database_name
> Alert If counter: rises above 2.
>
>
> Notification via mail and net send.
>
> I expect a notification when I have active transactions > 2.
> So I did 5 times
>
> begin tran
> Select getDate()
>
>
> select @@trancount
> --which gives 5..
> But the alert is not fired..
> Wats wrong

Relevant Pages

  • Re: j2ee architecture advice needed
    ... MySQL tables are not transactional. ... transactions. ... You might want to look at the upcomming EJB 2.1 Web Services, ... > utilize stateless session beans, ...
    (comp.lang.java.programmer)
  • Re: Waiting for smon to disable tx recovery. 9i on unix.
    ... away in a trial and error manner like so many others that I work ... I just waited for the database to shut down. ... Check transactions by user, selecting fields with: ... If a user session attempts ...
    (comp.databases.oracle.server)
  • Re: Managing concurrency due to multiple submits
    ... transactions are the most reliable way to ... session handlers don't guarantee exclusive session access, ... PHP script which would not get aborted by the second click do to my ... as "processed" in the session data, so that the second script can ...
    (comp.lang.php)
  • Re: readlock=exclusive
    ... set lockmode session where readlock=nolock ... set lockmode on systable where readlock=exclusive ... we are still getting dup numbers on the ingres client side (see below ... isolation levels (unless there are other transactions that we're not seeing ...
    (comp.databases.ingres)
  • Re: Thread safety and performance
    ... > My opinion is that one session per thread is the way to go. ... If you design it with speed in mind, executing commands ... So you feel that prepared commands are more efficient than rowsets. ... figure out how to reuse prepared commands under transactions. ...
    (microsoft.public.data.oledb)