Is there any rule of thumb for working out how much memory dbvalid needs for a given size of database. Is it affected by the type of check (eg Express or Full) and whether the process is read only?
In this particular case the database is about 500GB
Thanks
I don't know, and according to Mark's older answer, it depends:
Need suggestions for hardware on an integrity check platform
But the following statement might raise some concerns for such a big database... :/
If you size the amount of cache for the server to be at least the size of the database then you will likely be close to optimizing the amount memory allocated to the server.
FWIW, that is primarily a test on my part how hard it is now to search for migrated Forum contents..., here via "validate database memory usage site:sqlanywhere-forum.sap.com"
Yes - that's the impression I get - for best performance have a cache big enough for the whole DB, or maybe for the biggest table + all its indexes and keys.
The question the client is looking at is what is the minimum they need, as there are validating a copy and aren't too worried about how long it takes. Their problem is that they are using Azure VMs that cost much more for lots of RAM that they are only using occasionally.
Well, that would be a suituation for very-short-time provisioning - just be able to use more cloud resources than usual for short tasks...
