This is a discussion on Terminal Service cause TimeOut Expired within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi All, I have a problem with my Server since I've install Terminal Services. Sometimes my users get error ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| ||||
| 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/techinf...2000/books.asp |