How To – Configure T-Log Location | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How To – Configure T-Log Location

Hi All, I’ve read 1000 times that to enhance performance and recovery, the T-Logs can be placed on a seperate RAID 1 mirror, from the data disk. I have a SAN and have allocated a mirror set for this purpose. I’m running a SQL 2000 cluster, and would like to have my T-Logs located on the seperate mirror. My question is: HOW? How and when does one tell SQL to use the seperate disk array for the transaction logs? I don’t see an option to do so during setup. When I go to the properties of the server, once installed, and try to change the default location for new databases, I don’t get the option for the mirrored drive either, only the data disk that was established during setup. Can someone please tell me how this is accomplished? Thank you very much. Ren
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071 MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
REefer to the KBA listed by Derrick and while designing the database you must provide the path for data & log file in order to use different paths. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
i suggest the use of Solid State Disks for the TLog, if you really want to make your Oltp, fly
And have a lot of money. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
A lot of money is a relative term, due to the performance gains. some links : http://www.texmemsys.com/files/f000174.pdf
http://www.dynamicsolutions.com/disk_sys_ssd.htm#2100
about the money, like any other thing, you must search and compare you could find, since 500$ per GB to 4000$ per GB, there is a wide range,
from 133MBxsec (PCI slot models) transfers to 40MB (SCSI) in some solutions, you buy the memory yourself, this can get the prices, lower

]]>