Seperate data and log files for system databases

[jonwolds]

Hi,

Is it worth moving the system database data and log files from the default location on the c:drive to the disks set up specifically for sql server data and log files?

Thanks
Jon

 

[Catadmin]

Depends on whether or not you have a lot of room on C: for the TempDB to grow as needed. If you only have a couple of GBs, then yes, it is well worth it. TempDB can consume a LOT of space when doing heavy queries or transactions.

We usually don't stick our system DBs on the C: drive because we partition C: so small specifically only for OS files and then stick everything else on a SAN. We also now keep all System data & log files on their own drive, and have a separate drive for UserDB data files and a separate drive for UserDB log files. It's quite efficient. @=)



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[jonwolds]

Thanks. I'm going to move them.

If you are interested in this topic please also refer to:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=308628

Jon

 

[mrdenny]

Here is an FAQ on setting up the disks for a SQL Server faq962-5747.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com