SQL Server Performance

Sql server query runs slow on IBM server ? Urgent

Discussion in 'Performance Tuning for DBAs' started by sameersk, Jan 7, 2003.

  1. sameersk New Member

    We have a IBM server Raid 5 with windows NT sp6a os, we have installed SQL Server 7.0, now when we are executing a query in Query analyzer with the query analyzer in a maximized state the query takes nearly 30 sec to execute but the same if run with the Query analyzer in minimized state then the query executes in 12 sec. The records returned by the query is around 50 to 60 thousand records, this query is just for testing performance.

    I need help in this regards urgently. is it something to do with hardware / installation of OS or Sql server.
  2. Chappy New Member

    Sounds like a very odd problem, I dont envy you <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br />What sort of memory is the server equipped with, and is it running any other s/w apart from SQL server?<br />When you maximise QA after running the query minimised, does it maximise and display the records instantly ?
  3. satya Moderator

    How do you connect to server from QA, specify by using local instead of specifying name. Also as Chappy said you need to check couple of things to be referred.

    Satya SKJ
  4. bradmcgehee New Member

    On the server itself, do you have it set to optimize performance for services for for applications? It needs to be set to be optimized for services. Also, what is the buffer cache hit ratio?


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  5. joechang New Member

    is query analyzer in "results in grid" or "results in text"
    one possibility is the delay is in the QA, not the server
    results in text can be very slow for large row counts
  6. x002548 New Member

    I know it doesn't address your issue, but what does the statement look like?

Share This Page