Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Scope: The drastic caveat with Logon Triggers. Expand / Collapse
Author
Message
Posted Tuesday, January 13, 2009 6:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:47 AM
Points: 7,005, Visits: 8,451
Feedback:

I've upgraded the dev servers to SP3 and got the approval to re-test it in cooperation with one of our biztalk devs.

After I activated the "old" logon trigger again, the issue no longer occurred.

So I guess it may have been related to the bug and fix mentioned earlier.

After the test I removed the logon trigger, because the proper way of handling this is asynchronously.

The lessons learned still apply !


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #635319
Posted Tuesday, January 13, 2009 11:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 1:34 PM
Points: 228, Visits: 703
Thanks for the update and appreciate your working attitude, i.e. never leave anything unsolved.


Post #635687
Posted Tuesday, January 4, 2011 6:45 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Event notification works. I use a server-side trace for login events to get the same sort of data, mainly just because I've been doing that for eons at this point and am comfortable with it.

Definitely a good article.

Another thing to keep in mind, that was mentioned in the article, but I didn't see anything in the dicussion on it: Don't rely on people in testing. I use traces of real activity to make sure things like this won't have unintended consequences.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1042348
Posted Thursday, January 6, 2011 12:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:47 AM
Points: 7,005, Visits: 8,451
Thank you for you comment.

I need to add 2 comments to the article:

1) You need to setup queue monitoring !
If things fail, your server may blow up really fast, depending on the number of logins occuring.
msdb may grow, or the db where you defined your queues


2) Until now, SSB did freeze on 4 of our +200 instances.
Mostly the reason was the query on the queue received a "insufficient memory to complete the query" notification, causing the sproc to fail. Queue blew up, until disk got full !
If was a hell of a job to analyse the root cause and to clean it up.
I needed to beg for more ram on these very small systems, but they got fixed

In a single case, the sproc was just to slow to cope with the queue load. After the modification to using the checksum column, things are running smoothly.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1043509
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse