Sometimes, we get errors on our Web server or on our SQL server of ‘Too many open file handles’.
Here is the error message it throws.
Microsoft OLE DB provider for SQL SERVER error '80004005'
[DBNMPNTW] Too many open file handles.
/MyTestFolder/reports/Salesreport.asp, line 141.
It is easy to ‘fix’ the problem by restarting the server. However, we’d like to know what files are opened. We don’t know what is causing the problem.
Is there a way to find out what files (or resources) are opened on a Web Server or SQL server running on NT 4.0?
We have tried to fix this problem by increasing the physical memory (ram) on our servers. Then we tried to increase the page file size – so the page file size matched the size of the physical memory (ram). But the problem still occurred.