raksmart活动促销

分享

写回答

发帖

帮助翻译(英->中)(已解决问题)

 关闭

英文翻译专版 英文翻译专版 1809 人阅读 | 8 人回复

发表于 2009-2-14 01:20:39 | 显示全部楼层 |阅读模式

帮助翻译以下内容,谢了

Hello,

During the recent checkup of SQL Server, Bois an audit was done for the machine's agressive usage. Through SQL Server logs and the SQL Reports it was found that your below database with db user was among of the top five users with respect to higher connections, agressive read, writes over hundread thousands, increasing overall memory usage as well as the SQL Server cpu proc's average waiting time. Since the account exists in the shared hosting environment and such sort of usage has been degrading the server performance so it cannot be allowed to monoplize the system resources as its impacting other clients on the server as we've recieved a lot of complaints about the issue so its currently required that you audit your applications and look for the optimizations.

+------------+-------------+-------+
| name | name | login |
+------------+-------------+-------+
| xxx.com | xxx | xxxx |
+------------+-------------+-------+

We recommend that you establish connection pooling in your scripts, restrict the number of outgoing SQL connections from the application and make sure to close all of the unecessary opened connections after their utilization.

Doing such level of optimization would not only increase the SQL server's performance but will be effective for your applications' better workout, integrity and usability. If your applications' usage is severe or the users using these exceed the normal level or in case the optimizations don't help then we recommend a plan which will provide much higher hosting resources dedicated to your account such as a VPS or a dedicated plan.

We seek for and appreciate your cooperation.
Please do reply and let us know if you need further assistance regarding your applications' usage level.

Many Thanks.

Sincerely,

Abbas Khan.
System Administration Team.

Lunarpages.

回答|共 8 个

hssht

发表于 2009-2-14 10:36:21 | 显示全部楼层

您好

在最近的数据库服务器检查中,发现您的数据连接过大,占用了过多的内存,已影响到服务器上的其他客户,因此我们已经收到了很多投诉问题,其目前需要您审核您的申请,并寻找最佳化。

+------------+-------------+-------+
|名称|名称|登录|
+------------+-------------+-------+
| xxx.com |xxx|xxx|
+------------+-------------+-------+

我们建议在您的程序中,限制了一些已经断开的数据库连接,并确保关闭所有不必要的数据库连接。

做这种程度的优化,不仅增加了SQL Server的性能,而且能提高程序运算效率。如果这些措施无法更改您的数据库负载,我们建议您购买更高配置的主机。

我们争取和感谢您的合作。

如果您需要进一步的帮助信息,请回复。

非常感谢。

此致,

Abbas Khan.
系统管理团队。

Lunarpages 。

评分

参与人数 1威望 +1 银币 +5 收起 理由
kingto + 1 + 5 助人为乐

查看全部评分

kingto

发表于 2009-2-14 10:38:26 | 显示全部楼层

助人为乐

hssht

发表于 2009-2-14 10:45:38 | 显示全部楼层

其实我是用google  然后改了改。。

liucf

发表于 2009-2-14 10:46:13 | 显示全部楼层

谢谢。

liucf

发表于 2009-2-14 10:47:15 | 显示全部楼层

我还有个中->英的帖子,需要各位帮忙啊,谢谢啊
http://bbs.idcspy.com/thread-40704-1-1.html

kingto

发表于 2009-2-14 10:58:09 | 显示全部楼层

您好,已处理

liucf

发表于 2009-2-14 11:01:32 | 显示全部楼层

谢谢了

kingto

发表于 2009-2-15 15:16:02 | 显示全部楼层

您需要登录后才可以回帖 登录 | 注册

本版积分规则