Posted by Erland Sommarskog on 12/05/09 11:31

Resant (resant_v@yahoo.com) writes:
> 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?

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@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]