Solved

kill process can restart sql instance service?

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

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…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

914 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

21 Experts available now in Live!

Get 1:1 Help Now