 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Data Warehousing / June 2005loading speed between SQL to OLAP...
Hi, I found the network transfert rate low between my 2 servers during cube processes. I have a 2Gbps network and only 2% is used during loading while I can go up to 25% during "simple" file copy. what are the performance counter to follow during the loading step of my cube? what can I do to improove this? there is any option anywhere? (in SQL or AS) thanks for your guides. Jerome. Hello J, I am not 100% sure what you need to look at as it could be many factors. I would look at SQL server first. Check what the query response time is. Using SQL profiler I would check that query is using the appropriate indexes and so forth. Once the Queries are optimised, have a look at this link as it has heaps of suggestions for managing Analysis services Servers including what to look for when considering performance. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx Also check out http://www.sql-server-performance.com/ For Analysis services and SQL server tuning tips. Hope this helps Myles Matheson Data Warehouse Architect Hello J, I am not 100% sure what you need to look at as it could be many factors. I would look at SQL server first. Check what the query response time is. Using SQL profiler I would check that query is using the appropriate indexes and so forth. Once the Queries are optimised, have a look at this link as it has heaps of suggestions for managing Analysis services Servers including what to look for when considering performance. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx Also check out http://www.sql-server-performance.com/ For Analysis services and SQL server tuning tips. Hope this helps Myles Matheson Data Warehouse Architect all my cubes are allready optimized. so, except for exceptions, the query used by AS is a simple select * from facttable without any join. > Hello J, > [quoted text clipped - 16 lines] > Myles Matheson > Data Warehouse Architect |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.