Red Gate forums :: View topic - Access Problems caused by memory issues
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Access Problems caused by memory issues

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Tue Jul 24, 2012 4:37 pm    Post subject: Access Problems caused by memory issues Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Wed Jul 25, 2012 5:43 pm    Post subject: Reply with quote

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

Code:
EXEC master..sqbmemory

it should give you an overview of the SQL Server memory details. There are probably DMVs' that can give you a more detailed picture of how the memory is being used by the SQL Server process.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Wed Jul 25, 2012 6:06 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group