Urgent! - Simple Query Crawls so Slow!

Last Post 10 May 2002 02:48 AM by satya. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
RSP_SQL
New Member
New Member

--
09 May 2002 06:22 AM
Hi:
I have a SQL Server 7.0 (now upgraded to SP4) on Windows 2000 Adv. Server, dual procs. It seems when I execute a simple query from any client (Query Analyzer) (i.e. Select * from table - has 6200 rows) It takes anywhere from 45secs -2 mins to return all rows. Directly from the server it takes 7-10 seconds. I checked the following:
    Made sure Named Pipes & TCP/IP were enabled

    Entered a client connection for TCP/IP, and Named Pipes, separately on the client PC, tried other clients too.

    Checked index

    Dropped and recreate idx

    Ran query w/ & w/o idx - barely a difference

    Used query idx hint - no difference

    Updated statistics


Finally, on this site, I found a possible bug explained as this:
(After some invetsigation we found a BUG (ID: Q308016)when you use SQL 7.0 with DB-LIBDARY client the "Network Packet Size" is '512' instead of what has been configured on SQL Server. We have contacted Microsoft and received/applied the in our test environment and noticed the performance improvement. )
However, I applied SP4, rebooted, and still the same performance. This is unacceptable. I am ready to rule this a H/W - Network issue. Any other ideas? Please comment! Many thanks.



          satya
          New Member
          New Member

          --
          10 May 2002 02:48 AM
          I had the same problem using Named pipes, but later tried using Multi-protocol which is far better than named pipes.

          But as a common factor it sometimes depends on Network setup.
          You are not authorized to post a reply.

          Acceptable Use Policy