SQL Server 2012存储过程超时。如何解决它?
问题描述:
语境:SQL Server 2012中,在Windows Server 2008 R2(64位),2个核心,大量的内存和硬盘空间, ADODB通过的JScript(不是.NET)SQL Server 2012存储过程超时。如何解决它?
这些非常简单的存储过程保持超时。这并不是说我有很多记录(从服务器的角度来看):100,000左右。
CREATE PROCEDURE [dbo].[Transfer_Part1]
AS
SET NOCOUNT ON
INSERT INTO Primary.dbo.Post
SELECT *
FROM Secondary.dbo.Pre
WHERE HrefProcessed = (-1)
AND ReferrerProcessed = (-1);
CREATE PROCEDURE [dbo].[Transfer_Part3]
AS
SET NOCOUNT ON
DELETE
FROM Secondary.dbo.Pre
WHERE HrefProcessed = (-1)
AND ReferrerProcessed = (-1);
有什么我可以做的,以停止获取这些消息?
[Microsoft][ODBC SQL Server Driver]Query timeout expired
EXEC Transfer_Part1
[Microsoft][ODBC SQL Server Driver]Query timeout expired
EXEC Transfer_Part3
答
你对HrefProcessed和ReferrerProcessed有2列索引吗?
另请参阅Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)第二个。
你对HrefProcessed和ReferrerProcessed有2列索引吗?另请参阅http://*.com/a/2126482/27535第二个。 ANd请添加查询计划和表结构 – gbn 2013-04-24 08:05:13
立即行动!请将您的评论写入答案,我会给你打勾。 – bugmagnet 2013-05-01 03:15:23