Ajit, When you double click on a parameter in Database Manager you get an elaborate description of parameter meaning.
DATA_CACHE - DM says MAXUSERTASKS * 10 => 5000 is your initial choice. MAX_CPU => 2 let the system scheduler do its job. MAX_LOCKS - This is something strange for me, because db params says 2680 and Information > Locks says 10500, I suggest wathing what happends. MAX_USER_TASKS - As you said. RESERVED_REDO_SIZE - I would leave the default. >I am aware that setting the devspaces to different physical devices can increase performance. >Are there any guidelines for this? Minimum is to put data and log to separate drives. >Would it be better to have multiple small data devspaces than >one large one if they are on the same physical device? No. --- The general idea of performance tuning is that first you measure and then adjust parameters appropriately. BTW. What apps are you using that will make 500 simultaneous connections? Pure C/S model? Regards, Wojtek _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
