SQL查询速度慢-需要重新启动服务 [英] SQL Query is Slow - Service Restart required

问题描述

你好，

我们拥有一个在SQL Server 2008上运行约60万行的数据库.我们正在运行一个LAN应用程序，该应用程序是最近从非常高速的服务器市场上购买的.但是有时候SQL Server变得非常慢.例如:-在星期一早上，当我们返回工作时[我保证sql server闲置了大约48小时...可能是服务关闭或某些原因...].如果我们再次从控制面板重新启动SQL Server服务，它将正常运行.在这方面有人可以帮助我吗????

这只是一个数据库服务器，除了我们在该计算机上没有运行任何服务器.

配置:-多核处理器
内存:-32 GB

局域网卡:-10/1000

局域网:-光纤

chowdary.

Hello,

We are having a data base with around 600,000 rows running on SQL server 2008. We are running a LAN application, bought recently from market of very high speed server. But some times SQL Server is getting very slow. For ex:- on Monday morning when we return to work [I assue that sql server is idle for about 48 hours... and may be services are down or some thing...]. If we restart the SQL server Service from control panel again it is working as it should. Can anybody help me in this regard????

This is only a database server, except this we are nothing running on this machine.

Configuration :- Multi core processor
Ram : - 32 GB

LAN Card :- 10/1000

LAN :- Optical fibre

chowdary.

推荐答案

请优化您的数据库，存储过程，因为这样的配置仅对600万行有效.时间，然后将这些查询粘贴到此处..

以及您可以使用事务隔离级别或锁定提示来提高性能.

问候，
继续帮助大自然.

Please optimize your database, stored procedure because such configuration runs good for just only 6000000 rows.. as well can u use profiler to check where exactly it takes time and paste those queries here..

As well as u can use Transaction Isolation Level OR Lock Hints to improve performance.

Regards,
Keep helping nature..

这篇关于SQL查询速度慢-需要重新启动服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！