.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

SQL Server 2008 R2 Analysis Services - Syncronization Speed Issues

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server
 

We are experiencing a severe performance issue when syncronizing cubes using R2. We have 2 sets of machines that we are experiencing varied performance and speed when syncronizing cubes.

Test Server Pair 1
---------------------------------- 
Dell R710, 72GB Ram, 2 drives in Raid 1 (OS), 4 drives in Raid 10 (Cube and DB Storage) - This is the source server
Dell R900, 256GB Ram, 2 Drives in Raid 1 (OS), 3 Drives in Raid 5 (Cubes & Storage) - Server recieving sync updates

These servers are running Windows 2008 R2 Enterprise and SQL Server 2008 SP1 CU9 Enterprise (64bit). The performance of the cube syncronization is slow but manageable.

Test Server Pair 2
---------------------------------- 
Dell R710, 96GB Ram, 2 drives in Raid 1 (OS), 4 drives in Raid 10 (Cube and DB Storage) - This is the source server
Dell R910, 256GB Ram, 2 Drives in Raid 1 (OS), 14 Drives in Raid 10 (Cubes & Storage) - Server recieving sync updates

These servers are running Windows 2008 R2 Enterprise and SQL Server 2008 R2 CU2 Enterprise (64bit). This pair of servers running SQL 2008 R2 syncronize very slowly.  The process about 70-80 percent slower than the first pair. Our cubes that we syncronize are very large in size (some are 500-800GB in size) and for that reason con


View Complete Post


More Related Resource Links

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

SQL Server 2008 R2 \ Analysis Services Purchasing

  
If a person wants to experience with Analysis Services (not as a trial) for his personal use, does it mean that the cheapest way is to purchase a "SQL Server Standard" license for $898?

http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx

Another option is ($2,607.55):

http://store.microsoft.com/microsoft/SQL-Server-2008-R2-Standard-Edition-32-bit-10-Client-Access-Licenses-/product/99B2882D

Is there a way to get a cheaper version of Analysis Services + SQL Server (maybe along with free versions such as "SQL Server Compact" and "SQL Server Express")?

Thanks!

Running licensed SQL Server 2008 Analysis Services with SQL Server Express editon?

  

Hi,

We have a SQL Server 2008 Standard Edition. We've also installed Analysis Services and are using cubes.

Is it possible to have the Analysis Services on another server, to take some of the load of the "relation engine" server?

Do we need a relation engine on this server? Will SQL express be sufficient for this?

 

Thank you,

Marcel


How to get database (other than AdventureWorks) to connect to SQL server 2008 Analysis services for

  

I am making a project on Data Mining, I am using the Office 2007 Excel, SQL server as a sample mining tool, i have practiced and understood using Adventure works database , but i NEED a different Database so as to connect it to analysis service and demonstrate data mining using excel in my own project, WHAT AND HOW DO I GO ABOUT IT?

thanks



2 Node Clustered SQl 2008 Sql Server Agent & Analysis Services Fail on only one node

  

Hi,

Until recently this worked ok, however now on one of the 2 nodes if I fail over SQL all of the services start, on the other node, Sql Server Agent & Analysis Services will not come on line. I have checked some of the other links suggestiing fixes but they dont seem to apply. On the Node where it fails you get an error 53 for the server agent the Analysis Services fails with Generic service 'Analysis Services' could not be brought online (with error '1060') during an attempt to open the service.  Possible causes include: the service is either not installed or the specified service name is invalid.

attached is the details from the Sql Log

2011-04-06 13:13:32.05 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
 Apr  2 2010 15:48:46
 Copyright (c) Microsoft Corporation
 Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

2011-04-06 13:13:32.05 Server      (c) Microsoft Corporation.
2011-04-06 13:13:32.05 Server      All rights reserved.
2011-04-06 13:13:32.05 Server      Server process ID is 4744.
2011-04-06 13:13:32.05 Server      System Manufacturer: 'Dell Inc.', System Model: 'PowerEdge R610'.
2011-04-06 13:

SQL Server Analysis Services 2008 and SPSS

  

Hi,

I've recently been approached to assist in some statistical analysis of customer survey data. The team doing the analysis is trained in statistical mathematics and their newest member has a wealth of experience with tools such as SPSS and Minitab. She is keen to purchase a statistical analysis tool to perform trend analysis, exception analysis, pattern analysis etc. and has asked if we have such a tool that could do the same job for a lot less dollars.

My question is, can you perform the same analysis in Analysis Services. Excel or Reporting Services as you can in purpose built statisical analysis packages? Are there models pre-built which can be added to the Microsoft tools set to assist?

TABABI


SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005

  

In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004


OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP

  

Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003


Indexing services on window server 2008 is not working with .net

  
Hi, I am useing Microsoft indexing services in windows 2008 64 bit .I am getting error like "Exception from HRESULT: 0xC0000005" while i am createing  new catlog from .net 2.0.I am using  "ciodm.dll" for adding new catlog. i am using this code for create new catelog.   Dim Admin As New CIODMLib.AdminIndexServer   Admin.AddCatalog(varContractNo, txtCatelog.Text + "\" + varContractNo) Admin.Stop() Admin.Start() AddScope(txtDocFolderPath.Text, txtSite.Text, txtCatelogname.Text)   Please help me anybody have fixed this issue on window server 2008 64 bit.  

Issues with SSIS and SQL 2008 - Integration services not running

  
Hey guys, I installed SQL 2008 with complete BI studio including Integration Services. When i check in my services - i cant see my integraiton services in there When i try to connect to Integration Service using localhost, I cant connect it And when i try to run setup of SQL 2008 - It shows that Integration Services already installed and that what i checked when i fetched my Installation tool report from SQL Server to verify i have it installed. Why can i access Integration services, if i already have it, Please suggest with ideas, checks i can make to ensure every setting is in place. Thanks. Would appreciate for quick response.  

sql server 2008 - sqlserver(mssqlserver) services can't start

  
Sorry i need help, i have instal and reinstal sql 2008 over and over but always failed the problem is the services can't start and when i cek error log this written: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024

SQL Server 2008 Install failure - Reporting Services Rule Failures

  
I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary:   Final result:                  Passed   Exit code (Decimal):           0   Exit message:                  Passed   Start time:                &n

Help!!!! Permission issue with Analysis Services on Windows 2008 R2

  
Hi I'm with a project using Sql Server 2008 on Windows Server 2008 R2. It seems I can not connect to Analysis Services server with SA acount but only with Windows Authentication (The 'Authentication' option is diabled). And when I connect to Analysis Services with my windows acount , I do not have the permission to either create a database (ERROR:Either '***' user does not have the permission to create a new object, or the object does not exist) or grant server privilege to my windows account (ERROR: Only an administrator can make changes to server properties). Also, I failed to remote connect to Analysis Services on Server with my windows account (But I can remote connect to Database engine). Any idea?  Thanks!

SQL Analysis Services 2008

  
Can any one help me for... How to create a new instance of SQL Analysis Services? I am  using SQL Server 2008. Thanks, Faheem Ahamed

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Failed to generate a user instance of SQL Server 2008 Express with Advance Services in Visual Studio

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend