GilaMonster (7/22/2014)
No, of course not. If that was the case, how would a restore ever work for a database larger than physical memory?They're buffers, in the normal computer science definition of the word (http://en.wikipedia.org/wiki/Data_buffer). There's nothing fancy or unique about them, they are simple buffers, the buffercount defines how many are and the buffersize defines how big they are.
I guess I thought of it more as a pass through/middleman. So, increasing the amount of buffers and size is like increasing the lines open at an amusement park? More lines=more people in a shorter amount of time? Of course... if there are to many lines, the entry way can get crowded. Am I close?
Jared
CE - Microsoft