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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Slow Replication Performance

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
I have a fairly large table and I have updates 1.2 million rows on the Primary. The replication performance is very slow. There is a text column on this table. I am using profiler to see the performance on the target end. It says CPU time is @200ms and Duration is @210ms. The number of locks acquired on this table is very high. There is not much going on the target end. I cloned this table and performed an update on one row and it takes just 12ms. I am not sure what is going on. Any pointers to improve performance will help!  


View Complete Post


More Related Resource Links

Very Slow Performance on 64 bit SQL System

  
Hello, we have a Windows Server 2008 64 bit and a SQL Server 2008 64 bit. The server work and the speed with a quad CPU and 8 GB RAM is nice. But, we use a SQL script with xml (we make a XML paket for replication) is the speed very slow. The script need 40 - 60 min to finish. But the same Database and the same script on a Server 2008 32 bit and SQL Server 2008 32 bit on the same hardware need 22 seconds. We have all updates installed. Have anywere a Idea? Thank

Slow performance when searching in "any part of field" of a SQL Server database using a Microsoft Ac

  
We have just migrated our back end database from Access to MS SQL Server 2008 R2. We have noticed better performance on our searches - unless we select to search in "any part of field" in Access (with Access' built-in search function - we use a mix of Access 2003 and 2007). This takes nearly 20 seconds to find the result, whereas before the migration it was taking 5-7 seconds (compared to instant results we now experience when searching for whole fields). The main fields we search are not large - usually just two words. Obviously it is better to search for a whole or start of a field, but this is not always possible. The contractor that assisted us in this project has told us that this "is just the way SQL works with Access". Is this really true? I find it hard to believe two MS products would have such a big issue between them. I presumed using SQL with an Access front end would be a common setup, which is why I thought this must be a problem with our setup. Is there any way to fix this speed issue?

Very slow performance with a query involving JOINS

  
I am experiencing extremely slow performance on a particular SQL query using SQL compact.  This same query completes in less than one second on my regular SQL server.  With SQL compact, I am actually not even sure if the query ever completes.  As I type this I am testing it from SQL management studio, and it's up to 17 minutes and 40 seconds still executing so far. Since I am not experiencing this on most of my other queries, I have little doubt the slowness is due to the volume of data in these tables, coupled with the fact that I am doing the joins.  I made sure that foreign key constraints are in place for the columns that the joins are based on.  From what I've read, this also ensures that appropriate indexes are created, although I am starting to wonder about that. This is the query: SELECT TOP (200) t.BusinessEntityID, t.BusinessName, t.IsTowTruck, t.IsHospital, t.TowTruckLastUsed, t.BusinessLocked, cn.Address1, cn.City, cn.State, cn.PostalCode, cnp.PhoneNumber as TopPhoneNo, GetDate() as LastUpdatedDate, GetDate() as CreatedDate FROM tblBusinessEntity t LEFT JOIN cnBusinessEntityLocation cn ON cn.cnID in (SELECT TOP (1) cnID FROM cnBusinessEntityLocation where cnBusinessEntityLocation.Active = 1 AND cnBusinessEntityLocation.BusinessEntityID = t.BusinessEntityID

MDX query performance is slow for complex logic implementation in Calculated Members.

  
We have implemented a calculated members which involves multiple calculated members  called in a nested e.q. Cal1 calls Cal2 and Cal2 calls  Cal3  and Cal3 calls Cal4 .  And when browing Cal1 through Excel it takes around 30 mins for getting result from a Partition having row count around 5 million. Follwing are the information on the scenario I am having: We are having partitioning in the cube. one partition contains around 4-6 million records Processers on Query Server: 4 quad core RAM on the Query Server: 64 GB Calculated members having simple calculation logics are giving results in no time. There is a Calculated members which calls 6 intermediate calculated in nested way and with small Data Set like 5-6 k rows it is running fine.   Any help will be much appreciated.   Regards, Sandeep

CAST in delete query-Performance is so slow

  
Hi all, I've below join in the delete statementt, but it's taking so long the query run, the performance is really bad because of cast conversion, is there a better way, especially performace wise to fasten this below join, A.PHONE in nvarchar data type and DNC.PHONE_NUMBER  is in bigint data type.   A.PHONE=CAST(DNC.PHONE_NUMBER as varchar (15)) Thank you.

Slow performance of WCF service calling singleton (which calls COM+!)

  

Scenario:
WCF Service call routing to COM+ application.
netTCPBinding, throttling set pretty high.

[ServiceBehavior(InstanceContextMode = InstanceContextMode.Single, ConcurrencyMode=ConcurrencyMode.Multiple)] 

Service has two methods, one simply returns the string was input, the other calls the COM+ component and FOR TESTING returns the string "success" for every call. Therefore, both methods return a simple string.

Client starts 20 threads, each calling the WCF Service twice. (NOTE: A "first call" is made to prime the singleton service and also the COM+ component)

Using log4net and a Stopwatch to log the timings of the clien

Report performance slow

  

The below query is taking about 30 sec to execute in the management studio. I tried to visualize the Estimated execution plan and everything is a clustered index scan. The number of rows in the fact_dailycost table are 384962 and all the dimension tables have less than 1000 rows.

Please let me know how should I start tuning this query. This I'm creating a view and in the SSRS Report, I have a parameter Contract Number that is applied on the top of this view. For the report to display the results it is approximately taking 21/2 minutes.

SELECT

 

* FROM
dbo.Dim_Employee

Slow performance with SQL Server 2005 executing parameterized queries with LIKE and an aggregate com

  

We have a slow-performing query and, after some analysis, have narrowed the cause down to using parametrized queries in conjunction with LIKE and aggregate comparisons used in the WHERE clause.  If we use a non-parametrized query (but keep the WHERE clause the same) the query performs much faster and, in fact, executes a different plan.  Using OPTIMIZE FOR UNKNOWN is not an option for us as we are using SQL Server 2005.  Obviously, we'd like to use parametrized queries to prevent SQL injection but the slow perf is unacceptable.  We need the LIKE to support wildcard scenarios.  If we need to we'll use dynamic SQL (scrubbed as much as we can) in lieu of parametrized queries.  We're wondering, however, is there another option that would give us the perf without sacrificing safety?  I can provide a sample database, query, plans, etc. if necessary...I'm assuming SQL Server generates a less efficient plan with the parametrized query as it can't make any assumptions about the parameter values...

Mike Bouck


Slow performance with SQL Server 2005 executing parameterized queries with LIKE and an aggregate com

  

We have a slow-performing query and, after some analysis, have narrowed the cause down to using parametrized queries in conjunction with LIKE and aggregate comparisons used in the WHERE clause.  If we use a non-parametrized query (but keep the WHERE clause the same) the query performs much faster and, in fact, executes a different plan.  Using OPTIMIZE FOR UNKNOWN is not an option for us as we are using SQL Server 2005.  Obviously, we'd like to use parametrized queries to prevent SQL injection but the slow perf is unacceptable.  We need the LIKE to support wildcard scenarios.  If we need to we'll use dynamic SQL (scrubbed as much as we can) in lieu of parametrized queries.  We're wondering, however, is there another option that would give us the perf without sacrificing safety?  I can provide a sample database, query, plans, etc. if necessary...I'm assuming SQL Server generates a less efficient plan with the parametrized query as it can't make any assumptions about the parameter values...

Mike Bouck


Viewing Video's in Sharepoint 2010--Will it slow down the performance for the end users?

  

I understand how to upload files to the media web part and creating an asset library, however; i'm trying to figure out where these files are being stored and the performance of the users.  I read the digital asset management library information on technet and couldn't find the exact answer i'm looking for. 

So, here's my question:  If I want to upload 10 videos to the asset library, they each may have around 50mb or less for the file size, and we want 200 plus users to access it, will this affect the performance of when these users hit the site?  We want to display the video's without having to buy a media server.  And the main question that will be asked is, who will host the content?  And, where is it residing?  My guess is that tt will be hosted in SP 2010.

I'm trying to incorporate a new intranet portal site for my company that will have a video to be played on the home page of the intranet site and the links will be located on the left and right side of the page with the video webpart in the center.  Will using the Blob cache and bit throttling be sufficient for this request?  I think it will be, I just want to make sure before we role this out.  Any help will be greatly appreciated.  Thanks.

 

 


Model3DGroup slow performance on adding items

  

Performance on our program struck on Model3DCollection.Add method

We often adds and removs GeometryModel3D from screen, and adding models to Model3DGroup.Children -> Model3DCollection takes 20% of performance.

Reduce the number of models addid to Model3DCollections is impossible. All objects and materials are freezed.

 Can someone helps?

It would be very useful to have a method like Model3DCollection.AddModels for adding a set of models without having to fire changed events.


Slow Performance with a sigle table

  

Hi,

We have SQL 2005 Server with a SAP database of 400 GB in out Test enviroment (production machine is DB2 iSeries). We have a very extrange problem just with a sigle table. The table has about 56Mill of Rows an a size of 11 GB of data and 25 GB spent in indexes. We have similar tables in the database (even bigger than this one) with a correct performance.

The performance of bulk deletes or inserts in this single table are extremly slowly. For instance, deleting 25 Mill of rows can take many hours (more than 20). CheckDB and othr maintence plans already applied without any issues.

Any ideas?

 


F5 Debugging performance is slow

  

Hi,

We have the following SharePoint 2010 and VS Ultimate setup

  • Windows Hyper-V Server Host
  • 64-bit edition of Windows Server 2008 R2 Standard
  • Dual Intel Xeon CPU X5550 @ 2.67GHz
  • 8GB RAM
  • SQL Server 2008
  • SharePoint 2010
  • Visual Studio Ultimate 2010
  • Visual Studio Configuration Manager for our VS solution set to Target Framework .NET 3.5 and Target CPU x64

The issue we have is that when we are F5 debugging it is a painfully slow process.  It can take 40-60 seconds from pressing F5 to the loading of an initial page. Then moving around the site is also painfully slow. We cannot understand why we should be experiencing such poor performance.

Any ideas or thoughts would be very gratefully received.

Thanks,

Maz


Slow performance calling an Web Service in a Visual Web Part

  

Hi,

I'm developing a report from data being served from a web service in SAP (through PI). I used the wsdl.exe to create a c# class and a wrapper and everything is working fine.

The problem is the performance... it takes about 3x the performance of an console application just to move the code inside a Visual Web Part.

I isolated the code to just this... 

DateTime timeReq = DateTime.Now;
response[] t = werbService.method(req);
double timeTaken = DateTime.Now.Subtract(timeReq).TotalMilliseconds;

It takes 60 seconds in a Visual Web Part and the same call in a console application takes 20s.

Since i dont have a packet sniffer i'm not sure why is taking so much time to execute the same code in sharepoint, am i missing some configuration? Anyone have face this kind of behaviour before?

TIA.


SQL Server 2005 Replication - Replicated Databse Performance Issue

  

Hello,

 

I am struggling to work out a very frustrating replication issue and wondered if anyone could help me.

Here is my situation.

 

I have a virtual machine with 16gb RAM and 4 quad core 3Ghz processors and 250gb disk. This has Windows Server 2008 64 bit installed.

The machine has a SQL Server 2005 64 bit instance installed with SP3.

I have setup a publication on this SQL Server called pub1 , this publication publishes all tables/sp's /views and UDF's . I have set the article properties for the published tables as below.

- Copy Check Constraints = True

- Copy Clustered Index = True

- Copy Non Clustered Index = True

- Copy Default Value Spec = True

- Copy Collation = True

- Copy Insert, Update and Delete = True

- Copy unique key contraints = True

- Copy XML Indexes = True

Every other setting is set to false.

I have created a subscription to pub1 within the same SQL Server instance. The database has replicated everything I require without an issue.

If I run a query against the databse that I have published, it returns the query in less than 10 secs. If I run the same query against the subscription DB then this query takes over 30 mins to return.

I thought this was an issue with the indexes not replicating. From what I have selecte

Moss 2007 Performance - WebPages loading very slow

  

Hi Guys, I have this issue at school on the Gold Coast and can't seem to solve it. Seems it's common to the combination below.

Let me know if you know how to improve it?

 

Thanks

 

Paul

 

MOSS 2007 + Windows Server 2003 + IIS 6 Poor WCM Webpage load speed
We are a school with 3 x Domains and the below specs and configurations:

Home Pages of each site plus all sub pages load very slowly (ie: 20-40 seconds to load first time). After caching it the

speed improves but not by much.
With wireless it's even slower

Server Spec:

4GB Ram
1 x Intel Xeon CPU (3.2 GHz)
1 x 410 GB Hard Drive
1 x 1GB Nic

Windows 2003 Standard Server SP2
MOSS 2007 Standard (NTLM authentication, 1 x SSP, Setup is Farm on single server which has IIS 6 and SQL 2005 Server

slow performance of c# code using an old active X control

  

I would like to speed up some code that calls into an old active X control many times. 400K calls takes about 20 seconds when calling from C# into the control whereas in a separate test app, unmanaged MFC/C++ into the same control takes about 1-2 seconds or about 10x faster. I started to look at managed C++ but this is pretty new to me so I have some questions.

In C# winforms app I instantiate the active X control. I would like to call into a C++ DLL passing in the com control and then have the C++ code call into the control many times. Is this possible? I'm not sure how I can take a "MyControl ^" which is slow and magically convert it into a "MyControl *" which is then possibly fast because no transition is taken from managed to unmanaged. I tried use the pin_ptr or address operator but that doesn't seem to be the way to go.

Or maybe I should be just passing an hwnd around instead of the object pointers. But, then how would stuff like MFC DDX_Control work to wire things up when there is no MFC CDialog?

thanks,

Paul.


Categories: 
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