how to improve data transfert througput?

Hi,
How can I improve the communication and the data transfert betwee n 2
servers across a 1ghz LAN?
I have a data warehouse on a server and my OLAP cubes on a second server.
the data transfert never takes more then 5% of the 1gbps bandwidth
My SQL query is optimized but I have 3 tables linked
my fact table contains 40 millions of rows and its a partitioned table.
my database server has 4 proc / 4Gb ram
during the execution of the select statement my server suffer CXPACKET wait
types. I know I have an hard drive issue on the server (its a SAN).
only my tempdb database has been moved to a local non raid drive to share
the performance.
my source database is in readonly mode.
I know that I can reach more then 30% of usage of the bandwidth between the
2 servers.
but there is anything to do?
any option to change? (in sql server and/or the olap server) to improve
this.
thanks for your comments.
jerome."Jéjé" <willgart@.AAAhotmailBBB.com> wrote in message
news:uK0Bb2BoFHA.3960@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can I improve the communication and the data transfert betwee n 2
> servers across a 1ghz LAN?
> I have a data warehouse on a server and my OLAP cubes on a second server.
> the data transfert never takes more then 5% of the 1gbps bandwidth
> My SQL query is optimized but I have 3 tables linked
> my fact table contains 40 millions of rows and its a partitioned table.
> my database server has 4 proc / 4Gb ram
> during the execution of the select statement my server suffer CXPACKET
> wait types. I know I have an hard drive issue on the server (its a SAN).
> only my tempdb database has been moved to a local non raid drive to share
> the performance.
> my source database is in readonly mode.
> I know that I can reach more then 30% of usage of the bandwidth between
> the 2 servers.
> but there is anything to do?
> any option to change? (in sql server and/or the olap server) to improve
> this.
>
Which server is performing the join? If it's the OLAP server, consider
pushing the join to the source server with OPENQUERY or a remote view.
David|||the join is a simple select * from table1, table2 where table1.key =table2.key
so the query is executed in the SQL Server database on the database server.
OLAP Server = Analysis Services
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:ub1yxHCoFHA.2152@.TK2MSFTNGP14.phx.gbl...
> "Jéjé" <willgart@.AAAhotmailBBB.com> wrote in message
> news:uK0Bb2BoFHA.3960@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> How can I improve the communication and the data transfert betwee n 2
>> servers across a 1ghz LAN?
>> I have a data warehouse on a server and my OLAP cubes on a second server.
>> the data transfert never takes more then 5% of the 1gbps bandwidth
>> My SQL query is optimized but I have 3 tables linked
>> my fact table contains 40 millions of rows and its a partitioned table.
>> my database server has 4 proc / 4Gb ram
>> during the execution of the select statement my server suffer CXPACKET
>> wait types. I know I have an hard drive issue on the server (its a SAN).
>> only my tempdb database has been moved to a local non raid drive to share
>> the performance.
>> my source database is in readonly mode.
>> I know that I can reach more then 30% of usage of the bandwidth between
>> the 2 servers.
>> but there is anything to do?
>> any option to change? (in sql server and/or the olap server) to improve
>> this.
> Which server is performing the join? If it's the OLAP server, consider
> pushing the join to the source server with OPENQUERY or a remote view.
> David
>|||You might also take a look at the IO throughput which is likely the
performance bottleneck...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jéjé" <willgart@.AAAhotmailBBB.com> wrote in message
news:uK0Bb2BoFHA.3960@.TK2MSFTNGP12.phx.gbl...
> Hi,
> How can I improve the communication and the data transfert betwee n 2
> servers across a 1ghz LAN?
> I have a data warehouse on a server and my OLAP cubes on a second server.
> the data transfert never takes more then 5% of the 1gbps bandwidth
> My SQL query is optimized but I have 3 tables linked
> my fact table contains 40 millions of rows and its a partitioned table.
> my database server has 4 proc / 4Gb ram
> during the execution of the select statement my server suffer CXPACKET
> wait types. I know I have an hard drive issue on the server (its a SAN).
> only my tempdb database has been moved to a local non raid drive to share
> the performance.
> my source database is in readonly mode.
> I know that I can reach more then 30% of usage of the bandwidth between
> the 2 servers.
> but there is anything to do?
> any option to change? (in sql server and/or the olap server) to improve
> this.
> thanks for your comments.
> jerome.
>|||I know I have issue here, and I can't do anything.
I'm on a SAN.
the IT Team in charge of the SAN has not configured the system like we have
recommanded, and also there is performance issue not solved.
And we don't know if the IT team can change anything in the configuration.
I think our server is connected to the SAN through a shared system
instead-of having a dedicated communication, set of disks and controllers.
The problem appear when I read & write simultaneously. an older server from
another client perform better than this new server, but simple requests are
better on the new server (like create index or select statement)
Due to the lack of support and knowledge from this team, I have to find
other solutions.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:O2zCCIDoFHA.3960@.TK2MSFTNGP12.phx.gbl...
> You might also take a look at the IO throughput which is likely the
> performance bottleneck...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Jéjé" <willgart@.AAAhotmailBBB.com> wrote in message
> news:uK0Bb2BoFHA.3960@.TK2MSFTNGP12.phx.gbl...
>> Hi,
>> How can I improve the communication and the data transfert betwee n 2
>> servers across a 1ghz LAN?
>> I have a data warehouse on a server and my OLAP cubes on a second server.
>> the data transfert never takes more then 5% of the 1gbps bandwidth
>> My SQL query is optimized but I have 3 tables linked
>> my fact table contains 40 millions of rows and its a partitioned table.
>> my database server has 4 proc / 4Gb ram
>> during the execution of the select statement my server suffer CXPACKET
>> wait types. I know I have an hard drive issue on the server (its a SAN).
>> only my tempdb database has been moved to a local non raid drive to share
>> the performance.
>> my source database is in readonly mode.
>> I know that I can reach more then 30% of usage of the bandwidth between
>> the 2 servers.
>> but there is anything to do?
>> any option to change? (in sql server and/or the olap server) to improve
>> this.
>> thanks for your comments.
>> jerome.
>>
>

How to HIDE SQL Server on LAN?

Hi everybodyIn my web application I am using SQL Server 2000. But as we all know, its presence in the network is visible to all the clients in the network. Anybody who has SQL Server client installed and knows the password of the database would be able to access DB remotely and this is what I don't want. I want user to access my database only when they are loggedon on physically (directly) on the machine on which SQL Server is installed.Your replies are awaited.Thanks in advance.Regards,Zulfiqar Dhuka

Go to Sql Server Enterprise Manager.
1. Expand Sql Server Group.
2. Select Server Node (local)
3. Right Click Select Properties, then select Security tab.
4. Select Authentication to Windows only, then OK