Thanks Steve for your reply..

I tried this option already for PARTNER OFF at mirror server. but not able to bring database in EMERGENCY mode in Principal server.

ALTER DATABASE [DBNAME] SET EMERGENCY

Error Messages:

Msg 1468, Level 16, State 1, Line 1

The operation cannot be performed on database "DBNAME" because it is involved in a database mirroring session or...

yeah.. I agreed your points for what are the possible case database state to change the IN-Recovery mode

1. As per application workload TLOG file LDF huge size increase...

thanks Steve and Sue for your reply..
Database is online after recovery process completed. database size MDF size 25GB and LDF size 2GB SIMPLE Recovery mode options..
Transaction log is...

When either the READ_COMMITTED_SNAPSHOT or ALLOW_SNAPSHOT_ISOLATION database options.
08/02/2017 04:20:30,spid12s,Unknown,Service...

i have checked error log file and found those error messages.. Please suggest which resource are busy in terms of CPU, memory. I have checked these resource are normal state...

Hi Thom..
Second JOIN condition not valid due to database_id field not available in sys.dm_exec_sessions,  

USE