Smashing a DMV Myth: session_id > 50 == User Process

(Adam Machanic) Ever since I started working with SQL Server, I’ve been seeing advice to filter system views based on session identifiers, in order to return only user processes. The general advice is to look for session IDs (or SPIDs) greater than 50. And this seems relatively safe if you look at t

Read More - Register for Free Membership