1--it will give you the SPID‘s for all your processes. 2EXEC sp_who
34--which will terminate SPID 425KILL422015，fighting for myself,my dear darling,my family, ~O(∩_∩)O~。原文：http://www.cnblogs.com/L-may/p/4629151.html
-- 查询死锁
select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks
where resource_type=‘OBJECT‘ --杀死死锁进程
kill spid原文：http://www.cnblogs.com/ydj0208/p/6036897.html
--it will give you the SPID‘s for all your processes.
2 EXEC sp_who
3
4 --which will terminate SPID 42
5 KILL 422015，fighting for myself,my dear darling,my family, ~O(∩_∩)O~。SQL SERVER 查看并结束某个进程标签：本文系统来源：http://www.cnblogs.com/L-may/p/4629151.html
SPID = er.session_id
,Status = ses.status
,[Login] = ses.login_name
,Host = ses.host_name
,BlkBy = er.blocking_session_id
,DBName = DB_Name(er.database_id)
,CommandType = er.command
,SQLStatement = st.text
,ObjectName = OBJECT_NAME(st.objectid)
,ElapsedMS = er.total_elapsed_time
,CPUTime = er.cpu_time
,IOReads = er.logical_reads + er.reads
,IOWrites = er.writes
,LastWaitType = er.last...
SELECT [Spid] = session_Id, ecid, [Database] = DB_NAME(sp.dbid), [User] = nt_username, [Status] = er.status, [Wait] = wait_type, [Individual Query] = SUBSTRING(qt.text, er.statement_start_offset / 2, (CASE WHEN er.statement_end_offset = - 1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2 ELSE er.statement_end_offset END - er.statement_start_offset) / 2), ...
这是我在使用Visual Studio 2008开发平台时遭遇的报错。这个错误是在服务器资源管理器中添加连接，加载数据库文件时发生的错误。
什么鬼？？？当时很纳闷，我以前从来没见过这样的奇葩问题啊？一直都是顺利通过啊？我百度了一下，网上有些说法，什么什么“登录超级管理员删除Local/AppData/。。。。bla bla bla……文件夹，重启就可以啦”什么的，我费半天劲照做了，毛用也不管。不知道是我人品欠费了，还是这一招本来就不太灵，...
解决SQLSERVER2008 CPU使用率99%：1、dbcc checkdb 重建索引
2、檢查有沒有死鎖
-- sp_lock SELECT request_session_id spid , OBJECT_NAME(resource_associated_entity_id) tableName FROM sys.dm_tran_locks WHERE resource_type = ‘OBJECT‘-- kill spid 解除死锁kill 58
到这里查看一下CPU使用率，发现已经降下来恢复正常了SQLSERVER进程CPU使用率100%标签：本文系统来源：http://www.cnblogs.com/lykb...
检测到PostgreSQL Server进程 down 的时候启动，running状态无动作# more pg_server_check.sh #!/bin/shexport PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/binprefix=/etc/init.dDAEMON="$prefix/postgresql"RUNN_STR="server is running"Pg_Status=`$DAEMON status|grep "$RUNN_STR"`LOG_PATH=/opt/cronCHECK_LOG=$LOG_PATH/pg_server_check.logError_log=$LOG_PATH/pg_server_check_Error.logecho "$Pg_Sta...
http://www.sqlservercentral.com/blogs/aschenbrenner/2014/05/05/sql-server-debugging-with-windbg-an-introduction/
http://blog.csdn.net/edison0621/article/details/7750806Windbg调试Sql Server 进程标签：.net cbo http 调试 debug rod server 1.5 int 本文系统来源：http://www.cnblogs.com/zengkefu/p/6713145.html
--查看数据库中表的语句
SELECT s2.dbid ,DB_NAME(s2.dbid) AS [数据库名] ,--s1.sql_handle ,( SELECT TOP 1SUBSTRING(s2.text, statement_start_offset / 2 + 1,( ( CASE WHEN statement_end_offset = -1THEN ( LEN(CONVERT(NVARCHAR(MAX), s2.text))* 2 )ELSE statement_end_offsetEND ) - statement_start_offset ) / 2 + 1)) AS [语句] ,execution_count AS [执行次数] ,last_execution_time AS [上次开始执行计划的时间] ,t...
select * from master.dbo.sysprocesses where DB_NAME(dbid)=’test’ and spid<>@@SPID 看看阻塞的进程 然后kill掉就行了 exec(‘kill ’ +@spid)
由于我是远程连接的数据库，杀死进程总会有顾虑。所以我就关闭了客户端，然后重启了之后就可以了。 select显示我有两个进程一直处于runnable的状态 显示的是在执行SELECTsqlserver 查询当前阻塞进程 并杀掉标签：sse master target ble 知识库 rom bsp 阻塞 关闭 ...
use mastergo--检索死锁进程select spid, blocked, loginame, last_batch, status, cmd, hostname, program_namefrom sysprocesseswhere spid in( select blocked from sysprocesses where blocked <> 0 ) or (blocked <>0)
kill spidsql server 数据库 杀掉死锁进程标签：死锁 lock 检索 ast pid rom use login master 本文系统来源：http://www.cnblogs.com/dxqNet/p/7419579.html
解决办法：
将关联的sql server（实例） 服务停止。
然后启动sql server代理 服务。Windows无法启动SQL server 代理服务（服务器）错误1067:进程意外终止标签：bsp sql post 代理服务 log tle 实例 clear pos 本文系统来源：http://www.cnblogs.com/ZqNote/p/7420156.html
SQLserver 进程被死锁问题解决标签：img 隔离 data ble 数据库事务 snap snapshot 分享 server 本文系统来源：http://www.cnblogs.com/yuejin/p/7739302.html
spid,blocked,DB_NAME(sp.dbid) AS DBName,program_name,waitresource,lastwaittype,sp.loginame,sp.hostname,a.[Text] AS [TextData],SUBSTRING(A.text, sp.stmt_start / 2, (CASE WHEN sp.stmt_end = -1 THEN DATALENGTH(A.text) ELSE sp.stmt_end END - sp.stmt_start) / 2) AS [current_cmd]
FROM sys.sysprocesses AS sp OUTER APPLY sys.dm_exec_sql_text (sp.sql_handle) AS A
WHERE spid > 50
ORDER BY blocked DES...
SPID = er.session_id
,Status = ses.status
,[Login] = ses.login_name
,Host = ses.host_name
,BlkBy = er.blocking_session_id
,DBName = DB_Name(er.database_id)
,CommandType = er.command
,SQLStatement = st.text
,ObjectName = OBJECT_NAME(st.objectid)
,ElapsedMS = er.total_elapsed_time
,CPUTime = er.cpu_time
,IOReads = er.logical_reads + er.reads
,IOWrites = er.writes
,LastWaitType = er.last_wait_type
,StartTime = er.start_time
,Protocol = con.net_transport
,ConnectionWrites = con.num_writes
,ConnectionReads = con.num_reads
,ClientAddress = con.client_net_address
,Authentication = con.auth_scheme
FROM sys.dm_exec_requests er
OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) st
LEFT JOIN sys.dm_exec_sessions ses
ON ses.session_id = er.session_id
LEFT JOIN sys.dm_exec_connections con
ON con.session_id = ses.session_id
WHERE er.session_id > 50
ORDER BY
er.blocking_session_id DESC
,er.session_id