Recycle Pool Tuning Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Recycle Pool Tuning Question

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    80
    Trying to size recycle pool properly. Test for size involves assigning object to recycle pool, and running SQL statements against it, ...then doing the same thing with the object in default pool, ...and compare the number of physical reads for each pool.
    My question is this. Say the number of physical reads is higher for the recycle pool. Should I size it larger or smaller. Two books I have give directly conflicting answers on this.

    Thanks
    John Doyle

  2. #2
    Join Date
    Oct 2000
    Posts
    80
    Anybody on this?
    John Doyle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width