We do not installed any monitoring tools for SQL server database.
Can you please suggest any monitoring tools, At least these tools will help when I have a situation like...

Adding to the above

I have added additional .ndf(Size 4MB)  file to tempdb to release contention on .mdf (22GB Size)file of tempdb few days back.

It  looks like...

Please find attached actual execution plan of the query.

I raised this question to improve  performance of the query.It would be more help full if you give based on execuiton plan,

The above query has retrieving 2010899 rows .Exection time 11:25 sec

It's  dataware house application.
Every day I collect database statistics and rebuilding existing  indexes if require.
I am fresher to SQL server plz help how to go ahead on this.

Please find attached execution plan and post your suggestions here

Okay,

I have a table with out any indexes. If I am deleting & Inserting data continuously some space will be fragmented

How to recover the space.

We found some maleware in machine, so we removed it and rebooted the server.

I have been observing fragmentation when I check index properties.

Base on that I am going to rebuilding the indexes

No, I am rebuilding indexes before deleting data. 
After deleting We are inserting data through SSIS.

Adding to the above replay.

I have a table, we are deleting data 90% of the data with in that table and inserting again.
Due to heavy deletion, We...