C＃applcation用postgresql缓慢响应 [英] C# applcation responding slowly with postgresql

问题描述

大家好



我正在使用postgreSql在ac＃windows应用程序中工作。它在4个位置运行。



问题是：在3个地方它工作正常，但在第4个位置应用程序响应缓慢。

记录在数据库中每3个位置远远多于第4个。



请告诉我可能是什么问题..



代码明智无法找到。

数据库有什么问题.. ??



需要你的建议..

Hi all

I am working in a c# windows application with postgreSql.and it's running in 4 location.

Problem is this : In 3 locations it's working fine but in the 4th location application responding slowly.
records in database are far more in each 3 locations compare to the 4th one.

Please tell me what can be the issue..

Code wise i am unable to find.
Is there any problem with database..??

Need your suggestions..

推荐答案

有点难以回答。我想提出一些建议。我希望它有所帮助...



如果我理解正确，那么你在4个地点拥有相同的.net代码，数据库也是如此。现在4个实例中有3个很好。所以第四个很慢是不太可能是由.net代码引起的。



然后它归结为特定数据库实例的缓慢。这可能是由于任何原因。



到目前为止你收集的所有数据库统计数据是什么？它指向什么？如何阻止锁定或长时间运行会话？



托管数据库的服务器上的CPU，内存和磁盘读/写统计信息如何？那个服务器的网络拥塞怎么样？这是VM吗？数据是否驻留在SAN上？



[如果它们适合您，请鼓励参与投票解决方案或答案]

Kinda hard to answer. I am trying to suggest some pointers. I hope it helps...

If I understood correctly then you have the same .net code hosted at 4 locations and so is the DB. Now 3 out of 4 instances are fine. So the 4th one being slow is very unlikely to be caused by the .net code.

Then it boils down to slowness with that specific DB instance. And that can be due to any reason.

What all DB stats have you collected so far? Does it point to anything? How about blocking locks or long running sessions?

How about CPU, memory and disk read/write stats on the server that hosts the DB? How about network congestion from/to that server? Is this a VM? Does the data reside on a SAN?

[Please encourage participation by up-voting solutions or answers if they work for you]

这篇关于C＃applcation用postgresql缓慢响应的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！