Close
  • Tech Blog
  • About
×
×
  • Tech Blog
  • About
Menu & Search
Peter Whyte
Tag

SQL Server Processes


Killing SPIDs SQL Server
July 1, 2018
SQL Server
More on SPIDs… and Killing Them

While looking at an old script today, one that kills SPIDs on a SQL Server database… I had an instant urge to try kill a system SPIDs, just to see what would happen.

Read More
Logging sp_whoisactive to a table
May 21, 2018
SQL Server
Logging sp_whoisactive to a Table

This is a follow-on post of sp_who, sp_who2 & sp_whoisactive and is a run-through of logging SQL Server activity to a table, using the sp_whoisactive stored procedure.

Read More
May 21, 2018
SQL Server
sp_who, sp_who2 & sp_whoisactive

Sp_whatnow? sp_who, sp_who2 and sp_whoisactive are stored procedures that allow you to view current users, sessions, and processes within a SQL Server instance.

Read More
Kill SQL Server SPIDs
April 17, 2018
SQL Server
Killing SQL Server Processes (SPIDs)

There are many reasons why you’d KILL a SPID in SQL Server. Whether it’s impending disk space doom due to data or log file bloat, or a long running query that’s lost in space…

Read More

Blog Menu

  • Homepage
  • All Posts (Grid)
  • All Posts (List)
  • Index
  • Traffic
  • Scripts
  • Notes

Categories

  • AWS (2)
  • Linux (15)
  • MySQL (4)
  • PostgreSQL (5)
  • PowerShell (23)
  • RedShift (5)
  • Scripts (1)
  • SQL Server (53)
  • Windows (36)
  • WordPress (5)

Tags

Certificates & Encryption (3) CSV Files (3) Database Admin (35) Database Backups (5) Data Types (2) Deleting Data (2) Error Messages (4) Exporting Data (1) Featured (6) Git (6) Importing Data (1) Installing SQL Server (8) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (7) Restoring Databases (4) SQL Server Agent (3) SQL Server ETL (2) SQL Server Management Studio (9) SQL Server Processes (4) SQL Server Scripts (2) Windows Admin (9) WordPress Technical Issues (2) WordPress Tutorials (3) WSL (6)