NonUnique Session IDs

• scudbuster

  Newbie

  Points: 1

  More actions

  May 3, 2002 at 8:41 am

  #78399

  

  This happened on a SQL 2000 server with SP2 installed. I ran the following query, which took approx. 9 minutes to finish.

  Select count(*) from table_name

  While it was running I opened another query analyzer window and did sp_who2 active. The query was the only thing running on the server and it had 3 connections to the database with the same session ID. When I run anything that returns aggregated data then same thing happens. If I run a simple select statement with no aggregation, the results are returned in seconds.

  If anyone has an explanation for the amount of time it takes to run the aggregation or why there are multiple sessions with the same ID, I would appreciate the help. Thanks in advance.

• Andy Warren

  SSC Guru

  Points: 119912

  More actions

  May 3, 2002 at 9:04 am

  #428434

  Did you look at the query plan? Maybe doing parallel processing if you have multi cpu?

  Andy

  Andy
  Connect with me on LinkedIn