Browse by Tags

SQL Server 2008 features - Relational & Data Warehouse Scalability list (new)

Published 2 May 8 9:12 AM | SSQA.net

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...

Filed under: sql server, performance, ssas, features, 2008, whitepaper, Analysis Services, scalability

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

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...

Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose

SQL Server Analysis Services MDX Query performance monitoring - highlights

Published 29 January 8 3:27 AM | SSQA.net

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...

Filed under: sql server, performance, mdx, query, best practices, tsql, monitoring, Analysis Services, baseline, benchmarking

SQL Server Analysis Services slicing and dicing

Published 27 January 8 6:8 AM | SSQA.net

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...

Filed under: sql server, performance, data mining, 2005, Analysis Services, slicing

SQL Server 2005 Best Practices Analyzer January 2008 update

Published 25 January 8 4:8 AM | SSQA.net

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...

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

Published 2 January 8 6:36 AM | SSQA.net

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...

Filed under: sql server, performance, msdn, bi, download, optimization, whitepaper, Analysis Services, sqlcat

How to find which version of Analysis Services you are running?

Published 5 November 7 11:54 PM | SSQA.net

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!...

Filed under: sql server, databases, microsoft, integration, ssis, ssas, version, Analysis Services

"Provider cannot be found" error when trying to run a MDX query?

Published 5 November 7 2:39 AM | SSQA.net

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...

Filed under: sql server, mdx, databases, 2005, Analysis Services, adomd.net, feature pack, driver

Monitoring the parallel processing performance of Analysis Services?

Published 8 October 7 3:8 AM | SSQA.net

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...

Filed under: sql server, performance, data mining, process, tool, samples, Analysis Services, command line, parallel, ascmd

Save to Business Portal checkbox for Analysis Cubes is unavailable in Microsoft Dynamics GP

Published 26 September 7 4:56 PM | SSQA.net

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...

Filed under: sql server, kba, dynamics, cubes, gp, Analysis Services, business portal, unavailable

Automation of Analysis Services database backup

Published 26 September 7 5:19 AM | SSQA.net

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...

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"

Published 12 September 7 12:42 PM | SSQA.net

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...

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

Published 27 August 7 5:47 AM | SSQA.net

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...

Filed under: sql server, performance, memory, server, process, cube, Analysis Services