SQL Server Alert System: '024 - Fatal Error: Hardware Error' occurred on VM***

Ranjith Velamala 20 Reputation points
2024-09-20T06:34:03.6733333+00:00

HI Team,

I am getting below error

The operating system returned error 1450(Insufficient system resources exist to complete the requested service.) to SQL Server during a write at offset 0x00000225140000 in file 'F:\TempDB\tempdb_mssql_5.ndf'. Additional messages in the SQL Server error log and operating system error log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,841 questions
{count} votes

2 answers

Sort by: Most helpful
  1. CathyJi-MSFT 22,211 Reputation points Microsoft Vendor
    2024-09-20T07:29:20.6866667+00:00

    Hi @Ranjith Velamala,

    Please check your SQL server error log to get detail error message and share this information to us for further troubleshooting.

    Did you enable auto growth of tempDB database files?

    Please read MS document OS errors 665 and 1450 are reported for SQL Server files , try the solutions if you have the similar situation.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it.


  2. Erland Sommarskog 111.6K Reputation points MVP
    2024-09-20T21:13:16.6633333+00:00

    I have never encountered this error, but common sense tells me that it is time look into the specs of VM. It may need more resources in terms of CPU or RAM.

    Thankfully, the error is only on tempdb. Else your database might have been at stake.

    Is this a VM on-prem, or an Azure VM?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.