Home Forums SQL Server 2008 SQL Server Newbies Alpha character in SPID? Disk I\O Bottleneck Troubleshooting. RE: Alpha character in SPID? Disk I\O Bottleneck Troubleshooting.

  • So, SPID4 is reporting the problem, not necessarily the cause of the problem?

    SPID 4 is Lazy Writer.

    Am I correct in assuming that because of the 'S' in the SPID that SPID 12 'CHECKPOINT' would be reported as '12S'?

    Or is it the fact that it involves a Windows process that invokes the 'S'?