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