When SQL-Server request a data page it checks the in-memory
buffer cache before looking for the data page on the disk subsystem.
If the data page is found in the buffer pool, the processor will
retrieve the data and then perform the work required.
My question is what are some of the key factors I should
take into account to ensure I am setting the size of the buffer
pool? Ideal ways for buffer pool management?