Access Problems caused by memory issues

[ChrisAVWood]

This is on a W2K3R2 SQL2005 32_bit server currently running 6.5.2.9 moving to 7.1 shortly.

We believe that this is a process that must be leaking memory causing this so I just want to confirm.

It starts off with a backup job thats fails with a VDI 1010 error that throws an SQL error 3013 followed by an SQL error 18210 BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_4A05EA30-4CCE-4FE8-8817-CBA59951F70C'. Operating system error 0x800705aa(error not found).
This gets followed by another backup job failing with SQL error 18452: Login failed for user ''. The user is not associated with a trusted SQL Server connection. or with SQL error -2147467259: Cannot generate SSPI context and SQL error -2146893056: SQL Network Interfaces: Not enough memory is available to complete this request.

This only started to happen last week when we believe a new process was introduced that could be leaking memory.

I am hoping I have provided enough info that my memory concern can be confirmed.

Thanks

Chris
_________________
English DBA living in CANADA

[petey]

The error messages seem to suggest an issue with the SQL Server memory space. If you run

[ChrisAVWood]

Thanks Pete.

I was running jobs that looked at the VAS but this was not the problem. Now I have added the sqbmemory check as well and look for situations where the memory goes low.

This is happening every day but at random times so I am unsure what is causing the problems.

Chris
_________________
English DBA living in CANADA