Performance Problem

hi,

I am new to forum.

I am Performance test Engineer,not DBA.

Recently I come across the Interesting Probelm during performance
assignment of a web site.

The problem is:
It is in house website meant to provide the services for the
company employess.Everyone has user ID and Password to Enter
into the system.
User A enters into the system with the designated user name and
password.And performs the operation.The processing time of his
request is fast(within range of 0.6 seconds overall).

User B on the same machine performs the same operation as performed by
A but the processing time is somewhat unacceptable (2 seconds overall ).

Both these operations are been executed on the same Machine having
decent spec(1GB RAM,120GB disk,Processor:Inter Core Duo CPU with 2GHz)

I Understood that the problem is related to Database(I am using MSSQL Server2000) and the organization of the table in the database.

What i need to do to improve the processing time of the User B as well as
overall Performance of the System.
Your Kind Suggestion is anticipated
With Regards
Localhost

Please run the use database_namegocheckpointgodbcc dropcleanbuffers and then test the a & b user performance again. I don't think this issue related to database.

Thanks Satya…
You are correct running DBCC DROPCLEANBUFFERS will drop the entire buffer which will decrease the buffer cache hit ratio and increase the DISK I/O. User can run suggested command in UATSIT if it is exist and then run the same processes and share the result.
Few Clarifications required on above mention issue
1) User A & B are same in term of PermissionRole in applicationTo view application specific module.
2) If answer is no then is there specific check or audit enable for user B.
3) Please Update the Indexes & Statistics if the Fragmentation is high.
4) Please run the profiler while checking the performance of user A & B (apply appropriate filter before run profiler based on hostnameloginame).