MSSQL SPID process mix with another SPID process

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hello all, this is my first post ever since I joined this community. Sorry for my poor English.

Imgur: The most awesome images on the Internet[^]

refer to the above image link:
SPID 51 was doing insert statement
SPID 60 was doing update statement

I have no ideas how come SPID 60 can out of sudden execute the insert statement which suppose to be execute by SPID 51

What I notice from the trace is that each SPID will have Audit Login, RPC Completed, Audit Logout. But SPID 51 just missing the Audit Logout.

If I run the sp_who2, it will show SPID 60 is blocked by SPID 51
If I run report from SSMS, it shows SPID 51 isolation "Unknown"

I wonder how can this happen? Could network issue causing this? Please help me, thank you.

What I have tried:

Since I have no idea how this happen so I have not try any way to solve it

Posted 7-Apr-16 23:11pm

nethelp11

Updated 8-Apr-16 1:13am

Add a Solution

Comments

RickZeeland 8-Apr-16 6:27am

I guess it's normal, when I use SQL Server 2008R2 with ExpressProfiler it shows different SPID's too for the same .NET application. Other databases use multiple threads too.
I can not think of a way to prevent this, sorry !

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2016-04-08T01:13:00

Maybe you can set the "Max Degree of Parallelism" to 1, in general this is not recommended though, but if you must ...
How to: Configure the Number of Processors Available for Parallel Queries (SQL Server Management Studio)[^]

Here is an example of setting the MAXDOP query hint:

SQL

USE AdventureWorks2008R2 ;
GO
SELECT ProductID, OrderQty, SUM(LineTotal) AS Total
FROM Sales.SalesOrderDetail
WHERE UnitPrice < $5.00
GROUP BY ProductID, OrderQty
ORDER BY ProductID, OrderQty
OPTION (MAXDOP 1);
GO