SQL Server数据库冻结 [英] Sql server DB freezes

问题描述

我需要这里的专业建议....

对于我们的一个客户端，数据库是Sql Server2005.我们只有很少的SSIS报告(我想总共是6个)可以查询数据库并生成.xls报告.这是一项日常任务.

由于生成报告所需的时间很少(我猜是5至6分钟)，因此所有6个报告总共需要30分钟.在此期间，它几乎阻塞了数据库流量，并且从.net应用程序连接数据库的任何其他用户的速度实际上都将变慢(几乎冻结).

处理这种情况的最佳方法是什么?在接下来的6个月中，DB的大小将几乎是我们今天的大小的两倍.

是否建议将主数据库还原到新数据库上(每天在第一个报告开始之前)并报告要连接到该新数据库?这样，我们可以为应用程序用户释放主数据库.

或者，如果有更好的建议，请....

谢谢
Arun

Hi,

I need a expertise suggestions here....

for one of our client, the database is Sql Server 2005. and we have few SSIS reports (i guess 6 in total) which would query the database and generate .xls reports. this is a daily scheduled task.

as the generation of the reports takes little time (I guess 5-6 mins) so in total 30 mins for all the 6 reports. during this time, it almost blocks the db traffic and any other users who has connected the DB from the .net application would be real slower (almost freezing).

what is the best way to handle this situation. for the next 6 months the DB size would be almost double the size than what we have today.

is it recommendable to restore the main db on new db (daily before the first reports kicks off) and reports to connect to this new db? in this way we can free the main DB for the application users.

OR if any better suggestions please....

thanks
Arun

推荐答案

我通常将报告安排在低"流量期间运行.同样，我将确保在给定时间仅运行1个报告.只有六个，您可以在不到一个小时的时间内运行它们，并且在启动时间之间有缓冲时间，从而减少了负载并减少了对应用程序的影响.

I typically have reports scheduled to run during periods of "low" traffic. As well, I would ensure that only 1 report runs at a given time. With only six, you could run them in under an hour with buffer time between start times, thus reducing the load and impact on your applications.

这篇关于SQL Server数据库冻结的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！