What is a bind cache?

  • Interview Candidate
  • 3
  • 3001

Showing Answers 1 - 3 of 3 Answers

samala_naresh

  • Aug 13th, 2008
 

When you install Adaptive Server, it has single default data cache, with a 2K memory pool, one cache partition and a single spinlock.

To improve performance you can add data caches and bind databases or database objects to them.


use "sp_bindcache" to bind databases or database objects to a cache.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions