Timeouts don't necessarily mean memory leaks. They probably mean the db and
or code used to access it has not been optimized. It could be lots of
things and you will have to narrow down the issues before you can start to
address the problem. I would start by monitoring with Perfmon the cpu, avg
and current disk queues etc to make sure you don't have bottlenecks there,
especially when you are getting these timeouts. You should also monitor
blocking and you can start by using sp_who2 run occasionally. And running a
profiler trace would be a good way to see what is happening int he system
and how long each is taking and how much I/O , CPU they are using. Each of
these tools will help to pinpoint the area you should look deeper into.
These may help:
[url]http://www.swynk.com/friends/vandenberg/perfmonitor.asp[/url] Perfmon counters
Hardware Performance CheckList
SQL 2000 Performance tuning tips
[url]http://www.support.microsoft.com/?id=q224587[/url] Troubleshooting App
Andrew J. Kelly
SQL Server MVP
"Jerad Rose" <jeradrcorvusdigital.com> wrote in message
news:emzY2suRDHA.2148TK2MSFTNGP12.phx.gbl...It> Hello all.
> I have a rather large and rather active website that continues to grow.following> is an ASP site that uses MS SQL Server. As it continues to grow, I am
> starting to have more and more problems with the site causing theI> error:
> Microsoft OLE DB Provider for SQL Server
> Timeout expired
> I feel this has to do with poor garbage collecting (which I am notorious
> for), which leads to memory leaks. The reason I feel this is because whenof> reboot the server, it can go for about 24 hours or a little more before
> causing one timeout error. Then, all of the sudden, I can get over 100
> timeouts within the span of the next 24 hours.
> So, my question is, where is a good place to start to diagnose the source(such> my problem? I am not very up to speed on various diagnosing practicesout> as SQL Profiler, etc).
> So any suggestions or links/guides you can point me to to help me figure> what I'm doing wrong, it would be very much appreciated.
> Thanks in advance.