Process ID 108 was killed by hostname RAM1234, host process ID 7404.

 

What each part means

Process ID 108

• This is SQL Server’s internal process ID (not the same as SPID).

• It usually maps to a worker or session inside SQL Server that was terminated.

• You normally don’t troubleshoot this ID directly; it’s mostly for internal tracking.
  
  

  “was killed by hostname RAM1234”

  • RAM1234 is the client machine name from which the kill originated.

  • This is not the SQL Server host.

  • It is typically:

    • An application server

    • A user workstation

    • A job agent / automation server

    • Or sometimes the SQL Server itself, if a local process did it

  👉 So yes — in most cases this is the server where the application is running or where someone was connected from.
  
  

  Host process ID 7404

  • This is the Windows OS process ID (PID) on RAM1234.

  • It represents the client-side process that issued the KILL or caused the disconnect.

  • Examples of what PID 7404 could be:

    • sqlcmd.exe

    • powershell.exe

    • An application service (Java, .NET, etc.)

    • SSMS (ssms.exe)

    • A monitoring or deployment tool

  SQL Server logs the PID as reported by the client OS.
  
  

  Common reasons you see this message

  1. Someone ran KILL <spid>

     • From SSMS or a script on RAM1234

  2. Application forcibly closed the connection

     • App crash

     • Connection pool cleanup

     • Timeout logic

  3. Automated job / monitoring tool

     • Health check scripts

     • Maintenance automation

     • DevOps pipelines

  4. Failover / restart scenario

     • Client connections get killed during recovery or role change

  
  

SQL Query

SELECT
session_id,
host_name,
program_name,
login_name
FROM
sys.dm_exec_sessions
WHERE
host_name
=
'RAM1234';
  

SQL Query

SELECT
*
FROM
sys.dm_exec_requests







December 20, 2024













 Run the full code from Load assembly section. # Load the assembly  #[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") | Out-Null  # Create the server object  $server  = New-Object  Microsoft.AnalysisServices.Server  $server . Connect ( "localhost" )  # Or your SSAS instance name    #Date Converion with minutes and seconds   $date  = ( get-date ).ToString( "MM_dd_yyyy_hh_mm_ss" )  $Server  = New-Object  Microsoft.AnalysisServices.Server  $Server .Connect( "MAPS\TEST" )  $dbservers  = $Server .Databases| Select-Object  Name,ParentServer  $dbservers | ForEach -Object{  $inddb  = $_   #The "Backup-AsDatabase" is especially for SSAS cube backup and downloaded from "SQLServer" powershell module   Backup-ASDatabase -BackupFile "E:\MAPS_TEST\SSAS_BACKUP\NEW\ $( $ inddb.Name) _ $( $ date) .abf"  -Name $inddb .Name -Verbose -Server $inddb .ParentServer  Write-Host  "SSAS cube backup [ $( $ i...





Read more