Browse by Tags

All Tags » performance   (RSS)
SQL Server BI - Managing Large Datawarehouse environment, guidelines
17 September 08 01:24 AM | SQL Master | 2 Comments   
What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with Read More...
SQL Server Reporting Services: Resources and information - all in one place
13 May 08 01:30 AM | SQL Master | 2 Comments   
During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend to Read More...
BI Virtual labs on MSDN - specific to data mining and top 10 classed in Tech-ed.
26 February 08 03:45 AM | SQL Master | 2 Comments   
As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual Read More...
SQL Server 2008 BI enahncements - what you want is what you get!
25 February 08 01:49 PM | SQL Master | 2 Comments   
So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped Read More...
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...
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...
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...
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...
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...
Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks
05 September 07 02:34 AM | SQL Master | 2 Comments   
Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services such as MDX queries, Read More...
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...
BI - PerformancePoint Server LAST CTP announced!
16 August 07 08:32 AM | SQL Master | 2 Comments   
Microsoft released PerformancePoint Server’s LAST Community Technical Preview (CTP) before launch! To date, the CTP program has gathered close to 10,000 members and the product has been enjoying fantastic pre-launch press and analyst coverage. For more Read More...
MDX query performance issues in SQL 2005 Analysis Services
06 May 07 03:20 AM | SQL Master | 0 Comments   
See the relevant KBA resources here: When you run an MDX query in SQL Server 2005 Analysis Services, the query takes longer to run than expected http://support.microsoft.com/?kbid=935995 An MDX query takes longer than you expect to finish in SQL Server Read More...
Filed under: , ,
Where to start to monitor the Analysis Services Performance?
04 May 07 12:25 PM | SQL Master | 0 Comments   
As explained on the other blog post PERFMON tools works on Windows Server 2003, Windows XP, Windows 2000, or Windows NT. Performance can monitor (remotely or locally) an instance of Analysis Services or SQL Server running on any of these operating systems. Read More...
Monitor Analysis Services performance
04 May 07 12:12 PM | SQL Master | 0 Comments   
Within the Relational SQL Server engine monitoring the performance is easy with pre-equipped tools such as Profiler, Database tuning advisor and Performance Monitor (SYSMON). How about for BI - Analysis Services monitoring in this case. Again PERFMON Read More...
Filed under: , , ,