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 controller 5

with the logical partition c,d,e .

drive c - capacity 19.53 gb , free-12.55 gb

drive d - capacity 23.84 gb, free-10.18 gb

drive e - capacity 24.42 gb , free-7.02 gb

our tempdb is on c drive,

our database files and log files are on d drive

still i have not used index tunning of sql server 2000,

and still its using the default memory of 2gb.

should i need to put switch of 3gb to increase the memory?

i have provided the details u want ,,,

pls let me know if anything more is required

thannks