question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

datafiles and logfiles on same disk, but it's on a SAN

Hi, You'll see this check often (even in sp_blitz): "Datafiles and Logfiles areon the same disk." However, SQL (Windows) doesn't know this drive is stored on a expensive SAN, with lots of caching. So can we ignore this message in this case? Or are there any pitfalls? Is windows in this case the problem? (thread limitation?)
storagedisk-iorecommendationsan
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
Look at Brent Ozars SAN Storage Best Practices for SQL Server: http://www.brentozar.com/sql/sql-server-san-best-practices/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.