|
|
帮助翻译以下内容,谢了
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. |
|