Its not normal.

From where you are trying to restore ? From network share or local drive? What wait type your restore operation waits for?

I have a powershell query which will list you all services running Manual Mode.

Get-WMIObject -Query "Select * from Win32_Service" | Select-Object name,Startmode -- list all services

Get-WMIObject -Query "Select *...

use msdb

go

select * from backupset

Above table can help you.

Isolation Level can be handled by session level also, not only database level, if I am right.

Is there any chance your application issue that?

Killing threads through TM is a RISKY one.

http://sqlblog.com/blogs/linchi_shea/archive/2010/02/04/killing-a-sql-server-thread-don-t.aspx

Better Leave the rollback process continue, if you do not have any performance problem bec of that spid.

I would recommend scripts rather than MP. I had some maintenance plans in Dev env - virtual machines which threw some memory related errors(those were simple packages for sql backup)....

I cant see any abnormal memory usage by other components.

Please post the exact error messge. What is your page file size? Do your disk drive which hold pagefiles have enough...

One doubt.. Will above query include MemtoLeave memory also?

select Type, SUM(single_pages_kb)/(1024.00) SingleP_MB

, SUM(Multi_pages_kb)/(1024.00) MultiP_MB

, SUM(virtual_memory_committed_kb)/(1024.00) VirtualP_MB

, SUM(shared_memory_committed_kb)/(1024.00) SharedP_MB

,...

select row_count , C.Text From sys.dm_exec_sessions ES ,sys.dm_exec_connections EC

Cross apply sys.dm_exec_sql_text (Ec.most_recent_sql_handle) C

where Es.session_id= EC.session_id

Not sure why you try to find out number of result sets. But above...

When you suspect high memory usage by non-bufferpool components, use this query to find out large consumer.

select Type, SUM(Multi_pages_kb)/(1024.00) Multi_MB From sys.dm_os_memory_clerks ...

SQLAgentReaderRole should be enough to view job history.

lookalive is to check whether a resource is just appear online,isalive is a thorough check whether a resource is appear online and also that is functioning properly. These checks are...

If you want to measure memory usage of Buffer pool,

Select Count(*) * 8 / (1024.00) 'BufferPoolSize In MB' From sys.dm_os_buffer_descriptors

Do #tables cause stored procedure recompilation???