Thank you for your reply. Can you please tell me in detail?

1. what output 'who2', 'who2 active' and 'who is active' give ONLY REGARDING database connection and Server connection.

2. how...

yes, you're write about last batch. Thank you

Thanks for your reply. My concern is why it's say Proddb, and checkpoint, lot of cpu and IO and it's sitting there since last 6 days, should I be concern?

DBName:...

Thank you much both of you smart guys.

yes, every 30 min.

@Gila, I like to get your opinion is it normal log size? it's ok to shrink Logfile size? have 520 VLF. should I shrink log file and reset logsize to...

full

I need to make a report in excel that all logins on sql sever has what kind of permission, roles whether or not sqladmins.....these kind of stuff. Any good scripts...

Thanks for ur reply, forgot to add:

Resource Monitor commit (KB) = 777,000 w3wp.exe

NO. backup once a day!!!!

one thing, when I ran your 1st script about backup history and I filtered by database_name, I am getting two same backup dates, although I have a backup job...

One more thing, when I run sys.databases, on my laptop Adventure works it shows 'log_resue_wait_desc' = ACTIVE_TRANSACTION

I ran pretty much every thing like 'dbcc opentran', sys.dm_tran_session_transactions, sys.dm_tran_database_transactions, But still not...

Thank you so much for your valuable time.

Thanks for your input, but doesn't help much. looking for custom tempdb growth report and databases growth report.

what happens when principle comes back on? or will users know they are connecting the mirror? would plz share your knowledge on this or recommend any website which has 'Asynchronous'...