Terminal Service cause TimeOut Expired

[Resant]

Hi All,
I have a problem with my Server since I've install Terminal Services.
Sometimes my users get error 'Timeout expired' when trying to query or
open program. Whatshould I do to increase the performance?


Thanks

[Erland Sommarskog]

Re: Terminal Service cause TimeOut Expired

Resant (resant_v@yahoo .com) writes:[color=blue]
> I have a problem with my Server since I've install Terminal Services.
> Sometimes my users get error 'Timeout expired' when trying to query or
> open program. Whatshould I do to increase the performance?[/color]

First thing is to determine is whether the timeout occurs when they connect
or when they run a query. If they get the message when they run a query,
you need to track down which queries that are running slow, and then from
there examine query plans, indexing etc. You should also check for blocking.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp