March 13, 2009 at 8:31 am
I have a sql 2005 install on a active/passive cluster attached to a SAN. Currrently I have an array set for my mdf E:, my indexes i:, translogs k:, and backups on l:. Currently I have my tempdb on e: with the MDF's which probably is not the best place (This is an OLTP db). If I had my choice I would like a separate array for the tempdb, but if not would my I: drive with the backups be the best place. This drive is utilized mostly at nite when I do my litespeed backups with the client use is way down
March 13, 2009 at 8:46 am
If tempdb is your bottleneck you may want to setup tempdb on as many datafiles as CPUs you have in the box.
Datafiles should be distributed so to balance I/O -Your Systems guy may be the right person to help you by putting together a ranking of your I/O devices from most-used to less-used.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.March 13, 2009 at 8:49 am
Not really an emergecny more a best practice
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply