Thanx for your valuable response.

I presume my DB do not have proper index and other stats,

When I am using DMV/DMF in SQL Server 2005 I am able to get list of missing index and review Execution plan but in SQL Server 2k I am not able execute Index management stuffs,

especially non cluster index and covering index, apart from this I can use scripts to find heap table and deadlock occurrences(incidents)

Moreover Please suggest me to configure blocked process thresh hold

Jitesh.