Resant (re******@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,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp