performance affected for selected users

[alex]

Hi
I have 400 mb db with simple recovery
and 1 mb log file running on sql 2000 sp3

database reorgenazed with shrink db option once a day at 6 PM as part of maintance plan

db used with Powerbuilder application
application and db structure was not changed for last 6 month.

Some users complaining about performance.
When I run trace I don't see any query running more then 0.5 sec, while users complain it takes 3-5 sec to open a window or application freeze.
When I ask user reconnect and repeat the task ,everthing is fine.

How to identify is it db or application problem?



Thanks

[rmiao]

Do you rebuild index or update statistics as part of maintenance.

[alex]

yes

[MAK]

a. did you ask your application users to recycle their boxes and try?

b. Are they connecting to SQL server using FQDN or Shorname or IP address.

c. Did anything changed on then network? Are the NIC cards are in 100MB full duplex mode -both on sql server and the application server?

d. How long does it take to ping the sql server box from the application server

[alex]

geting info ...

[mark5572]

Hi,

Try this SQL Server Performance Monitor. It allows you to troubleshoot the specific user activity.

SQL Server Performance Monitor