Not Thinking it through - the saga continues
The saga continues ………..
Here below are the previous posts which relate to the management of a production SQL Server ( by a third party ). We asked that the job which re-indexes the database be disabled until such time as the issue of the database mode was resolved .. sadly the backup job was disabled instead so not only did we get left with no recovery point after the index rebuild but we didn’t get any backups either.
A quick phone call and the job was re-enabled, however we had imagined that a slip of the mouse in EM had caused the wrong job to be disabled – but no – the schedule had also been disabled so although the backup job has been re-enabled the schedule has not, so still no backups and three days on the situation is unchanged.
We also did a memory upgrade, I provided the process and scripts to enable the extra memory, sadly the change to the memory script was not run so the o/s has had 13Gb of ram all to itself for the last week or so, it’s almost a 7 x 24 app on a cluster so we can’t just take the system down when we want. When changing the amount of awe memory used a service restart is required for the change to take effect. I’d also previously had a discussion about using dynamic memory settings with awe ( you can’t – it doesn’t work that way ). SQL Server is now happily using the extra memory and I’m monitoring to see what impact it has had, we’ve gone from 11Gb to 22Gb, so technically the entire database should be able to be held in memory. Some initial stats indicate decreased reads and increased writes but it’s early days and sadly the cluster failed over around 12 hours after the memory change so I’m still waiting for things to stabilise.
http://sqlblogcasts.com/blogs/grumpyolddba/archive/2006/11/30/not-thinking-it-through.aspx
http://sqlblogcasts.com/blogs/grumpyolddba/archive/2006/11/30/how-much-memory.aspx
http://sqlblogcasts.com/blogs/grumpyolddba/archive/2006/12/04/not-thinking-it-through-part-2.aspx
http://sqlblogcasts.com/blogs/grumpyolddba/archive/2006/12/11/not-thinking-it-through-part-3.aspx
http://sqlblogcasts.com/blogs/grumpyolddba/archive/2006/12/22/not-thinking-it-through-the-end-maybe.aspx