Forum Discussion

Andy2345's avatar
Andy2345
Level 6
13 years ago
Solved

SQL 7.1

 

NUMBER OF BUFFERS PER STRIPE
TheNUMBEROFBUFFERSPERSTRIPE parameter affects buffer space availability.
This parameter is set in the NetBackupMSSQL Client interface for each operation.
NetBackup uses this parameter to decide how many buffers to allocate for reading
or writing each data stream during a backup or restore operation. By allocating
a greater number of buffers, you can affect how quickly NetBackup can send data
to the NetBackup master server.
The default value for the NUMBER OF BUFFERS PER STRIPE is 2, which allows
double buffering. You may get slightly better performance by increasing this value
to a higher value.
 
Hi ALL,
 
Can please somebody explain me what this is all about.I was reading the SQL guide and come across this.NUMBER OF BUFFERS PER STRIPE
  • NetBackup uses this parameter to decide how many buffers to allocate for reading
    or writing each data stream during a backup or restore operation.
     
    This parameter is well explained here. I can not provide better explanation than here.

5 Replies

  • NetBackup uses this parameter to decide how many buffers to allocate for reading
    or writing each data stream during a backup or restore operation.
     
    This parameter is well explained here. I can not provide better explanation than here.
  • It is an popular word in computer engineering and IT. In general, it means memory spaces revered to store data temporary.

    In this case, to backup SQL Server databases, NetBackup SQL Server agent on the client host read data from SQL Server, and transfer it to media server. Buffer is required in these operations.
     

  • NUMBER OF BUFFERS PER STRIPE -512 KB

    Then in this case data will be transferred to media server in buffer of 512 kb?