SqlServer-QA.net

What kind of performance issues you see on day-to-day basis within your environment? The following elements are important factors that can add fuel to the fire (problem): Faulty hardware • Hardware that is not configured correctly • Firmware settings • Filter ...

The following pages were recently modified. Source: Knowledge BaseProduct: Analysis Cubes for Microsoft SQL Server 2005Notification Contents: New and All Modifications The compatibility between Analysis Cubes for Microsoft SQL Server 2005 in Microsoft Dynamics GP 9.0 and 64-bit operating systemshttp://support.microsoft.com/kb/929156/en-US

Though it is more to do with SQL Storage  kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances since, for example, two of the four servers could go down. In the majority of cases, ...

Full error text of above message while performing the backup of a Cube: The operation has been cancelled.   at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)   at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForError(XmlReader reader, XmlaResult ...

The following pages were recently modified. Source: Knowledge BaseProduct: Analysis Cubes for Microsoft SQL Server 2005Notification Contents: New and All Modifications   How to configure two servers that are running Microsoft SQL Server 2005 and Microsoft SQL Server Analysis Cubes for Microsoft Dynamics ...

The following pages were recently modified. Source: Knowledge BaseProduct: Analysis Cubes for Microsoft SQL Server 2005Notification Contents: New and All Modifications  How to create individual DTS packages in Analysis Cubes for Microsoft SQL Server 2005 in Microsoft Dynamics GPhttp://support.microsoft.com/kb/929598/en-US  

The following pages were recently modified. Source: Knowledge BaseProduct: Analysis Cubes for Microsoft SQL Server 2005Notification Contents: New and All Modifications How to set up the Master DTS and OLAP packages to run as a scheduled job in Microsoft SQL Server 2005http://support.microsoft.com/kb/930309/en-US  

As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data is saved as a file with .BLG extension which can be opened again using this SYSMON tool. I ...

The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any CPU bottleneck in the SQL Server machine. SELECT ...

Source: Knowledge BaseProduct: Analysis Cubes for Microsoft SQL Server 2005Notification Contents: New and All Modifications  Users who are members of the local administrator group can view restricted data in Analysis Cubes for Excel in Microsoft Dynamics GPhttp://support.microsoft.com/kb/929157/en-US Error message when you install Analysis ...