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: 236

Filed under:
|
|

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.

enter image description here

© Server Fault or respective owner

Related posts about Performance

Related posts about sql-server-2008