October 23, 2009 at 11:19 am
We just obtained a high capacity SAN. Now my boss wants me to move our SQL 2005 database tables from our database server and store them there. He wants to use the database server as a "front end".
Does that make sense? Should I maintain the log files on the database server or move them to the SAN as well?
Thanks for any guidance.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 23, 2009 at 11:34 am
I'm pretty used to having the data and log files on a SAN. The executables are usually installed locally, but that's pretty much it.
One thing to watch out for is that SQL 2005 sets up a default trace that runs in the installation folders. It doesn't usually take up a lot of drive space, but make sure you account for it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 23, 2009 at 11:53 am
Yes, put the logs on the san. When a SAN is available it is not uncommon to put the database files (data and log) onto the SAN and leave the executables on the Local Drive.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 23, 2009 at 12:14 pm
Since we are on this topic, should the system databases also go on the SAN?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 23, 2009 at 12:21 pm
Yes
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 23, 2009 at 12:23 pm
Thanks! Have a pleasant weekend.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply