Unanswered: URGENT - how to determine procedure cache size
Hi folks -hope you can help me. I need to determine the size of the procedure cache to set on a new server that I've recently set up. The default is 3271 2K memory pages. The performance and tuning manual suggests that it should be the max. no of concurrent users * size of the largest plan * 1.25. How do I find out the size of the largest plan? I don't want to allocate too much memory to the procedure cache only for it to cause problems elsewhere.