oh i m very sorry ms gail as i was just not aware abt it i m extremely sorry and again thanking u .... thansk lot mam

i will be...

Respected Mr. Gail shaw & RBarryYoung,

After doing the up gradation to the server as suggested by mr gail,

Here I m again giving u the avg performance counters again. And you...

thanks lot all sirs,

first i will update my server as per mr.gails instruction and then i will rerun all the counters mentioned by all of you and lets hope then...

hello mr sql guru,,

u r pretty right that i m not much experienced dba but that does not mean that i can not write or share my problems with u...

hi Gail Shaw,

fine then i will stregithway upgrade the physical disk with extra two raid one right, and then again i will take those datas and will get back to...

thanks again,

yes i have 3 disks in a raid 5 config. The one resultant raid array is then divided into 3 partitions, c:, d: and e:

u are correct.

thanks...

dear gail shaw

thanks again

but it was my mistake and i m extremely sorry that i told u that its only one physical drive ,but actualy there are 3 physical drives...

hi gail shaw,

thanks again ,,,

yes Those values are for the sec/read, fine i m giving u the disk configuration now,,,

it has a physical drive of 90 gb with a raid...

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...