Does splitting out Data, Logs, and TempDB matter using a SAN with SQL 2008
Posted
by
MVCylon
on Server Fault
See other posts from Server Fault
or by MVCylon
Published on 2012-10-01T13:25:27Z
Indexed on
2012/10/01
15:41 UTC
Read the original article
Hit count: 264
I'm not a server admin. So be gentle. But I was just at a conference and in one of the training classes the Instructor explained some SQL DBA best practices. One of which was to separate out Mdf,Ldf, and TempDB onto different drives to increase performance.
Now at our office we have a san. The Sys Admins created 3 san drives one for data, one for Logs, and one for TempDB.
My intuition tells me that was a wasted effort...was it?
I don't know alot of the details, but if you ask i'll try to fill in any specs needed to answer this question accurately.
© Server Fault or respective owner