Browse by Tags

• 2005
• administrator
• ascmd
• baseline
• benchmarking
• best practices
• bi
• command line
• cube
• data mining
• databases
• diagnose
• download
• mdx
• memory
• monitoring
• msdn
• optimization
• parallel
• process
• profiler
• query
• resources
• samples
• security
• server
• slicing
• sql server
• sqlcat
• sysmon
• tool
• tsql
• whitepaper

SQL Server 2008 Analysis Services performance guide - process to go over
27 November 08 10:34 AM | SQL Master | 2 Comments   

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

Filed under: sql server, performance, mdx, Analysis Services, monitoring, resources

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance
18 February 08 02:57 AM | SQL Master | 3 Comments   

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 (BI) Read More...

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

SQL Server Analysis Services MDX Query performance monitoring - highlights
29 January 08 02:27 AM | SQL Master | 5 Comments   

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

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

SQL Server Analysis Services slicing and dicing
27 January 08 05:08 AM | SQL Master | 3 Comments   

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

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

New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
03 January 08 10:36 AM | SQL Master | 2 Comments   

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

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

Monitoring the parallel processing performance of Analysis Services?
08 October 07 01:08 AM | SQL Master | 2 Comments   

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

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

While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command
27 August 07 03:47 AM | SQL Master | 2 Comments   

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 available Read More...

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