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 ««12

Property IsLocked is not available for Login Expand / Collapse
Posted Friday, February 21, 2014 8:04 AM



Group: General Forum Members
Last Login: Yesterday @ 11:01 PM
Points: 17,694, Visits: 15,561
I can see memory issues causing (memory dumps) blocking logins. I haven't seen it actually change a login to be expired. I guess it's not much of a reach.

The next time it happens (hopefully it doesn't happen again), you might want to also check the sys.dm_os_ring_buffers for the logon failures. You might be able to procure a bit more information.

And since you saw the memory dumps, what is your max memory setting?

Is this a VM or a physical box?

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1544013
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse