How to configure SQL Server with SAN

We have 5 SQL servers and plan to use Dell SAN data storage. We try to
figure out how to configure the data, log, temp db drivers so that we
have a better performance.
1. Should we seperate the data, log, and temp db into three different
drivers?
2. What RAID level will be best for each of them?
3. Also, we use linked servers among different SQL Servers, the
performance using the linked servers is bad. Are there any better way
to configure it or avoid using linked server to improve the performance
when we use SAN?
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Data and log should be on separate LUN and RAID sets, preferably on
different processor engines by default. Tempdb is just another database for
this purpose. I disagree with Joe and suggest maximum RAM in the SAN with
much of it configured as write cache. My experience suggests that you will
maximize overall performance that way, but that does depend on the nature of
your application and data.
RAID-10 is best, but expensive. If you must lower costs, use RAID5 for data
and RAID10 for logs.
Linked server performance is bad because the remote server often has to dump
entire tables across the link. Try using OPENQUERY with search arguments so
the result set coming across the link is smaller. Another option is to
purchase larger host servers and consolidate your databases onto fewer
systems, thus turning your remote query into a simple cross-database query.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"cindy huang" <cindyxqhuang@.hotmail.com> wrote in message
news:uERj2GmbDHA.616@.TK2MSFTNGP11.phx.gbl...
> We have 5 SQL servers and plan to use Dell SAN data storage. We try to
> figure out how to configure the data, log, temp db drivers so that we
> have a better performance.
> 1. Should we seperate the data, log, and temp db into three different
> drivers?
> 2. What RAID level will be best for each of them?
> 3. Also, we use linked servers among different SQL Servers, the
> performance using the linked servers is bad. Are there any better way
> to configure it or avoid using linked server to improve the performance
> when we use SAN?
> Thanks
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||test the disk system performance with IOmeter from
http://sourceforge.net/
opinions are many, actual results are better
>--Original Message--
>We have 5 SQL servers and plan to use Dell SAN data
storage. We try to
>figure out how to configure the data, log, temp db
drivers so that we
>have a better performance.
>1. Should we seperate the data, log, and temp db into
three different
>drivers?
>2. What RAID level will be best for each of them?
>3. Also, we use linked servers among different SQL
Servers, the
>performance using the linked servers is bad. Are there
any better way
>to configure it or avoid using linked server to improve
the performance
>when we use SAN?
>Thanks
>
>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>