Re: Strange problem?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Umut Nazlica (UmutNazlica_at_discussions.microsoft.com)
Date: 07/07/04 

Date: Tue, 6 Jul 2004 23:37:02 -0700

Hi,

Yes on your IIS server, if you are connecting to your db with ODBC offcourse..

"dotNet" wrote:

> Hi!
>
> Thanks for the article!
>
> What odbc logging are you talking about? IIS on the webservers?
>
>
>
> Umut Nazlica wrote:
>
> > Hi,
> >
> > I'm not sure if it's related with your problem but i had similar problem before, same query is working great when i execute it on my qa but when the application executes it ,it timeouts.
> > Then i noticed that obdc logging is enabled on the server.I disabled it and that was fixed my problem.
> >
> > And i recommend a great article which written by Tom Davidson called Performance Tuning Toolbox. (If you have access to SQL Server Magazine Doc Id is 40925). There you can find two sp's that will analyze your wait statistics. That will give you a better idea about where the botlleneck is.
> >
> > Regards.
> >
> >
> >
> > "dotNet" wrote:
> >
> >
> >>Hello!
> >>
> >>We have a strange problem with our sql-server.
> >>
> >>When I run a query in QA it works perfect but when I execute it through
> >>my ASP-page with conn.execute() it timeouts.
> >>
> >>It doesnt help to restart the webserver, but a restart of the sql-server
> >>do help.
> >>
> >>This problem occours in the morning when the query amount is rather low
> >>and that is even more strange, as I see it.
> >>The only connection that I can think of is that this problem occours
> >>during or after that we have run the backup.
> >>
> >>The problem often fixes itself and about 7am there is no problem any
> >>more. But today the problem was worse and didnt fix it self. Everything
> >>on the server looked normal (memory, services, cpu, connections, queries).
> >>
> >>Whats even more strange is that it is only some SP's that timeouts. Some
> >>works perfect, booth in QA and from the ASP-page.
> >>But the queries that do timeout still works perfect in QA.
> >>
> >>I have checked the connection between the webservers and SQL-Server and
> >>it doesnt seems to be a problem. And since most of the queries work I
> >>cannot see that It should be a network problem.
> >>
> >>If anyone have some idea, please tell me!
> >>
> >>I have no idea how to reproduce the problem. When I run the backup
> >>manually during the day then everything is working normally.
> >>
> >>Thanks!
> >>
>