Navision SQL Memory Usage

Is there anyway memory allocation for NAV can be limited to free up extra resource for the normal day to day operations.

Thanks

A