SQL性能问题 [英] SQL Performance Issue
问题描述
大家好，
我在生产服务器中遇到一个大问题。
从过去3天开始，我们的应用程序无法运行正确的，服务器表现得太差了。
让我详细说明
生产服务器详细信息。
实际Ram 28 GB
64 bit
2.26GHZ 2处理器
用法历史
使用物理内存21.8 gB
CPu Uasage 20％到50％
运行的数据库总数
差不多5
我们的客户说只有你的应用程序不能正常工作。
我们的系统已经上线了1年。
1年后我们面临这个问题。
有时用户无法执行复杂的查询。
上次我们重新启动服务器时，一切都开始工作了但是6小时后我们又遇到了类似的问题。
有人请帮忙。
我会回答你的所有问题。
问候，
SUNIL MALI。
Hello all,
I am having one big issue in our production server.
From last 3 days our application is not working correctly, server is behaving too badly.
Let me expalain in detail
Production Server Details.
Actual Ram 28 GB
64 bit
2.26GHZ 2 Processors
Usage History
Physical Memory utilized 21.8 gB
CPu Uasage 20 to 50%
Total Databases Running
Nearly 5
Our client is saying only your application is not working other than that whatever is there its working.
Our system is live and its been 1 year.
After 1 year we are facing this issue.
Sometimes users are not able to perform complex queries.
Last time we restarted server everything started working but again after 6 hours we had similar issue.
Somebody please help.
I will answer all your question.
Regards,
SUNIL MALI.
推荐答案
我们甚至无法从中回答：我们完全不知道你在做什么。
特别是当你说总数据库运行：接近5这很愚蠢。
你需要看看你的代码在做什么，它正在运行什么查询，在哪里它正在运行。如果它在与数据库相同的服务器上运行，那么它可能只是因为你没有发布内容而只是hoggin内存，或者你可能不是像图形上下文和数据库命令对象一样处理稀缺资源 - 我们可以不要在你的应用程序中查看好的细节。
我首先在你的开发环境中运行它并重复问题 - 因为在那之前你可以'无论如何你一定要修好它！
We can't even begin to answer that from that: we have absolutely no idea what you are doing.
Especially when you say "Total Databases Running: Nearly 5" which is plain silly.
You need to look at what you code is doing, what queries it is running, where it is running. If it is running on the same server as the database, then it could be that it is just hoggin memory because you aren't releasing things, or you could be not Disposing on scarce resources just as Graphics contexts and Database Command objects - we can't tell without looking in good detail at your application.
I'd start by running it in your development environment and duplicating the problem - because until then you can't be sure you'd fixed it anyway!
这篇关于SQL性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
