• thanks for sparing time and replying,,,,, the reading u asked as per below...

    Physical Disk:Avg sec/read>>---29552.91

    Physical Disk:Avg sec/write>>---9479.805

    SQL Server Buffer manager:Buffer cache hit ratio>>----99.814

    SQL Server Buffer manager:checkpoint pages/sec>>----0

    SQL Server Buffer manager:lazy writes/sec>>----7.646

    SQL Server Latches: Latch waits\sec>>----27.393

    SQL Server Latches: average latch wait time>>----391.099

    SQL Server Locks: Lock waits\sec>>----0.051

    SQL Server Locks: average lock wait time>>----317.687

    SQL Server Access methods:Full scans\sec>>-----56.988

    SQL Server Buffer manager:PAGE LIFE EXPECTANCY >>----55

    now pls suggest me what should i do first?

    let me give u my server configuration

    its windows 2003 enterprise 32 bit server ,

    4 gb physical ram,,,,

    90 gb harddisk,,,

    waiting for ur reply, I HAVE ATTACHED THE READING.

    thanks

    mithun