Sir, with raid 10 with enough arrays to hold files saperately.
Is an array of raid 10 will be identified as one logical drive? such as c:, d: e.t.c.
Actually I want to store trace files on server to capture representative workload for DB Tuning with DTA. As i know that will be very large in size as my OLTP DB gets very busy at 8 a.m. to 7 p.m. and less busy at diff. time and i don't want any event
to be missed out due to lack of resources. So how to manage this?
Can i attach ext. HD to the dedicated sql server to hold .trc files? Is it advisable?
Pl provide any available link for config. best practices for raid 10. Or standard config. for raid 10 to get optimum performance. Or any suggestion regarding this issue.
Thanks in advance
View Complete Post