Just wondering if anyone has any experience with having 2 or more instances of SQL Server in a machine, then having some sort of a process that would dynamically control how much memory each instance is given.
Example: Machine has 30 G of RAM. There are two instances, instance A normally does big jobs, so it has 20 G allocated. Instance B has 5 G allocated.
On a given day, A is relatively idle, waiting for a big job. But B is given a large job and is maxed out at its 5 G. Would be nice to dynamically allocate some of the RAM to B for the duration or job.
I can see writing some code to do this, but I wanted to see if anyone thinks this is even feasible.
Thanks
Paul
- Paul
http://paulpaivasql.blogspot.com/