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!
>.
>

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!
>.
>

How to configure bidirectional replication

In a MSCS SQL 2000 SP3 cluster environment I plan on implementing
transactional replication. Distributor and publisher are on the same server
(quad processor machine). I Intent to publish a relatively small db (@. 60
articles) to a subscriber in a remote SQL Server cluster and would like to
have updates made to subscribers also replicated back to publisher. I
understand bidirectional replication is not supported by the replication
wizard in enterprise manager. How can that be achieved?
For starters, this article may help:
http://support.microsoft.com/default...75&Product=sql
There's also an article on this subject in SQL Server Magazine
(www.sqlmag.com) by Bren Newman, ArticleID 42858.
"Cesar" wrote:

> In a MSCS SQL 2000 SP3 cluster environment I plan on implementing
> transactional replication. Distributor and publisher are on the same server
> (quad processor machine). I Intent to publish a relatively small db (@. 60
> articles) to a subscriber in a remote SQL Server cluster and would like to
> have updates made to subscribers also replicated back to publisher. I
> understand bidirectional replication is not supported by the replication
> wizard in enterprise manager. How can that be achieved?
>
>

How to configure a job for maintenance plan?

hello, everyone:
I have a maintenane plan to backup user database daily, How to configure a job to execute this plan daily? Thanks
zytLook up SQLMAINT or XP_SQLMAINT in BOL, depending on whether you want to run the job as OS command or T-SQL, respectively.