September 14, 2009 at 12:17 pm
I have a sql 2005 box running an OLTP with 4 sets of RAID 10 arrays. Currently data and tempdb on one, log fiiles on another, indexes on 3rd. If this is all I have would I be better moving the tempdb to the array with the log files, i thought both of their woek was sequential
September 14, 2009 at 12:30 pm
tempdb doesn't write sequentially. The best thing you can do is separate out tempdb if it is getting used heavily.
September 14, 2009 at 12:49 pm
In our environment, we have it totally in a separate drive. If your case is the same, you should consider the same drill. Another thing to ponder is to know when your servers get a reboot. I set up a weekly reboot schedule. The reboot will take care of the "filling up" tempdb because every time your server reboots, the tempdb is emptied out.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
September 14, 2009 at 1:04 pm
rather not reboot active/passive cluster
September 14, 2009 at 1:22 pm
Why not? There should be a set schedule in every company to do this. We have Production boxes in Active/Passive but once a week, we are given a window (Saturday 10pm to next morning 6am) where there is nothing going on in the server and no clients accessing. This is when we do the reboot. In the other hand, this process also help to check the failover if it went well or not. It's actually a plus point for Clustered environment.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply