25112
asked on
kill process can restart sql instance service?
when trying to troubleshoot why templog (not data) file would not free itself up, checking on a process that was running for 14 hours, i did a kill command on that spid.. as soon as i did that the sql instance restarted (i lost connection and then later in a minute i can see that the instance rebooted)..
is it possible a kill command cause the restart of the instance? this is sql 2005. (9.00.5057.00)
is it possible a kill command cause the restart of the instance? this is sql 2005. (9.00.5057.00)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK- thanks.
ASKER
the process i killed had the ASYNC_NETWORK_IO wait status on sysprocesses.
this process was running a stored proce, whose code is below:
CREATE PROCEDURE [dbo].[RASPubData]
AS
BEGIN
SET NoCount ON
SELECT Nominee.BranchFK
, IsNull(PERS.Name1, '...Nominee is Not in table') as InstName
, PAC.FunctionAreaCode as FnCode
, Group.GroupNumber as GrpNbr
, Group.GlobalYear
, Group.GroupStatusCodeFK as [Status]
, Convert(decimal(11,2), Group.AllotmentAmount) as Allotment
, Convert(decimal(11,2), Group.PaidToDateAmount) as PaidToDate
--
FROM dbo.tblGroupStatusCode P_Status
JOIN dbo.tblGroup Group
ON Group.GroupStatusCodeFK = P_Status.GroupStatusCodePK
JOIN dbo.tblNominee Nominee
ON Nominee.NomineePK = Group.NomineeFK
JOIN dbo.tblFunctionAreaCode PAC
ON PAC.FunctionAreaCodePK = Group.FunctionAreaCodeFK
JOIN dbo.tblFunctionCtgyCode PCtgy
ON PCtgy.FunctionCtgyCodePK = PAC.FunctionCtgyCodeFK
JOIN dbo.tblApplicationTypeCode
ON AType.ApplicationTypeCodeP
LEFT
JOIN dbo.tblPERSNominee PERS
ON PERS.NomineeFK = Nominee.NomineePK
WHERE Convert(int, Group.GlobalYear) >=
CASE
WHEN Month(GetDate()) < 7
THEN Year(GetDate()) - 3
ELSE Year(GetDate()) - 2
END
AND Group.EndDate IS NOT NULL
AND 0 <
CASE Group.GroupStatusCodeFK
WHEN 'C'
THEN Group.AllotmentAmount + Group.PaidToDateAmount
ELSE 1
END
AND AType.ApplicationTypeCode = 'PDS'
ORDER BY
Nominee.BranchFK
, Group.GlobalYear
, PAC.FunctionAreaCode
, Group.GroupNumber
END