Hello @Bhardwaj, Sumit
I see you already started troubleshooting the issue. Let's break them down and explore some potential solutions.
"Not Enough System Resources" error typically occurs when the system doesn't have enough CPU, memory, or I/O resources to perform the requested operation. Here are some steps you can take to troubleshoot and resolve this issue:
- Check Resource Allocation:
- CPU and Memory: Ensure your VM has sufficient CPU and memory allocated. You can use tools like Hyper-V Manager or Performance Monitor to check and adjust these settings.
- I/O Throughput: Monitor the I/O performance to ensure there are no bottlenecks. Using SSDs instead of HDDs can significantly improve performance.
- Optimize SQL Database Performance:
- Indexing: Make sure your database tables are properly indexed to improve query performance.
- Query Optimization: Optimize your queries to reduce the load on the database and system resources.
- Database Maintenance: Regularly perform maintenance tasks such as backups, index rebuilding, and updating statistics.
- Increase Resource Allocation:
- If the current allocation is insufficient, consider increasing the number of virtual CPUs, the size of the virtual hard disk, or the amount of memory allocated to the VM.
Even though you have ample free space on your drives, this error can occur due to several reasons:
- TempDB Usage:
- SQL Server uses the TempDB database for various operations. If TempDB is filling up, it can cause storage issues. Check the size and usage of TempDB and consider increasing its size or moving it to a different drive with more space.
- Ensure there are no disk quotas set that might be limiting the available space for your SQL Server operations.
- File Growth Settings:
- Check the file growth settings for your SQL Server databases. If the growth settings are too small, SQL Server might be unable to allocate space quickly enough, leading to errors
- Large log files can also consume significant space. Regularly back up and truncate log files to free up space.
By addressing these areas, you should be able to mitigate the "Not Enough System Resources" and "Not Enough Storage Space" errors. If you need more detailed guidance on any of these steps, feel free to ask!
References
Fixing "NotEnoughSystemResourcesError" in Windows VM running SQL Database
Not enough disk space error – SQLServerCentral Forums
Hope this helps. Let me know if you have any questions by tagging me in your comments.
If I have answered your question, please accept this as answer as a token of appreciation and don't forget to thumbs up for "Was it helpful"!