为什么sqlserevermanagementstudio打开后会引起数据库阻塞

更新时间2019-05-01 09:22:08

进程号SPID：3550被进程号SPID：2835阻塞，数据库为：tempdb,IP地址进程名：Microsoft SQL Server Management Studio - Transact-主机名: 网卡地址，其当前进程执行的SQL语法如下

阻塞语句如下

SELECT

tr.name AS [Name],

tr.object_id AS [ID],

CAST(

tr.is_ms_shipped

AS bit) AS [IsSystemObject],

CASE WHEN tr.type = N'TR' THEN 1 WHEN tr.type = N'TA' THEN 2 ELSE 1 END AS [ImplementationType],

CAST(CASE WHEN ISNULL(smtr.definition, ssmtr.definition) IS NULL THEN 1 ELSE 0 END AS bit) AS [IsEncrypted]

FROM

sys.triggers AS tr

LEFT OUTER JOIN sys.sql_modules AS smtr ON smtr.object_id = tr.object_id

LEFT OUTER JOIN sys.system_sql_modules AS ssmtr ON ssmtr.object_id = tr.object_id

WHERE

(tr.parent_class = 0)

ORDER BY

[Name] ASC

1/如果SQL服务都启动，并且配置OK，就剩下网络的问题。2/在服务器名称栏位填写本机IP，身份验证选择windows身份验证试试。3/另外检查：打开[SQL Server 配置管理器]<在运行中输入SQLServerManager.msc回车>-->双击[SQL Server]服务-->打开[属性]对话框，检查登录身份是否为本地系统。如果不是选择内置账户，local system。-->重启sql服务。