SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Scope: The drastic caveat with Logon Triggers.


Scope: The drastic caveat with Logon Triggers.

Author
Message
ALZDBA
ALZDBA
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12089 Visits: 8924
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


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- 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 :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
jeffrey yao
jeffrey yao
Mr or Mrs. 500
Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)Mr or Mrs. 500 (527 reputation)

Group: General Forum Members
Points: 527 Visits: 882
Thanks for the update and appreciate your working attitude, i.e. never leave anything unsolved.



GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23379 Visits: 9730
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
ALZDBA
ALZDBA
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12089 Visits: 8924
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. w00t

Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- 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 :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search