You want to improve the data access performance for your SAP database <SID> and also to avoid its deterioration in future. Which is the best strategy?

Question

Options

• AUse as many data files as there are CPUs dedicated to the SQL Server.
• BUse as many data files as there are CPUs on the database host.
• CWhen the database is growing, regularly create new data files for new data to avoid uncontrolled
• DKeep number of data files of the SAP database and of the tempdb database approximately equal.

• A
  79% (23)
• B
  10% (3)
• C
  7% (2)
• D
  3% (1)

No community discussion yet for this question.