Browse by Tags

SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?

Published 17 April 8 5:6 AM | SSQA.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...

Filed under: sql server, memory, analysis, disk, IO, monitoring, configuration, iometer, contention, latches, latching

The compatibility between Analysis Cubes for Microsoft SQL Server 2005 in Microsoft Dynamics GP 9.0 and 64-bit operating systems

Published 11 September 7 3:23 AM | 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 The compatibility between Analysis Cubes for Microsoft SQL Server 2005 in Microsoft...

Filed under: sql server, analysis, microsoft, kba, dynamics, cubes

Whats the best way to setup memory on a four-node cluster?

Published 6 September 7 4:42 AM | SSQA.net

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

Filed under: sql server, performance, analysis, high availability, ssis, security, ssas, ssms, clustering, resources

The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)

Published 28 August 7 4:8 AM | SSQA.net

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

Filed under: sql server, analysis, backup, error, cube, operation failed, execute

How to configure two servers that are running Microsoft SQL Server 2005 and Microsoft SQL Server Analysis Cubes for Microsoft Dynamics GP

Published 22 August 7 3:50 AM | 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 How to configure two servers that are running Microsoft SQL Server 2005 and Microsoft...

Filed under: sql server, analysis, server, kba, dynamics, cubes

How to create individual DTS packages in Analysis Cubes for Microsoft SQL Server 2005 in Microsoft Dynamics GP

Published 22 August 7 3:49 AM | 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 How to create individual DTS packages in Analysis Cubes for Microsoft SQL Server...

Filed under: sql server, analysis, kba, dynamics, cubes, gp

How to set up the Master DTS and OLAP packages to run as a scheduled job in Microsoft SQL Server 2005

Published 22 August 7 3:48 AM | 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 How to set up the Master DTS and OLAP packages to run as a scheduled job in Microsoft...

Filed under: sql server, analysis, olap, kba, dts, cubes, scheduled job

How to Analyze the PERFMON (SYSMON) data?

Published 20 August 7 1:26 PM | SSQA.net

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

Filed under: sql server, perfmon, performance, analysis, databases, tuning, sysmon, tsql

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!

Published 17 August 7 8:4 AM | SSQA.net

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

Filed under: sql server, performance, memory, analysis, ssms, dmv, cpu, disks

Analysis Cubes for Microsoft SQL Server 2005 Knowledge Base Notification

Published 15 August 7 4:5 PM | SSQA.net

Source: Knowledge Base Product: Analysis Cubes for Microsoft SQL Server 2005 Notification 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...

Filed under: sql server, analysis, kba, exception, dynamics, cubes, unhandled, administrator

DMVs to provide state of TEMPDB during a performance tuning analysis

Published 14 August 7 8:55 AM | SSQA.net

TEMPDB - though the name sounds like temporary database, it most important for any user database! Coming to performance tuning exercise or analysis you would go through Task Manager initially to see how system's memory & processor are coping up...

Filed under: sql server, performance, analysis, index, rebuild, tempdb, hardware

Dedicated Administrator Console (DAC) - saved an important day for a DBA

Published 4 August 7 9:9 AM | SSQA.net

Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to...

Filed under: sql server, performance, management, analysis, blocking, dba, dac, sac, investigation

SQL Server 2008 June CTP: Analysis Services - Dimension Design

Published 11 June 7 5:36 AM | SSQA.net

This is the first of the 6 technical Live meeting series we have planned for you. In this session you will hear directly from Robert Zare who leads this improvement team. AS-Dimension Design enhances UI for creating and editing dimensions to guide users...

Filed under: sql server, analysis, ssas, katmai, dimension

SQL Server 2005 Analysis Services community samples

Published 29 May 7 4:44 AM | SSQA.net

As the evolution of Analysis Services has taken to new heights in SQL Server 2005 equally the users are looking to deploy on the large scale and having a need to go though the samples that are helpful. So how about referring to a project that contains...

Filed under: sql server, analysis, microsoft, ssis, server, ssas, codeplex

Data explosion and attributes in BI

Published 10 May 7 8:4 AM | SqlServer-QA.net (SSQA)

One of our Business Manager has asked can we handle the data explosion and BI requirement to handle billions of rows for their Sales pitch using SQL Server Analysis Servers. The obvious answer was 'yes' using the latest version of SQL Server and...

Filed under: sql server, analysis, integration, ssis, bi, ssas, attributes, business