I have a Windows Server 2008 32 bit server running SQL server. SQL server regularly crashes and needs to be restarted. i.e. Sql replication jobs fail, timeouts are experinced by users. Once restarted, it all works fine again.
Does anyone know of any good SQL optimisation tricks that need to be added to optimise performance. In winodws 2003, I used /3gb /pae but I bellieve this has changed in windows server 2008.
Has anyone got any tips on this?