Browse Blog Posts by Tags

All Tags » SQL Server » Analysis Services (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Proactive caching for Analysis Services databases - performance techniques and better usage

By default SQL Server has a pool of memory that is used to store both execution plans and data buffers. This pool of memory is managed by default within Analysis Services for SQL Server and such percentage of the pool allocated to either execution plans...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, May 31 2009
Filed under: Filed under: sql server, performance, data, cache, best practices, cube, Analysis Services, rolap, molap, proactive, advantage
SQL Server 2008 Analysis Services performance guide - process to go over

SQL Server 2008 is on full-fledge now and I haven't had a chance to look at Analysis Services part of it, recently had an opportunity to go through to convene a proof of concept project at work place. As the documentation refers this version of Analysis...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Nov 27 2008
Filed under: Filed under: sql server, performance, mdx, monitoring, resources, Analysis Services
Analysis Service error: Either the user, Domain\User, does not have access to the Database Name database, or the database does not exist.

As it seems the error text on the subject looks familiar when you have installed SQL Server or working with SQL Server databases. How about getting the error on Analysis Services databases (OLAP) within your BI Platform. So in the case of handling the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jul 10 2008
Filed under: Filed under: sql server, security, services, Analysis Services, data providers, impersonation
SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)

Scalability is an important aspect in every application, a common achievement within OLTP environment and still applicable to OLAP (Anlaysis Services) environment. In any if the application or a cube or mining model may be unavailable for querying because...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, May 2 2008
Filed under: Filed under: sql server, performance, ssas, features, 2008, whitepaper, Analysis Services, scalability
SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services Read...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Feb 18 2008
Filed under: Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose
SQL Server Analysis Services MDX Query performance monitoring - highlights

When it comes to monitor the query performance whether it is TSQL or MDX, the process is similar. You need to have a better understanding on how queries are executed (architecture), what tools are available for monitoring and best practices to improve...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 29 2008
Filed under: Filed under: sql server, performance, mdx, query, best practices, tsql, monitoring, Analysis Services, baseline, benchmarking
SQL Server Analysis Services slicing and dicing

I was going through Books Online in learning the concepts of slicing of data within Analysis Services for the new project that is upcoming, all these years I have basic knowledge of SSAS and with latest available features in SQL Server 2005 Analysis Services...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Jan 27 2008
Filed under: Filed under: sql server, performance, data mining, 2005, Analysis Services, slicing
SQL Server 2005 Best Practices Analyzer January 2008 update

Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jan 25 2008
Filed under: Filed under: sql server, microsoft, download, best practices, 2008, ctp, analyzer, 2005, Analysis Services, extent, rtm
New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 2 2008
Filed under: Filed under: sql server, performance, msdn, bi, download, optimization, whitepaper, Analysis Services, sqlcat
How to find which version of Analysis Services you are running?

Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when connected to that SQL Server instance. What if to know same for the Analysis Services components, we don't have such an easy way to find out!...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Nov 5 2007
Filed under: Filed under: sql server, databases, microsoft, integration, ssis, ssas, version, Analysis Services
"Provider cannot be found" error when trying to run a MDX query?

One of the Business user asked for the resolution for the error they are getting when running a MDX query against the Analysis Services database within their data mart. The error is "Provider Cannot be found", before going further on this error...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Nov 5 2007
Filed under: Filed under: sql server, mdx, databases, 2005, Analysis Services, adomd.net, feature pack, driver
Monitoring the parallel processing performance of Analysis Services?

The ascmd.exe command-line utility is a handy tool for testing performance characteristics to determine the appropriate values for parallel processing. This utility is similar to the sqlcmd.exe utility that you use to execute SQL statements in SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Oct 8 2007
Filed under: Filed under: sql server, performance, data mining, process, tool, samples, Analysis Services, command line, parallel, ascmd
TechNet webcast: Advanced Manageability for SQL Server 2008 Analysis Services on 2007.10.10

With the release of SQL Server 2008 Analysis Services, Microsoft introduces several advanced features for manageability and one such feature is Dynamic Management Views (DMV). These views enable administrators to query for information regarding connections, sessions, and server performance. This session...

Posted to Martin Poon - Microsoft MVP blog [SQL Server] by Martin Poon on Sun, Oct 7 2007
Filed under: Filed under: SQL Server, DMV, Analysis Services
Save to Business Portal checkbox for Analysis Cubes is unavailable in Microsoft Dynamics GP

The following pages were recently modified. Source: Knowledge Base Product: Analysis Cubes for Microsoft SQL Server 2005 Notification Contents: New and All Modifications Save to Business Portal checkbox for Analysis Cubes is unavailable in Microsoft Dynamics...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 26 2007
Filed under: Filed under: sql server, kba, dynamics, cubes, gp, Analysis Services, business portal, unavailable
Automation of Analysis Services database backup

You may be well versed with scheduling the database backups using SQL Serve Agent --> Jobs with Enterprise Manager or Management Studio. So how about creating a automation job for SQL Server 2005 analysis services database backup every night. Simple...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 26 2007
Filed under: Filed under: sql server, databases, backup, security, reporting, sqlagent, Analysis Services, xmla
FIX: Error message when you use the Association Rules algorithm to process a data mining model in SQL Server 2005 Analysis Services: "This number of attributes exceeds the attribute limit of 5000 allowed by the current version of the algorithm"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you use the Association Rules algorithm to process a data mining...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 12 2007
Filed under: Filed under: sql server, data mining, attributes, kba, Analysis Services
While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command

Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google either. Any help would be appreciated. When performing the data mining cube process - Error: Memory error: Allocation failure : Not enough storage is...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Aug 27 2007
Filed under: Filed under: sql server, performance, memory, server, process, cube, Analysis Services

Page 1 of 1 (17 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

Recent Posts

Tags

Browse Blog Posts by Tags