Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-17 : 15:04:02
|
| Gokhan writes "What would be the main reason for sqlserver to create duplicate process IDs? I am getting the same "spid" created 10 times on the server. This is also createing huge performance issues. Thanks!" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-17 : 18:05:11
|
| I doubt that is what's creating your huge performance issues. Multiple SPIDs will be used on multi-processor systems to utilize parallelism and multi-threading of processes. Bad performance is usually caused by poorly designed stored procedures or design. What are the processes doing when they are utilizing multiple threads?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-17 : 18:14:49
|
| One of them will have ecid = 0 and that will be the main thread.You can set the server to use a single processor per query so that this doesn't happen.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-17 : 18:33:51
|
| But you need to be careful with this. It can also ruin the performance on your applications. Better to target given queries and set maximum degree of parallelism to 1. This will have the effect you are looking for.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Duplicate Process ID?