• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • Last Modified:

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)
0
25112
Asked:
25112
  • 2
1 Solution
 
25112Author Commented:
while templog was fully using the 5GB, the data file was using only 14MB.

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  AType  
    ON AType.ApplicationTypeCodePK = PCtgy.ApplicationTypeCodeFK  
  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
0
 
nemws1Database AdministratorCommented:
It definitely should not.  If you're doing the KILL command via SQL (as you did here), it should kill that *thread* but leave the rest of the server alone.

Sounds like a bug, but since you're running 2005, I'd guess its already been fixed and MS will just tell you to upgrade.
0
 
25112Author Commented:
OK- thanks.
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now