SQL Server configuration

K

kl

Does anyone have suggestions for optimizing SQL Server
performance for MS Project Server?
For example: recommended sizing for tempdb, Project
database & log files, open objects, memory, etc etc.
We need to tweak until we can get a new server.
Thanks.
 
R

Ralphy

One big performance tweak is to set the recovery model to Simple. Project
is not a true transactional database so the logs are useless anyway also
move the logs to a separate spindle preferably a RAID 1 config. Chuck as
much memory as you can at it. We set our db to automatically grow which
appears to work well.

--

Ralphy
_______________________________________________________________
Please do not reply to me personally, this mailbox is not monitored


Does anyone have suggestions for optimizing SQL Server
performance for MS Project Server?
For example: recommended sizing for tempdb, Project
database & log files, open objects, memory, etc etc.
We need to tweak until we can get a new server.
Thanks.
 
K

KL

Thanks, Ralphy. Have you fiddled with tempdb size as
this thing makes use of so many temp tables and cursors?
 
Top