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

Juicy bits:

- SQL Server 2008 R2 x64

- 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: ) 

- Active/passive cluster

- Oracle client 11gR1

- "Allow Inprocess" provider option is enabled

I'm stumped.  Our development, QA and UAT environments are all running the same versions of Windows, SQL, and Oracle client.  Linked server between SQL and Oracle works just fine.

Production is clustered.  The linked server works just fine on one node of the cluster, but if we failover to the other node, attempts to use the linked server in any way, OPENQUERY, GUI, etc..., cause the following error:

OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE" returned message "ORA-12634: Memory allocation failed".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLE".

What am I missing?  I've reinstalled the Oracle client on the defective node, verified that the SQL Server service account has full rights to the Oracle client dir

We have tried to run a SQL job for SSIS Package. But it failed during the execution with the error "[364] The Messenger service has not been started - NetSend notifications will not be sent". But in the job, no notifications have been configured and in windows server 2008/Windows-7 there is no messenger service at all.

When we search for the the messenger service in windows 7/windows server 2008, we found that service is not in both the OS and it was replaced by msg.exe. 

Any help or workaround would be appreciated.

Thanks in advance.

PS: The normal SQL jobs other than SSIS are working fine without any error.

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

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

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

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

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

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