Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    Sunnyvale, CA USA
    Posts
    78

    Unanswered: Query Analyzer very slow for even trivial queries

    I've been using MS-SQL Server for many years but never come across this problem before.

    When I try and run a very simple query from Query Analyzer it takes a LONG time. Even when there are no tables involved!

    Even:-

    select 1
    go

    takes 28 seconds to return '1' when running against the local server. i.e. both QA and the Server are running on the same machine.

    Can anyone help explain how to get my performance back! Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Can I explain it?

    No

    Can I probably fix it?

    Yes

    Reboot the client
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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