Results 1 to 13 of 13
  1. #1
    Join Date
    Jan 2003
    Posts
    30

    Unanswered: SQL do not answer

    Hi Guys...

    I have a Internet Sevice running under IIS + SQL Server.

    Frequentily the SQL stop to answer and CPU usage stay between 0% and 10% for about 5 minutes... after that it answer again.

    Some times I need to stop SQL and start again to resolve.

    Any help?

  2. #2
    Join Date
    Apr 2003
    Posts
    12
    I know this kind of issue can drive you nuts but there is no clear answer.
    My first guess is that there is something work with the hardware.

    Pick up a good book about sql server performance like

    Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
    by Ken England

    Good luck!

  3. #3
    Join Date
    Jan 2003
    Posts
    30

    Question

    Thanks buckley!

    See a image of the Task Manager in the moment that problem happen.

    http://www.patroni.brturbo.com/index.html

    In time.. I´m using SQL 7.0

    Please... any help will be wellcome.

  4. #4
    Join Date
    Jan 2003
    Posts
    30

    Question

    Let me explain the problem a litlle bit for you try to help me:

    I have a Internet Service running in two machines.
    Server #1 - Win 2000 + IIS
    Server #2 - Win 2000 + SQL 7.0

    IIS answer for 2 domains:
    www.domainone.com.br and www.domaintwo.com.br

    domaintwo doesn´t stop to answer (it is a small service with litlle access).

    domainone stop to answer frequentily. IIS error is Timeout.
    But when it stops to answer, I still can run queries on the Query Analyzer from my machine... and domaintwo answers normaly.

    Any help?

  5. #5
    Join Date
    Apr 2003
    Posts
    12
    I use that setup too : 1 server with iis and 1 with SQL server (2000)

    So when site 1 times out the other which uses the same sql server works fine? Thats a real mystery. This makes me think there's something wrong at iis side.

    Can you give me the exact error messages that iis returns? A time out can also occur on IIS (default 20 sec) and not only on sql server. The screenshot dont tell a lot, they only confirm what you told me. We must be 100% sure that the problem lies with sql server or with one of the subsytems (I/0,memory,...)

    I am trying to help but its very difficult if i dont have access to the server. Can you move the sql server to antother machine, maybe your desktop? If the problem doesn't accore on this setup I think its machine related. I had my share of problem with bad hardware servers and when i switched to one i had more confidence in they went away.

  6. #6
    Join Date
    Jan 2003
    Posts
    30
    Hello buckley...

    Back and with the problem yet.

    I was thinking if this problem isn´t because the IIS open a lot of connections in SQL? Every page is another conection openned...

    There is 3 ways to make SQL answer again...

    1.To wait.. for 2 or 3 minutes;
    2.Stop and restart SQL Server;
    3.Reboot the IIS Server.

    Please... someone help me with this problem...

    Thanks,

  7. #7
    Join Date
    Apr 2003
    Posts
    12
    When I see sql server answer slowly I first start up profiler. This is a tool thats installed together with sql server and shows you all the queries that SQL server handles. Watch for the duration of the query. This is not the same as CPU. I note this because CPUT is at max 10%.

    Is it the machine or the service you restart When you rebooting the IIS server?

  8. #8
    Join Date
    Jan 2003
    Posts
    30
    The SQL doesn´t begin to answer slowly..

    It just stop to answer... for 1,2 or 3 minutos... and then back do answer.

    If I just stop IIS nothing hapend.. but if I reboot the machine, then the SQL start to answer when the IIS Server start again.
    Last edited by Loas; 05-02-03 at 14:28.

  9. #9
    Join Date
    Apr 2003
    Posts
    30
    when the server stopped responding, select * from master.dbo.sysprocesses to see what happening there. My guess is that some process are doing extensive I/O to harddisk. Or use PROFILER is a good idea to try.

  10. #10
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Best bet is to capture counters using PERFMON for h/w and SQL.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  11. #11
    Join Date
    May 2003
    Location
    Amsterdam, the Netherlands
    Posts
    4

    SQL Server Timout

    There is a time-out problem reported when SQL Server is expanding it's data-files. I don't know if there is many data added using the website, but SQL Server is know to give a time-out when increasing/decreasing the size of the datafile takes too much time... You can control this option by using smaller values for the Auto Grow / Auto shrink options...

  12. #12
    Join Date
    Jan 2003
    Posts
    30
    Thanks fot the help guys...

    I will try this tips...

  13. #13
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    Check the number of open connections.
    Check that you're closing connections properly in your applications.

    Actually, the fact that you can access SQL Server from QA says that it is ok. so the problem could be either in IIS or in connection between them (or I am wrong).

    To be sure, check Application Logs for both computers as well as SQL Server Error Log.
    --
    kukuk

Posting Permissions

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