一个存储过程提示：数据库引擎的实例此时无法获得 LOCK 资源

Question

有一个存储过程是这样写的：CREATE PROC P_TEST
AS
TRUNCATE TABLE T1
INSERT INTO T1
SELECT A.a,A.b,A.c,A.d,A.e,B.a,A.f,C.a
FROM A 
LEFT JOIN B ON A.c=B.c
LEFT JOIN C ON A.d=C.d
WHERE B.a<>1 AND B.a<>2
现在在执行时，提示：警告: 聚合或其他 SET 操作消除了 Null 值。
SQL Server 数据库引擎的实例此时无法获得 LOCK 资源。请在活动用户较少时重新运行该语句。请询问数据库管理员，检查此实例的锁定和内存配置，或检查是否有长时间运行的事务。
那位大侠帮忙分析一下原因呢？

Answer 1

应该是T1表 有资源被LOCK导致的

Answer 2

使用sp_lock查询结果如下，这样的结果有问题吗？
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT
10 0 0 DB                                  S GRANT