Forum Post: Re: Blocks In Database Buffers Values For Medium To Large Databases

Status
Not open for further replies.
J

Jimmer

Guest
Yes, I got your points about the "good" use of -B, and in which conditions it is really beneficial. Though, the way I see it (I may be wrong, but it is based on the fact that we repeated the exact steps while only removing/adding a "0" from the -B value) , there should have been a big sign somewhere that says something like: "Watch out, if you are running Windows 64 bit (at least 2008 R2), and if you increase the -B to a certain point, it will cause a degradation of performance (not only it won't be beneficial), irrespective if you have enough free RAM on the server or not." By the way, it is not a virtual environment. Thanks for all the valuable replies and for your time. Regards, JM

Continue reading...
 
Status
Not open for further replies.
Top