Perry Whittle (8/13/2012)
george sibbald (7/10/2009)
sounds to me like the basic problem is the fact the sql server i/o is shared with i/o from other types of servers. the i/o patterns for SQL are radically different to say a file server and the two should not go through the same i/o channels.you would get the biggest bang for your buck by seperating them out. that would probably give you improvements in SQL performance as well. I don't think adding more luns if the i/o is still mixed is the best option.
+1
i dont think more LUNs are the answer.
I'm with george and perry on this. After setting up a fairly large virtualized environment we ended up with sqldata, sqltempdb, sqllogs all on their own storage groups (multiple sql servers). We also had a storage group that was used for pretty much everything else.
I have a question to add to this...would separating a database into multiple files on the same storage group have much of an impact? (Not considering SAN caching capabilities like EMCs fast cache)
Why is it that people who can't take advice always insist on giving it? - James Bond, Casino Royale