.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

adding mor tables to datasource view causes writeback performance problems

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

I've got a very strange behavior in one of our SSAS databases. We had performance issues so i've tried to put only the essential parts into one OLAP Database

the result is:

Just by adding more tables to the datasource view the writeback performance drops from 0,2sec to 3 sec. No changes to the cube, no changes to the dimensions.
The t-sql statement fired for the writeback remains the same.
Any idea?



View Complete Post

More Related Resource Links

Top .NET Performance Problems and how to avoid them

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

Design Patterns: Problems and Solutions with Model-View-ViewModel


The Model-View-ViewModel (MVVM) design pattern describes a popular approach for building Windows Presentation Foundation or Microsoft Silverlight applications. Robert McCarter shows you how the ViewModel works, and discuss some benefits and issues involved in implementing a ViewModel in your code.

Robert McCarter

MSDN Magazine July 2010

Databind ListView datasource and joined tables


Hi all.

I am not expert in ASP so i would be appreciated for the help. Issue connected to Entity FW, ListView Control, its Datasource and type convertion.

I have the  following LINQ query :


RoutesEntities routesModel = new RoutesEntities();
LocalesEntities localesModel = new LocalesEntities();
ObjectQuery routesQuery = (ObjectQuery) from routes in routesModel.Routes
                                                    join locales in localesModel.Locales
                                                    on routes.LocaleID equals locales.LocaleID

Adding ContextMenu to WorkflowDesigner View

Hello Everyone,      I am trying to add the ability to have a user highlight an activity subtree, then right click the mouse, then select "Extract activity".  Which will then take out the xaml (ModelItem) selected, create a new activity out of it, then insert this newly created activity in its place.  Right now I'm stuck on getting a ContextMenu to appear when I right click in the designer area.  I can get my custom context menu to work in other places on the same window however.  Does anyone know the solution to this problem?  Also, does anyone have any better suggestions as to how I might achieve the same end result in a more efficient manner? Thanks everyone, Bob

Performance Problems with calculate member in a cube

Hi,  I'm having performance issue with calculated member (Running total) which is created on one dimension in the cube.  Cube is having three dimension Product Details(Product Model, Product Type) , Time(Year & Month) & Qty type(In Qty & Out qty). See below for details Dimtime Year (Values 2000 to 2020) Month DimProd Product No Product Type Product Group DimQty Type In Qty Out Qty Fact Table Product No Year Month Qty Type of Qty( In Qty or Out Qty ) My MDX query for calculated member is  CREATE MEMBER [Qty Type].[Qty Type].[All].[Total] as      SUM(NULL:[TimeDim].[Hierarchy].CurrentMember , ([Qty Type].[Qty Type].[In Qty], Measures.[Qty]) - ([Qty Type].[Qty Type].[Out Qty], Measures.[Qty])  The formula is --> Total = Previous Period Total Qty + Inqty - Out Qty   This works perfectly when i browse at higher level (Qty Type on Rows & Time On Columns),   but when  i browse the cube adding dimension Product Details( Product group or Product Type) to Drill-through the In Qty & Out Qty,  the query is running and after one hour also it's not finished. Can anyone help me to solve this or propose new structure to resolve this issue.   

View Temporary Tables While Debugging in SQL 2008

How can I view temporary tables while debugging in SQL 2008? Note: I do not want to add a SELECT statement everywhere I need to see the contents of the temporary table. I'm hoping there is another way...like can it be done in the command window somehow, etc?

Problems with a calendar and a grouped view

Hi, I am having a problem mixing a SharePoint 2010 Calendar view with a Document library view that is grouped and collapsed. Whenever I add the calendar view to a page (calender details work fine just not the graphical calendar), I lose all the detail in my grouped documents view. I see either an empty icon with an "X" on it or just the name of the grouped column. I need to have these elements together on a team site home page for a major project. If you have not tried this, could someone see if they can replicate the behavior? I've tried it on my dev and QA systems and it happens the same on both and in different site collections as well. Thanks.

Adding ListViewWebPart to a page - how do you set its view to

If you add a ListViewWebPart to a wiki/web part page (such as the Links list), it will default to the <summary View>.  If you add it using code, it will default to the default view.  How can I set it to use the <Summary View>? I tried setting node.Attributes["BaseViewID"].Value = "0" in the web part view xml, but that didn't do anything. Any thoughts? ListViewWebPart wpLinks = new ListViewWebPart(); SPList listLinks = site.Lists["Links"]; wpLinks.ListName = listLinks.ID.ToString("B").ToUpper(); wpLinks.ViewGuid = listLinks.DefaultView.ID.ToString("B").ToUpper(); AddToolBar(wpLinks, "Add new link"); private void AddToolBar(System.Web.UI.WebControls.WebParts.WebPart wp, string label) { // Get the view used in the web part by using reflection PropertyInfo viewProp = wp.GetType().GetProperty("View", BindingFlags.NonPublic | BindingFlags.Instance); SPView webPartView = viewProp.GetValue(wp, null) as SPView; // This is necessary after the infrastructure update, without it you can't get to the XML of the view webPartView.GetType().InvokeMember("EnsureFullBlownXmlDocument", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.InvokeMethod, null, webPartView, null, System.Globalization.CultureInfo.Current

HELP - Problems with programatically adding checkboxes

Here is the setup. I programatically add a Canvas, a Grid, and within that grid are two columns of checkboxes. I have the Canvas there for querying purposes (makes it easier). The problem is that after the method executes that does all this and the form is displayed the canvas is visible, but the checkboxes aren't. When I set a breakpoint at the end of the method and check to make sure that all the Children are where they are supposed to be, they are all in their correct places. For what it's worth here is the code for the method. I cannot, for the life of me, figure out why they are not being rendered. They are there there when breaking down the items children for each of the controls. private void AddItemsToQuestion(Canvas pQuestionCanvas, XElement pQuestion) { List<XElement> pItems = (from c in pQuestion.Elements("Item") select c).ToList(); if (pItems.Count <= 0) return; int iNumberOfRows = (int)Math.Ceiling((double)pItems.Count / 2); //get the question canvas name Dictionary<string, object> pQuestionTag = ((Dictionary<string, object>)pQuestionCanvas.Tag); string sQuestionName = pQuestionTag["Name"].ToString(); Canvas pItemsCanvas = new Canvas(); pItemsCanvas.Width = pQuestionCanvas.Width; pItemsCanvas.Height = iNumberOfRows * 25; Thickness pThick


Sorry my terrible english,   I will try to explain my problem, I made some data changes at the publisher and I had to throw away the PK and FK cascading multiple tables. The problem I have is that these changes were trying to apply to the subscribers and can not do because it does not in order which I did step by step through the Publisher. subscribers now show me this error and does not synchronize anything, and takes 0.5 sec and gives the error infinitely I need help, which infinitely grateful Error messages: The schema script ' if exists (select * from sysconstraints where constid = object_id(N'[FinancieroAbonos_PK]')) if object_id(N'[dbo].[FinancieroAbonos]') is not null exec('ALTER TABLE [dbo].[FinancieroAbonos] DROP CONSTRAINT [FinancieroAbonos_PK] ')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) Get help: http://help/MSSQL_REPL-2147201001 The constraint 'FinancieroAbonos_PK' is being referenced by table 'FinancieroAbonosContabilizacion', foreign key constraint 'FinancieroAbonos_FinancieroAbonosContabilizacion_FK1'. (Source: MSSQLServer, Error number: 3725) Get help: http://help/3725 Could not drop constraint. See previous errors. (Source: MSSQLServer, Error number: 3727)

DataAdaptor/Dataset problems when no row present in database tables

Hi All, I'm trying to use a DataSet to maintain some rows for a table, and when I've finished my changes, send all changes to the database using a SqlDataAdapter.    I find if there are no rows in the table in the database then I am getting a 'Object reference not set to an instance of an object' when I try to access the table in the Dataset. Is there a way to work with a Dataset like this ie. I start off with an empty table and I wish to add rows, to access the structure of the table rows, build rows, then add them and do the update on the SQLDataAdapter. Thanks, Sinead Here is my code: protected SqlDataAdapter memberDA = new SqlDataAdapter(); protected DataSet memberDS { get { if (ViewState["memberDS"] != null) return (DataSet)ViewState["memberDS"]; else return new DataSet(); } set { ViewState["memberDS"] = value; } } protected SqlDataAdapter getDataAdapterForMembers() { SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["SiteDBConn"].ConnectionString; memberDA = new SqlDataAdapter("usp_GetMembers", conn); memberDA.SelectCommand.CommandType = CommandType.Stored

Performance Monitor Counters To View How "Busy" A SQL Server Is

What are some good performance monitor counters to look at, when trying to figure out how "busy" our SQL 2008 server is? We were told to look at: SQLServer: SQL Statistics: Batch Requests/Sec and SQLServer: Databases: Transaction/Sec . Any other critical ones? Is there a counter to get the number of  selects, updates, and deletes independently per second? Thanks.

Create view that amins to tables of another database on the same sql server instance

Hi to everybody, I found a situation ever met before. I develop on Dynamics NAV 5.01 and I have developed a method to be able to see some particular tables of an external database. In substance it deals with a property of tables of Dynamics NAV. When I create a table in NAV, I can create it in 3 different ways: table common to all the companies table  for company or table linked to a view.    This last case is mine, on the same db of NAV I have created a view with some fields, I have created in NAV a table linked with equal fields and types. Until here all normal.    The view, however, aims to another database that doesn't center anything with NAV but that it is on the same intance of SQL server.    The consumer that accesses NAV is a consumer type database SQL Server and has the permitted db_public and db_datareader on both the database. Then he can read the views on the db of nav both on the db of the other database.    When it tries to enter from the console of sql server, with the consumer database, all it works, if I do it by NAV, it show me an error "The server principal "username" is not able to access the database "some_database_name" under the current security context. (Microsoft SQL Server, Error: 916) "    If I add on the database NAV to the consumer, the role db_owner,

Programmatically adding Calendar web part with summary view or custom view?

Within my feature I am adding a calendar web part to page.  I would like to specify the summary view (not the full graphic calendar view).  Is this possible? Is it possible to create a custom view and set the listviewwebpart to this custom view through code?   thx -davedave

updated view (with insert )on two tables

CREATE TABLE [tbl1](       [ID] [int] IDENTITY(1,1) NOT NULL,       [F1] [int] NULL,  CONSTRAINT [PK_tbl1] PRIMARY KEY CLUSTERED (       [ID] ASC ) ) ON [PRIMARY] GO CREATE TABLE [tbl2](       [ID] [int] NOT NULL,       [f2] [int] NULL,  CONSTRAINT [PK_tbl2] PRIMARY KEY CLUSTERED (       [ID] ASC ) ) ON [PRIMARY] GO CREATE VIEW [View_1] AS SELECT     tbl1.ID, tbl1.F1, tbl2.f2 FROM         tbl1 LEFT OUTER JOIN                       tbl2 ON tbl1.ID = tbl2.ID GO INSERT INTO [BackUpsData].[dbo].[View_1]            ([F1],[f2])      VALUES(1,1) i get this message : Msg 4405, Level 16, State 1, Line 1 View or function 'View_1' is not updatable because the modification affects multiple base tables.   how can i create a view that can insert new rows into ? thanks.  

SQL Server 2005 Analysis Services - Performance of Excel Pivot Tables

Hi, I've several cubes available for several users within my organization. I've the SQL Server 2005 and the Analysis Services running on the same machine but it has 30Gb of RAM, 8 processors and a quick enouth disk. The problems is that i've some automatic processes that "build" some excel reports and the users use pivot tables with olap connections to the cubes regularly. I've noticed that the excel "locks" when the user is drilling down the data and the server has only one processor (there are 8...) at 100%... Is there a way to make the analysis services use the maximum processing capacity that is available? The users are complaining about the slowness of the cubes... Thanks in advance Hugo
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend