Rebuild Index job is causing all memory to be used up.
Hi All Can anyone please provide any suggestions for setting maximum Server Memory? or my task settings to help alleviate the following issues? I have a Rebuild Index task with following settings: All User databases Reorganise pages with default amount of free space. Both sort results in tempdb and keep index online are off. Things begin to go bad about 40 minutes into this task. As it uses up most of the memory, applications can't connect. I've even had one of the databases left in the state where it could not be connected to even from ssms with sa credentials. For example I found this log: MemoryLoad 96% TotalPhysical = 20479MB Available Physical 667MB Total Page File 40957MB My maximum server memory setting was the default value (exceeding the actual server memory) Tasks are run away from any backups at times of low usage. Regards
HI, server memory: right click on your server go to: Server Properties -> Memory: here you tell seql server how much memory to allocate to SQL from OS. Dion't reorganize all ine one, make steps so you can free the ldf. What recovery mode are you in? If in Full or Bulk, do you take log backups?