Workstation Performance

[balachandar]

We have an application developed in VB and SQL server. The application once delivered to the client we were reported about one problem. At the client site, The application displays one form quickly in one workstation,but in others
it is slow. other features of the application work equally well in all systems. This form where in we are just displaying data demanded by the user,Alone gives the performance problem. what could be the reason ? how to diagonise the problem?.Please give any inputs.The configuration of all workstations are the same.We are using RDO and dsnless connection.

 

[foxdev]

For starters, run SQL Server Profiler (available on the SQL Server program group) and filter out all activity except your application and/or the problem workstation. This should help determine if it is a slow query operation that is causing the delay. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com