bobbijolay

dbtune and disk configuration

Discussion created by bobbijolay on Apr 25, 2014
Latest reply on Apr 25, 2014 by vangelo-esristaff
I have combed through the help and many of the posts here and seem to be getting conflicting info, so I'm just trying to clarify.  Apologies if this is a repeat. 

We are moving to a new server: SQL Server 2012.  Planning to use direct connections but installed the SDE command line tools in order to optimize using dbtune before moving / loading data.

Given this from the help:
The suggested SQL Server optimal configuration is as follows:
�?� DISK 0�??SQL Server/Application software
�?� DISK 1�??master, model, msdb
�?� DISK 2�??tempdb
�?� DISK 3�??Log files
�?� DISK 4�??Feature data tables
�?� DISK 5�??Spatial index data tables
�?� DISK 6�??Attribute data/Business tables
�?� DISK 7�??SQL Server indexes


I came up with file groups and have developed keywords accordingly in dbtune.  They correspond thusly (minus blk_storage):

DISK 7:
S_STORAGE

DISK 6
RAS_STORAGE
AUX_STORAGE
BND_STORAGE
B_STORAGE

DISK 4
F_STORAGE
A_STORAGE
D_STORAGE

DISK 3
LD_STORAGE
LF_STORAGE

Is this really that simple?  It seems like I'm missing something (a lot of somethings) here.  Also, I've read that we really only need to be concerned with the STORAGE parameters of dbtune, but in the above configuration is it okay to accept the defaults for everything else (indexes etc.)?

Outcomes