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