OS is Server 2003 R2 Enterprise Service Pack 2.
SQL is Microsoft SQL Server 2005 - 9.00.3353.00.
I was tasked with troubleshooting the following repeating error:
SQL Server has encountered 30 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\DataBase_data.mdf] in database [DataBase] (8). The OS file handle is 0x00000960. The offset of the latest long I/O is: 0x000000d80d8000
However, I don't know how to troubleshoot "spid4s".
What is the alpha character 's' doing in the spid?
There spid is just the session ID, right?
Session IDs only have numbers.
There is a session 4, but that's been asleep while the error has happened.
It's happened multiple times while I've watched it because of 'SPID4' which I can't even investigate.
Can anyone shed some light for me?