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

Per Johan Bijnens ...Based on the database growth rate ... extending the datafile by that number. Is this the easiest way to avoid these alerts proactively.

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

Is there a workaround this issue instead of the below suggestion .

https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-17832-database-engine-error?view=sql-server-ver16

We have 1000's of systems in our domain.

Yes, never in percentages.

Can we track database growth rates over a period of time and then extend datafiles (before autogrowth happens) based on the growth rates ?