frequent timeouts on SQL Server 2000

I have been receiving timeout errors frequently form our database. Any
suggestions as to the cause?
Thanks.
UsarianHi,
Can you try optimizing your SQL's and Stored procedures. Use the Profiler
with CPU / Duration in the display.
Identify the procedures/SQL's taking more duration/CPU. After that using
tune the code using Execution Plans / Index tuning wizard...
Thanks
Hari
SQL Server MVP
"Usarian Skiff" <usarian.skiff@.servicecentermetals.com> wrote in message
news:%23b8rWl%23hFHA.1248@.TK2MSFTNGP12.phx.gbl...
>I have been receiving timeout errors frequently form our database. Any
> suggestions as to the cause?
> Thanks.
> Usarian
>|||Blocking.
Run sp_who2 or profiler to see what extent blocking is affecting your
concurrency.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Usarian Skiff" <usarian.skiff@.servicecentermetals.com> wrote in message
news:%23b8rWl%23hFHA.1248@.TK2MSFTNGP12.phx.gbl...
>I have been receiving timeout errors frequently form our database. Any
> suggestions as to the cause?
> Thanks.
> Usarian
>