asked on

Application slowing down on Terminal Server

We have a TS environment and the application that run our database that is in SQL is running very slow. We believe that the application is the problem but the developers insist that is the TS environment is the cause. They asked us the following and I will need help in answering the questions:
1) Determine badwidht of the TS to the application
2) Determine Optimization of TS to the application server
3) Determine TS application trhoughput enhancements.
Our TS environment follow the best practices rules, so I don't know how to specificalle answer these questions, the also suggest to "tune" TS and SQL connection. Any suggestion? I need to give an answer ASAP.

MariNoriega

ASKER

I'm trying to find a method to measure the bandwidth utilized by an application program in Terminal Services. Our users connect to an application using terminal services and the application gets really slow. The application developers blaim the TS environment for the slow down in the application. I monitored the server using APPTRACK that created logs for all the applications that run and compared with Microsoft Word and it looks similar but Microsoft Word (and any other applciation) runs w/o problem but this particular custom application gets very slow. This application utilizes a SQL database. i really don't know how to improve the connection between TS and SQL database.

nmcdermaid

Is the SQL Server installed on the Terminal Server?

If not, there may be a network issue between the TS and the SQL Server.

If it is installed on the TS, there may be some disk/CPU contention

MariNoriega

ASKER

nmcdermaid thanks for you comment.
No the SQl server is not installed on the TS it is installed on the same server that the application is running, the users connect from their session to the server that hosts the application. How can I determine the network issue? You can connect to the application server and sometimes it does not have any problem the problem starts whe there are several users connected to the application, especially if they are running some transaction related tasks. There is any tool I can use?

nmcdermaid

Is there any way to run the App outside of TS to determine if this is actually TS related? It could just be a badly written application. What is the app written in?

You can run Perfmon on any machine to identify network bottlenecks.
http://www.computerperformance.co.uk/ezine/BestPractice/BestPractice16.htm
http://www.windowsnetworking.com/articles_tutorials/Windows_2003_Performance_Monitor.html
http://www.msterminalservices.org/articles/Windows-Performance-Monitor-Baseline-Terminal-Server-Part2.html

You might need to watch these counters with 0, 1, and >1 users and see if anything stands out.

You can run profiler on the SQL Server to identify performance bottlenecks. I would only bother with this if the application has issues both in and out of a TS environment.
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1265209,00.html

Sorry to just post links but its my area of expertise.

The questions that those people have asked you to answer are VERY generic. They aren't very helpful to you.

MariNoriega

ASKER

Thanks nmcdermaid sorry I didn't get back to you earlier. The application experience slow down in both outside and in TS. I'll follow your indications and get back to you ASAP. ...and you are righ they are not very helpful

ASKER CERTIFIED SOLUTION

nmcdermaid

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MariNoriega

ASKER

I followed your suggestions and got back to the developer