SELECT
  GETDATE() as now,
  DATEDIFF(SECOND, transaction_begin_time, GETDATE()) as tran_elapsed_time_seconds,
  st.session_id,
  txt.text, 
at.transaction_id as [Transacton ID],
at.[name]      as [Transaction Name],
at.transaction_begin_time...

Thanks for the feedback....

But the failed logins report from the extended events session is giving logins which have not been able to login. How will creating this extended events session...

This is what I see

168138065917 3261686  443399 sleeping                  ...

• This reply was modified 1 year, 7 months ago by mtz676.

I checked this table sys.dm_tran_active_transactions and there are active transactions(Read/write)(~30 such records) where the elapsed time is between 16600 mins to 4000 mins...Is this normal ?

• This reply was modified 1 year, 7 months ago by mtz676.

I think in the higher versions of SQL 2019 ... we are able to capture CPU usage before it gets recycled from the DMV every 4 hrs. Can we do...

SQL - 471 GB

System - 512 GB

We also sometimes get these messages ""I/O requests taking longer than 15 seconds" " . Does this indicate hardware issues ?

• This reply was modified 1 year, 8 months ago by mtz676.

Data can be deleted.

All, Sure, will post what I come up with.

That works..Thanks

I would like to know the memory consumption distribution(SQL & NON-SQL) at the time the alert occurs. If it is is sql then what within sql is causing it ?...

one of our servers : memory usage is now 98%, which is above the error threshold. We keep getting this message frequently.

Hello Priyanka, This is the exact kind of warnings we receive... At least 8 extensions for file {xxxxxxxx-xxxx-3333-ffff-dddddddddd} (sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 6063) but they have not disrupted anything in particular..

These errors...

• This reply was modified 1 year, 11 months ago by mtz676.
• This reply was modified 1 year, 11 months ago by mtz676.

Can anybody advise on these errors.We get so many everyday and they are just clogging the error log.Can these be avoided ? Cleared ? Fixed ? They appear to be...

SSIS - Yes. I already do that.

But wanted to check if this can be done with Registered servers.

Can you please elaborate on this or provide any links for the same.Thanks