Technical Notes - All Comments

re: Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned

Acius — Thu, 09 Sep 2010 04:48:19 GMT

Hi Carl,

I should have said "until the service(SSAS) is restarted".

There's a bit of metadata in the SQL relational engine on the same box but is very restricted in terms of memory. The machine is pretty much a SSAS machine.

SSAS is configured at low 65% and total 85% of memory. It's a 32GB machine and the memory and VM counters on the process rarely get beyond 5GB.

re: Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned

CarlRabeler — Thu, 09 Sep 2010 00:27:10 GMT

I would need more information. For example, is SSAS the only server app on the system, or is SQL relational engine on the same box? If so, rebooting frees memory from multiple services and this would explain your experience. You might also try changing the default process heap for memory to the Windows heap (see the Performance Guide for more information). Also, you might check to see if you have a large number of connections sitting around in a connection pool with no associated connections.

SQL Mirroring and Sharepoint « Sladescross's Blog

SQL Mirroring and Sharepoint « Sladescross's Blog — Wed, 08 Sep 2010 16:19:26 GMT

Pingback from SQL Mirroring and Sharepoint « Sladescross's Blog

Whitepaper Wednesday – Mirroring a Large Number of Databases in a Single SQL Server Instance « Adam Jorgensen – Making Business Intelligent

Mon, 06 Sep 2010 16:07:18 GMT

Pingback from Whitepaper Wednesday – Mirroring a Large Number of Databases in a Single SQL Server Instance « Adam Jorgensen – Making Business Intelligent

re: Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned

Acius — Thu, 02 Sep 2010 01:04:04 GMT

Should preallocation always be used when running Windows Server 2003?

Without memory preallocation do queries remain slow even when the load on the system has decreased? The situation we have is queries slow down over a period of time. Analysis Services doesn't recover from this until the server is restarted.

Primera Bravo Pro ? Best Printer for Cds & Dvds | DVD HOME

Primera Bravo Pro ? Best Printer for Cds & Dvds | DVD HOME — Tue, 31 Aug 2010 07:20:04 GMT

Pingback from Primera Bravo Pro ? Best Printer for Cds & Dvds | DVD HOME

re: Analysis Services Load Balancing Solution

CarlRabeler — Wed, 25 Aug 2010 16:41:28 GMT

On Page 14 of the setup guide, in section 4.1.4, it should read "“Change the property values for the connectionString properties for your environment by replacing the Server1 and Server2 placeholders with the SQL Server server names" not the Analysis Services server names

re: Excel, Cube Formulas, Analysis Services, Performance, Network Latency, and Connection Strings

StevenJ — Wed, 25 Aug 2010 07:16:38 GMT

Hi, thanks for this article. I have one question I'm doubting about and would like your input.

It seems that in this case, setting the Missing Member Errors to ignore resulted in the largest performance improvement where the network bottleneck is greatest.

Having read the important notice on the effect of the pivot table, could it be true that setting this property to ignore would have the benefits but none of the downsides if the following conditions are met?

1) Each time a pivottable/report is opened, it is constructed programatically by the object model and thus has no data is stored locally on the end user side.

2) There is no chance that while using this dynamically created report, the server dimension members change.

Thanks

Steven

Approach to SQL Performance issues « TroubleshootingSQL

Approach to SQL Performance issues « TroubleshootingSQL — Sun, 22 Aug 2010 18:26:25 GMT

Pingback from Approach to SQL Performance issues « TroubleshootingSQL

Speeding up Derived Column Transforms

SSIS Team Blog — Fri, 20 Aug 2010 15:42:35 GMT

A new technical note about splitting up transforms to increase performance has been posted on the SQLCAT

How to Speed Up SSIS Derived Columns Transformations | Henk's tech blog

How to Speed Up SSIS Derived Columns Transformations | Henk's tech blog — Fri, 20 Aug 2010 14:24:37 GMT

Pingback from How to Speed Up SSIS Derived Columns Transformations | Henk's tech blog

Twitter Trackbacks for Increasing Throughput of Pipelines by Splitting Synchronous Transformations into Multiple Tasks - Technical Notes [sqlcat.com] on Topsy.com

Fri, 20 Aug 2010 11:36:40 GMT

Pingback from Twitter Trackbacks for Increasing Throughput of Pipelines by Splitting Synchronous Transformations into Multiple Tasks - Technical Notes [sqlcat.com] on Topsy.com

Resource Monitoring | MarkTab Data Mining

Resource Monitoring | MarkTab Data Mining — Fri, 06 Aug 2010 11:04:42 GMT

Pingback from Resource Monitoring | MarkTab Data Mining

Resource Monitoring | MarkTab Data Mining

Resource Monitoring | MarkTab Data Mining — Fri, 06 Aug 2010 11:04:33 GMT

Pingback from Resource Monitoring | MarkTab Data Mining

Using Trace to Monitor and Audit Analysis Services | MarkTab Data Mining

Using Trace to Monitor and Audit Analysis Services | MarkTab Data Mining — Mon, 02 Aug 2010 11:09:12 GMT

Pingback from Using Trace to Monitor and Audit Analysis Services | MarkTab Data Mining