Buffers and performance tuning

[girreis]

Friends,


Could you explain about setting below the TDP for SQL:


3 buffers
BUFFERSIze 1024
SQLBUFFers 0
SQLBUFFERSIze 1024


What would be the ideal parameters for backup and restore?


Thank you for your attention,
Ramon

 

[Trident]

This works for me. Watch out for SQLBu*, they will consume a lot of memory.


BUFFers 8
BUFFERSIze 8192
STRIPes 2
SQLBUFFers 16
SQLBUFFERSIze 4096