Implications of JET_paramMaxInstances?

Apr 17, 2011 at 5:48 AM

I am providing users with the ability to create multiple dbs in the same process and I run into the TooManyInstances error.

I know that I can solve the error with JET_paramMaxInstances, but I would like to know what are the implications of doing so are.

Apr 17, 2011 at 7:40 AM

Setting the instance count higher will use a bit more memory, but mostly increases the internal quota for allocated objects. It is common for some server applications to have 40-50 instances in the same process. Each instance has its own logfiles, checkpoint and temporary database so you need to make sure they all go in separate directories.

Apr 17, 2011 at 8:47 AM

So the only impact is that it will uses more memory?

Apr 17, 2011 at 11:37 PM

Yes