Hi,

Have you checked this

https://support.microsoft.com/en-us/help/4338636/fix-sql-jobs-fail-due-to-blocking-in-ssisdb-in-sql-server-2014-2016-an

Good luck

Dear Friend,

Brother, SQL Server 2008, was a commercial database application, today without MS support. Some points that you mention, are interesting.

If you are the only user with access, and you...

Dear friend,

I observe some ambiguity in your question.

If your final meta, is to have, only one WFCI that includes a Always on Environment.

After you have configured your WFCI environment, you...

A quick reference for your wait states, is the Performance Dashboard Report, quickly you can find what is doing your sql server, or  historical information about your waits, you can...

Could be a good research editorial , write some similar for User-Defined table types

Hi,
Thanks for your response, I am trying to connect using an Alias name.
I have been trying  to connect using Manangement Studio directly to the SSIS console, via...

And yes, it works if I am physically logged to the target server

Thanks SSC Guru,
Only works  if I  try  with the  original host name
Thanks again

Thanks SSC Guru,

I'm trying using  SQL  Management  Sutdio. Also I have used cliconfg.exe for 64 and 32 bits version

Thanks again

For future reference,
After  waiting  3+ days waiting to finish the recovery  state, I have to:
1.) Locate a last and good backup
2.)  Restart SQL Server using trace flag...

Sue,

Thanks for your response. Great documentation.
After a couple of hours, watching,
database_transaction_log_bytes_reserved from sys.dm_tran_database_transactions, for both transactions

0
3639948
and it remains at the same...

Bubby,
See this link,
https://www.mssqltips.com/sqlservertip/3499/make-network-path-visible-for-sql-server-backup-and-restore-in-ssms/
Best Regards

Burfos,

What vm are you using ?, if you are using vmware,...

I do not know, If I am correct, DMO world Scramble, resulted difficult, instead I searched the keys:
1.sys.dm_exec_query_stats
2.sys.dm_exec_requests
3.sys.dm_exec_text_query_plan
4.sys.dm_io_virtual_file_stats
5.sys.dm_os_sys_info
6.sys.dm_os_waiting_tasks
7. sys.dm_tran_session_transactions
8. sys.dm_tran_locks
9. sys.dm_tran_active_transaction

Hi,
After collecting all the scripts, totalized 20mb scripts, very heavy object, I will need to deploy via SQLCMD.
Thanks