Trying to list down the 10 largest files across all drives from all servers.

Hello Phil, Did as advised. Not working.same error

Thanks for the response..

how do we check what you recommended ?

https://www.sqlservercentral.com/blogs/quick-tip-wmi-alerts-and-sql-server-agent-permissions..

Let me check and get back...

But the query captures data from 100+servers...so how does this work...check on all...

• This reply was modified 11 months ago by  mtz676.

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 11 months, 1 week 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 11 months, 1 week 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 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, 3 months ago by  mtz676.
• This reply was modified 1 year, 3 months ago by  mtz676.