SQL Server Performance

Facing performance issues on one of the cluster

Discussion in 'Performance Tuning for DBAs' started by madhukar_kcreddy, Feb 6, 2009.

  1. madhukar_kcreddy New Member

    OS : Windows Server 2003 SP1 Enterprise Edition (Cluster)
    SQL Version : 2000 SP4
    Database size : 75 GB
    Ran the SQL profiler but did not find any query taking longer time than expected.
    After that, executed the Performance counters with the following options.
    LogicalDisk(G:)% Disk Time
    Current Disk Queue Length
    LogicalDisk(H:)% Disk Time
    MemoryPages/sec
    Paging File(_Total)% Usage
    % Processor Time
    SQLServer:Buffer ManagerBuffer cache hit ratio
    SQLServer:Memory ManagerTarget Server Memory (KB)
    SQLServer:Memory ManagerTotal Server Memory (KB)
    (Attached the counter logs for 1 hour duration)
    AWE is enabled and Max server memory is 7GB, the minimum page file size is 11 GB (C: drive 2 GB and other fixed drive (E) is 9 GB) and max is 16 GB, utilization of page file is not even 4 to 5 % and memory utilization is also below 5%.
    Please suggest how to resolve this issue.
    Thanks,
    Madhukar
    (PDH-CSV 4.0) (GMT Standard Time)(0)LogicalDisk(G:)% Disk TimeCurrent Disk Queue LengthLogicalDisk(H:)% Disk TimeMemoryPages/secPaging File(_Total)% Usage% Processor TimeSQLServer:Buffer ManagerBuffer cache hit ratioSQLServer:Memory ManagerTarget Server Memory(KB)SQLServer:Memory ManagerTotal Server Memory (KB)
    05:22.60074.66857818994.20764384.7026921288.33087993798.1943910946022484602248
    06:22.6961.8109905065.46746092316.36912634.7047385575.46490611999.8311286246022484602248
    07:22.61770.435784047.9502408131.67562394.7035592595.79035053499.2561105246022484602248
    08:22.61071.237963020.23391554123.72706324.702969614.25425289299.4753410346022484602248
    09:22.6383.3348225017.30760267156.50429884.7025880732.97200197899.8873556746022484602248
    10:22.6113.4273661012.06583349181.53299414.702171852.82880626899.0452616746022484602248
    11:22.6694.0072068016.56944266168.90199834.7050854094.93768624999.4866859246022484602248
    12:22.6472.734602024.03361526169.31263814.7046691863.2722632797.4387841346022484602248
    13:22.7649.6746166048.28049659180.13329984.7041142234.5080996299.7078870546022484602248
    14:22.72450.88267540184.4008675120.14437784.7030736669.30515022499.7007978746022484602248
    15:22.71714.0998460110.8318089254.9527224.7023799616.96845923699.8570918246022484602248
    16:22.770.35497995013.24855577204.47866414.7048426123.83117523599.2938620346022484602248
    17:22.736.94032604013.24755601199.87968754.7044610753.74655960499.6743849546022484602248
    18:22.741.55724194012.81299138206.84495524.7040795373.92880847699.7702909646022484602248
    19:22.7134.7479495015.95674183190.18083714.7031777223.55221843799.6396986646022484602248
    20:22.7176.8331936037.71146541210.48250744.7023452763.6628982799.8444306246022484602248
    21:22.7100.0151821018.85640566170.70168084.704495764.01342410899.8475609846022484602248
    22:22.77.162016681015.43039502184.530424.7040448522.81652243699.7162114246022484602248
    23:22.7157.9048757115.11238688161.7954424.702969614.50927427199.8301630446022484602248
    24:22.71490.217816219.83950789133.25978564.7019290533.7800887799.4546037946022484602248
    25:22.71328.077332034.78639053156.09523854.7011312934.02098043799.5286439446022484602248
    26:22.7265.8109714024.62829715169.0793644.7026921285.44028760599.8075072246022484602248
    27:22.7639.9867247018.74759788152.95502334.7023105913.10217974498.4408437846022484602248
    28:22.81552.951685021.32016048165.76925064.6876040565.69271712698.9042675946022484602248
    29:22.880.01621139418.8724019147.37267454.6876040563.03709086199.1478203946022484602248
    30:22.82212.790314031.66114386135.34346044.6869797225.23194893899.8274672246022484602248
    31:22.8248.255022117.42177933168.16260464.7041489083.8907687798.8925081446022484602248
    32:22.8270.6914389066.93711583165.00273424.7034205189.7477546399.8280605246022484602248
    33:22.8323.580617014.3020328165.31223684.7026574433.83868410498.7618654646022484602248
    34:22.8388.6401159138.07930816162.56228814.7023799612.90116010399.6110325346022484602248
    35:22.8725.5189742021.44063219153.88801434.7000560514.24774392198.8789237746022484602248
    36:22.8341.9647543181.80792762210.26588914.7041835934.19025560499.7035280246022484602248
    37:22.882.02709989012.48631965173.31299394.7034205183.3438797799.785604946022484602248
    38:22.8419.8989035013.42301481143.40676474.7024146474.19567298199.647763346022484602248
    39:22.817.89345807114.17252948153.7281764.702171852.54307793698.095556346022484602248
    40:22.844.8229808020.42518955152.84471494.7019290532.56260976999.7822299746022484602248
    41:22.815.85794306018.27970774188.88173994.7010966084.56017072699.6043521346022484602248
    42:22.816.75826234014.73304383166.89570264.700576333.59128193799.6132774746022484602248
    43:22.8455.45332631115.9048005155.49500384.699917312.8360542798.9314336646022484602248
    44:22.8105.8888774031.33813559199.08168524.6992929763.64336660499.7348261646022484602248
    45:22.87.412356423017.71478683173.87958674.699050182.23708060399.7865202846022484602248
    46:22.816.55794536016.3228339184.54923114.7012353494.39093946499.7128087346022484602248
    47:22.8965.5510514015.45939576154.22818784.6998826253.6173242799.0276157146022484602248
    48:22.81797.736522119.07782173146.79432624.6991889214.69808110498.7752399946022484602248
    49:22.810031.084196188.0969996100.74798734.6985645879.50041687499.6043165546022484602248
    50:22.88653.067685116667.2482482121.97579994.69759347.38695210697.8980891746022484602248
    51:22.811963.47626120543.3915775122.50916634.7013047199.90654777492.539633246022484602248
    52:22.812924.93993173128.372523592.449517874.7002294779.62408566883.8112858546022484602248
    53:22.813019.084961704.0731909116.99196784.6995704588.91042860794.2005638346022484602248
    54:22.8577.617953718916.6042584131.47663324.6987380136.61870310594.6225439546022484602248
    55:22.910258.7324811042.2310837294.949055644.697524038.56313695684.08253546022804602280
    56:22.969666.06028173101.0179194155.64491174.70061101512.9860537890.3049759246022484602248
    57:22.913004.3385813485.2568492484.539660374.70005605113.3571569492.9467762946022484602248
    58:22.912673.3676248234.1559944161.56182134.69908486511.2477279487.8738621646022484602248
    59:22.88036.406565086.9647263151.1949074.6988420689.46382810799.0400529646022484602248
    00:22.919705.9111911036.15467719123.76041894.684378338.64775242175.5853994546022484602248
    01:22.934228.4865824072.04534436118.77553994.7031777229.11225660780.446735446022484602248
    02:22.957522.105232511148.05772496.873923584.7022065358.38307127384.9717114646022484602248
    03:22.9106369.7172143524.2898915108.11323864.7014087759.33118577869.7813121346022484602248
    04:22.931069.68138099.35887692126.45947824.7005416446.13692010599.6609211646022484602248
    05:22.91835.2261481521.98789622136.46021764.7004029043.1160092796.6585450746022484602248
  2. satya Moderator

    What kind of performance you are facing?
    Explaining the actual problem will help us to identify whether it is hardware or software or database itself>

Share This Page