一段时间后，缓慢的应用 [英] Slow application after some time

问题描述

我的应用程序使用WCF来获取本地服务器上从中央服务器和地点的数据。我要取93000条记录，一把抓住250记录每个请求。第一个要求去相当快，18-20记录每秒。过了一段时间，约10-15分钟，perfomece开始逐渐回落，并达到5-6记录每秒。

My application uses WCF to get data from the central server and place on a local server. I have to fetch 93000 records, and caught 250 records per request. The first requests go reasonably fast, 18-20 records per second. After a time, around 10-15 minutes, perfomece begins to fall gradually and reaches 5-6 records per second.

我不使用任何框架。我使用.NET 4.0和SQL Server 2012的数据compatibildiade 2005年。

I do not use any framework. I am using NET 4.0 and SQL Server 2012 with data compatibildiade with 2005.

你有没有试图找到这个问题，我认为没有错的来源。 是否有任何明显的原因逐步慢？

Have you tried to find the problem and I see nothing wrong with the source. Is there any apparent reason for the gradual slow?

不是错误的.Net C＃

Not error in .Net C#

我有抓住数据从一个WebService并保存在SQL Server 2012中的数据库与空表的申请，perfomece为20个记录每秒。经过7500-10000记录peforme插入开始在表中达到20000条记录后逐渐回落，降至每秒5条记录。

I have an application that grabs data from a WebService and saved in a SQL Server 2012 database with empty tables, the perfomece is 20 records per second. After the insert of 7500-10000 records peforme begins to fall gradually after reaching 20,000 records in tables, drops to 5 records per second.

我删除了所有的按键和触发器

推荐答案

您需要配置您的应用程序，看看它正在放缓。 这里是一个步入式直通的使用Visual Studio 2013来分析。

You will need to profile your application to see where it is slowing down. Here is a walk-thru for using Visual Studio 2013 to profile.

性能计数器数据可能会非常有用。它可以告诉你，如果处理器的使用扣球，磁盘队列正在备份，网络流量会增加，或内存杏。

Performance Counter data can be very useful as well. It can tell you if the processor use is spiking, disk queue is backing up, network traffic is increasing, or memory is maxing out.

当有成千上万的新对象的工作，你可能会遇到缓慢内的垃圾收集作为堆增长。这真是你的应用程序设计的症状，但它可能指向你在code正确的地方。

When working with many thousands of new objects you may experience slowness within Garbage Collection as the heap grows. This is really a symptom of your application design, but it may point you to the right place in the code.

这篇关于一段时间后，缓慢的应用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！