hi this is kavita I have a website www.tendernews.com, there is one problem.that tempdb file are not closing. plus Whenever user search some data and load is high system hang. can any body help me to optimize database. currently I m using sql server2000 and ASP. is it a ASP problem? please help!!