Activity overview
Latest activity by isaacmcn
Thanks for your help Pete, we will look at implementing your recommendations and see if that resolves the problem.
Cheers,
Isaac / comments
Thanks for your help Pete, we will look at implementing your recommendations and see if that resolves the problem.
Cheers,
Isaac
Hi Pete, thanks for the response.
A couple of thoughts:
1. I didn't realise that more than 4GB was recommended when using 64bit OS and 64bit Sql. Is that a general recommendation, or suggested when also running Redgate Sqlbackup?
2. I had wondered about specifying the max memory setting in Sql, I always thought that Sql would release memory to the OS as required but further reading suggests this is only the case if the OS is desparate. Just a question about Redgate Sql Backup then - how much memory does the SQBCoreService require separate from the SqlServer service? Looking at perfmon I'd guess that the SQBCoreService is doing the compression/encryption of backups and writing to disk, so would it pay to dial Sql's max memory back to leave space for SQBCoreService? (e.g. if we bump the physical mem up to 6GB then specify Sql's max memory as 5GB would that be sufficient)
3. Regarding memory fragmentation - is the memory it's trying to use internal or external to Sql (i.e. are we concerned about Sql's memory being fragmented or the OS's?)
4. We have another server running SqlBackup on much larger databases and haven't hit the same problem. It doesn't have the max memory setting configured, but has 8GB ram. Is it just the fact that it has more physical memory that it doesn't have the same problem?
Thanks again for your help
Isaac / comments
Hi Pete, thanks for the response.
A couple of thoughts:
1. I didn't realise that more than 4GB was recommended when using 64bit OS and 64bit Sql. Is that a general recommendation, or suggested when...
Sql backup occasionally fails with memory errors
Hi there,
We are having a problem with our Redgate transaction log backup process with it occasionally erroring with various memory related issues
Error: 802, Severity: 17, State: 20. (Params:). Th...