Results 1 to 8 of 8

Thread: Slow response when connected to remote server

  1. 10-25-2002, 01:13 PM #1
    vangaram
    vangaram is offline Registered User
    Join Date
    Oct 2002
    Posts
    4

    Slow response when connected to remote server

    Can anyone advise? our SQL7 server system running on a Compaq ML570 twin processor box under NT4 sp6 takes an age for a Laptop Compaq EVO with OS win2k running enterprise manager to connect. (I have opened this web site and written this much and I am still waiting for the list of databases...and the enterprise manager is will not respond until it show tthe list)

    There are no disk space issues, on server or laptop. My laptop has 1023 mb Mem.
    The network speed is 100 mb/sec

    The network protocols used \ installed are the default named pipes, and TCPIP. Changing the client configuration to use one or 5the other makes no difference.
    Please help!!!
    Reply With Quote Reply With Quote
  2. 10-25-2002, 02:46 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What's network speed? How about query analyzer's response time?
    Reply With Quote Reply With Quote
  3. 10-25-2002, 02:56 PM #3
    vangaram
    vangaram is offline Registered User
    Join Date
    Oct 2002
    Posts
    4
    The network speed is 100 MB/SEC
    The query analyzer execution time is 40 Milliseconds for a query which normally takes 1 millisecond in another desktop in the same network.
    every time when I try to view a table properties, view properties or just run simple query the enterprise manager, query analyzer hangs until it gets the results and the time it takes to get the results is longer then the normal. It is happing same with the local servers too.
    Please help!!!
    Reply With Quote Reply With Quote
  4. 10-25-2002, 03:51 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Did you try connect with ip address?
    Reply With Quote Reply With Quote
  5. 10-25-2002, 04:34 PM #5
    vangaram
    vangaram is offline Registered User
    Join Date
    Oct 2002
    Posts
    4
    I just tried. Same old probleem.
    Tahnk you for you response.
    Reply With Quote Reply With Quote
  6. 10-29-2002, 10:33 AM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    May setup network monitor session to see if anything happens on the network, or setup sql trace with profiler.
    Reply With Quote Reply With Quote
  7. 10-29-2002, 07:02 PM #7
    vangaram
    vangaram is offline Registered User
    Join Date
    Oct 2002
    Posts
    4
    Tried every thing. No change. Is this a Laptop Problem. My laptop is Compaq EVO, With 1,047,920 MEMORY. When I run a query my DISK Icon blinks and make sound, as it is working very hard ! @ # %^^...
    Reply With Quote Reply With Quote
  8. 10-30-2002, 10:49 AM #8
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Did you try perfmon on your laptop? How big is paging file?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules