SQL Server Performance

Performance Problem

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by localhost892, Apr 6, 2009.

  1. localhost892 New Member


    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
  2. FrankKalis Moderator

    Welcome to the forum!
    I guess you have to supply more information in order for us to help you.For example:
    - What operations do the users perform?
    - Why do you think it is a database issue?
  3. satya Moderator

    Also I would like to know about service pack level on SQL Server and database size.
  4. vikasrana_dba New Member

    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.
  5. satya Moderator

    Welcome to the forums.
    Running DBCC DROPCLEANBUFFERS will not resolve the actual problem, what you are trying to do is to supress the current issue to get performance at that point of time. Your actions are only helping for 1 time and next time when it occurs again and running DROPCLEANBUFFERS on production system will lead to negative performance for other small processes such as selecting data from the table.
  6. vikasrana_dba New Member

    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).
  7. satya Moderator

Share This Page