.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

Web Synchronization Performance Problems

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

Hi all,

We have a Web Synchronization for merge replication system (67 tables, 55 of them should be Download-Only. Lots of them Dynamic Filter, and 10 of them have Join Filters) between sql server 2008 R2 (as publisher) and sql server express 2008 R2 (800 pull subscriptions with only web synchronization, with 3G connection). I googled for all of today about performance tips and tricks, and set our profiles, settings etc..

My problem is at initial synchronization process. First of all after Creating Replication triggers (before this other snapshot scripts are being applied) at Initial Web Sync Process, we wait 5-15 minutes after last ".. creating replication triggers on table 'tblOrder'  message. I think after creating replication triggers, Merge Agent connects to Web Sync Replisapi.dll and it computes the data needed, but this takes too long 5-15 minutes??

And after these download operations, after all necessary data is downloaded, i think merge agent is starting to download the snapshot. Why this is necessary? because before the initial synchronization, i create all tables manually, and after that i create merge subscription manually. And then, starting merge process, snapshot is being applied to subscription database, necessary data is being downloaded so why the whole data is being downloaded after data transfer again? It takes too long

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

Concurrent Affairs: Performance-Conscious Thread Synchronization


In my career, I have architected and implemented many thread synchronization techniques. This has provided me with a lot of experience that has shaped the way I now think about thread synchronization problems.

Jeffrey Richter

MSDN Magazine October 2005

Web Farms: Use Data Caching Techniques to Boost Performance and Ensure Synchronization


Performance is an important concern for any application, but becomes critical when the app is a Web Service accessed by thousands of clients simultaneously. One hardware approach to distributing Web Services requests evenly is a Web farm consisting of multiple servers. Once on a Web farm, Web Service performance can be improved by using ADO.NET DataSet objects to cache frequently accessed data, reducing round-trips to the database. Here the author describes data caching in a Web farm environment and discusses how to avoid the cross-server synchronization problems inherent in this approach.

David Burgett

MSDN Magazine December 2002

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.   

User Profile Synchronization problems suddenly

I installed User Profle Sync and it was working for a few weeks just fine.  No issues with "starting".  I was able to syn the AD users to SharePoint. Now - for some reason, it has decided to stop working and my event viewer is filled with Event ID 5555 errors over and over again.  I have no clue why it decided to stop working or if I changed something that caused it (or what I changed) and I've tried to restart the service several times, but always end up in "Starting" mode now and the errors persist. I'm a beginner and would love some help here.  I followed this page http://www.harbar.net/articles/sp2010ups.aspx when setting it up the first time and it worked perfectly. So now what?  Do I have to do it all again?

adding mor tables to datasource view causes writeback performance problems


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?



Tackling performance problems with processor maxing out


I am tackling some performance based issues on my server, the situation is that when the application is running, it runs a loop from a c# application, then calls a stored procedure about 2,000 times, during this period cpu is pegged at 100% all the time.

All the queries are select queries on the database pulling off data to be fed into the application, what I was seeing before was that the stored procedure was denormalising data and puting it into a temp table, then selecting from the temp table out to the application. I thought at the time that this wasnt effficient, so first task was to remove the use of the temp tables and query tables directly in order to avoid write costs.


I then later noticed that when I call the stored procedure from management studio once i.e 1 thread, performance seems to be 60 - 70% better, but within the application its called with multiple threads and therefore multiple concurrent calls to the database, i.e sometimes 6 - 10 concurrent calls, then the proc that runs within a second now runs for about a minute. CPU is still pegged at 100%, checked waits, I see a lot of CXPACKET waits and ASYNC_NETWORK_IO waits as well. CXPACKET I dont think i should be worried too much because the app returns between 3k to 30k rows per call, and parallelism might not be a bad thing with constant reads (please correct if i'm wrong her

SSRS 2008 R2 and Sharepoint 2010 - performance problems


Hi all,

I'm currently in a DWH project using SSRS 2008 R2 x64 in Sharepoint Integrated mode along with Sharepoint 2010, and we're seeing massive performance problems even though traffic on the server is at a bare minimum. We're in development with a maximum of a few users online at any given time and the server itself isn't doing a whole lot...cpu is usually < 20%. We have timed the database queries and 90% of them are taking less than a second to execute while reports takes anywhere from 5 to 30 seconds to load (some heavier reports can occasionally take a lot longer). I am simply unable to get anything to load in less than 5 seconds, even the simples grid from a SELECT TOP 5 * FROM table query takes this long.

The server setup is suboptimal as SQL Server, Reporting Services and Sharepoint are all running on the same virtual machine but with the minimal amount of traffic we have this shouldn't really be a problem. The server is a Win 2008 x64 Datacenter with 4 CPU's and 16GB RAM.

A standard sharepoint page that gets data from the database is returned in milliseconds...why doesn't reporting services do the same? What can I do to increase performance?


Max "workflows in progress" - performance problems?



A site in our farm has a workflow that is set to pause until a certain date (based on some calculations). Currently there are about 1350 workflow instances in progress ("paused").

Our farm is also experiencing some performance issues. Both web front ends are operating at 90-100%. Do you think the number of workflow instances running could cause this kind of performance problem?

Thanks for your time.

Edit: I should add that the workflow was created with SharePoint Designer.

ASP.NET Best Practices for High Performance Applications

This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

High-Performance .NET Application Development & Architecture

It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

How to improve the performance of ASP.NET MVC web applications

It is an in depth analysis of a Digg-like site and how it went from serving (on a test machine) 6 req/sec to 390 req/sec.

The biggest gain, 74 req/sec to 390 req/sec happened when he introduced data caching and another 25 req/sec where gained when he introduced the compilation of LINQ queries.

High Performance ASP.NET - Speeding Up ASP.NET Pages

have been writing a series of blog posts, which I have named High Performance ASP.NET Websites Made Easy! There is no rhyme or reason to the order of these posts and certainly can be read in any order:

Developing High Performance and Scalable ASP.NET Websites
Avoid Chatty Interfaces Between the Tiers in Your ASP.NET Web Application
ASP.NET Page Profiling - Page Tracing - High Performance and Scalable ASP.NET Websites Made Easy
Web Applications: N-Tier vs. N-Layer - Benefits and Trade-Offs
Query Analyzer - Sql Server Database Indexes and Execution Plans

Improving Application Performance in .Net

Application performance has always been a concern for Web Application developers. This article contains guidelines and tips for maximizing application performance in ASP.NET.

Tips to Improve Your ASP.NET Web site performance

ASP.NET has been developed with lots of features which makes developer life easy. Start from ViewState, PostBack, Server Controls , User Controls and etc. All of them can make your web development experience fun and easy, but improper use of them can cause your site performance slowdown. Most of the controls generate overhead to the client and server. Therefore in this article, I I will list out about things you can do and don't to improve your ASP.NET website performance.

10 Tips for Writing High-Performance Web Applications

Writing a Web application with ASP.NET is unbelievably easy. So easy, many developers don't take the time to structure their applications for great performance. In this article, I'm going to present 10 tips for writing high-performance Web apps. I'm not limiting my comments to ASP.NET applications because they are just one subset of Web applications. This article won't be the definitive guide for performance-tuning Web applications-an entire book could easily be devoted to that. Instead, think of this as a good place to start.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.
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