Solved

kill process can restart sql instance service?

Posted on 2013-05-29
3
494 Views
Last Modified: 2013-06-04
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
Comment
Question by:25112
  • 2
3 Comments
 
LVL 5

Author Comment

by:25112
ID: 39205566
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
 
LVL 23

Accepted Solution

by:
nemws1 earned 500 total points
ID: 39206050
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
 
LVL 5

Author Comment

by:25112
ID: 39219242
OK- thanks.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question