Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • 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
 
nemws1Commented:
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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