December 5, 2006 at 9:55 am
While running the following t-sql script,
EXEC master..xp_loginconfig 'audit level', the error message below is returned. It appears to occur for any system sproc where the listed DLL needs to be loaded, and thus the sprocs does not run. If you attempt to click on Properties in EM to check the Audit Level, you will receive the same error.
ODBC: Msg 0, Level 16, State 1
Cannot load the DLL xplog70.dll, or one of the DLLs it references. Reason: 8(Not enough storage is available to process this command.). If I run master..xp_cmdshell 'dir c:\*.*', I got the same error.
I have checked space and there appears to be plenty. I have checked the Microsoft KB and do not get sufficient info. Does anyone have any ideas as to why this is occurring?
Any input will be greatly appreciated.
December 5, 2006 at 2:58 pm
This is usally a memory issue not drive space. I have seen this on one of our heavily used servers numerous times until we redid several queries that were putting the loads on the system.
Do one of the following, then retry the command: (1) reduce the number of running programs; (2) remove unwanted files from the disk the paging file is on and restart the system; (3) check the paging file disk for an I/O error; or (4) install additional memory in your system. Do one of the following, then retry the command: (1) reduce the number of running programs; (2) remove unwanted files from the disk the paging file is on and restart the system; (3) check the paging file disk for an I/O error; or (4) install additional memory in your system.
December 5, 2006 at 5:11 pm
If it is memory issue then it might be MemToLeave memory which 256 MB by default...
All extended procedure, com objects and linked server calls uses MemToLeave memory...
Only the option is to resolve this issue is restarting the sql service...
You can increase this memory using -G switch ...
http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk
MohammedU
Microsoft SQL Server MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply