Solved

kill process can restart sql instance service?

Posted on 2013-05-29
3
490 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

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 …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now