营销经理很慢 [英] Marketing Manager very slow

问题描述

营销经理很慢是否正常？在我们的生产环境中，当您点击应用程序中的刷新按钮直到更新树视图时，大约需要1分钟。应用程序中的所有内容都需要很长时间。由于响应时间非常长，因此无法工作
。

Is it normal that Marketing Manager is very slow? In our production environment it takes about 1 minute when you hit the refreshe button in the application until the treeview is updated. Everything takes this long time in the application. It's not posible to work because of the very long response times.

无论从哪台PC运行MM工具，到处都是相同的慢响应时间。即使从托管服务的服务器，应用程序也很慢，没有任何区别。如果我在浏览器中点击服务网址就会很快。

It doesnt matter from which PC I run the MM tool, it's the same slow response times everywhere. Even from the server where the services are hosted the application is very slow, no difference at all. If I hit the service urls in the browser it's fast.

我在点击刷新按钮时尝试调试MM。我可以看到在MarketingManagerSearchResults.cs中执行第265行（this.DataSource = null;）需要很长时间。我不知道为什么。如果我跳过这一行（不执行它），那么下一个
行就会变慢。也许这是另一个做一些缓慢的事情的线程。

I tried debugging MM when hitting the refresh button. I could see that it took very long time to execute line 265 (this.DataSource = null;) in MarketingManagerSearchResults.cs. I have no idea why. If I jump over this row (not executing it), then the next row is slow instead. Maybe it's another thread that do something that is slow.

我们正在使用Windows身份验证和AzMan来访问这些服务。

We are using Windows Authentication and AzMan to access the services.

请帮我这个！

 

推荐答案

我建议您查看营销数据库。 ...你是否清理了过期和删除的广告系列/广告折扣等等????

I would suggest to take a look on the marketing database.... Did you clean up expired and deleted campaigns / Advertisement discounts and so on????

我建议您还要使用SQL事件探查器跟踪来了解问题是否在SQL上或者在网络服务器上（我打算对SQL进行一些重要的查询以优化....）

I would reccomend to take also a SQL profiler trace to understand if the problem is on SQL or on the web server (I'd bet on some heavy query on SQL to optimize....)

Stelio

这篇关于营销经理很慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！