Video Screencast Help

SQL 7.1

Created: 09 Oct 2012 • Updated: 10 Oct 2012 | 5 comments
This issue has been solved. See solution.

 

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

Comments 5 CommentsJump to latest comment

Yasuhisa Ishikawa's picture
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.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

SOLUTION
Marianne's picture

Totally agree with Yasuhisa.

If this was my environment, I would be more concerned about the fact that SQL 7.1 is no longer supported.

See MASTER Compatibility list: http://www.symantec.com/docs/TECH59978

 

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Andy2345's picture

With buffers,what does it exactly means?

Yasuhisa Ishikawa's picture

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.
 

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Andy2345's picture

NUMBER OF BUFFERS PER STRIPE -512 KB

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