I would also check ring_buffer  & default trace for login failed events

RING_BUFFER

https://www.johnsansom.com/using-sys-dm_os_ring_buffers-troubleshoot-connectivity-issues/

Default trace:

SELECT TOP 100 te.name
,ft.SPID
,ft.LoginName
,ft.Hostname
,ft.ClientProcessID
,ft.DatabaseName
--,ft.FileName
,ft.StartTime
,dateadd(ms, ft.Duration / 1000, ft.StartTime) [FinishTime]
,ft.ApplicationName
--,ft.ObjectID
--,ft.Duration / 1000 / 1000...

Thanks Dino. I know what your saying. Still we need to get more details from the client.

I don't see any issue from the sql server side.

Even my suspicion is with...

Thank you Rick.

Thanks Jeff.

Thanks everyone for sharing your thoughts.

Thanks Srikanth.

If I am doing the OFFLINE rebuild ( which default behaviour) will the locks will held for the entire duration of the rebuild operation?

Thank you John.

Thanks all for the inputs. Will do some testing in my environment before I come to any conclusion.

Thank you Sir. will go through it.

For some reason , those queries doesn't give me what is expected. it doesn't show up the spid as well.

Basically, if I try to open a new ssms session and...

Thanks a lot Jeff.

The issue is resolved. It took some time but it lowered the memory usage.Not sure if CHECKPOINT is writing to disk at that time.

Hi Jeff,

Thanks a lot of the reply. I have a followup question. Kindly advice.

Suppose, if a person is hired as a new DBA, and she/he doesn't have any clue of...

Thanks Andrew. I will work with the developer.