Thank you for our reply it worked.

Hi,
Virtual page file memory
What kind of OS - Windows ( Server2012 standard), 64gb Ram.
Do you mean the size of the pagefile.sys, or the possibility, to split the...

Data from default trace..
The login is failed by username "Domain\dbc_agent" in all the places, Db is 'master'.
The maintenance plan is running and has 3 jobs for backup...

Thanks, yes your right, logs does not help. 
So running default trace do I have to change any value in above script?
I tried to run this in Test environment...

We have 3 nodes B01 and B02. the IP which is in the error is for B02. 
I might be wrong but I ran the nslookup cmd on B02 and...

nslookup shows it is coming from Domain controller...and not one but team is aware they get multiple errors not sure what is the cause...is there any way to find the...

Thanks Michael..yes it is 2012 version. Appreciate your sharing information.. surely helps. Thank you!

I absolutley agree with your advice about the test server. I will push for it and see it that is a possibility or create awareness of the advantage of having...

Great Jason! thanks for sharing your thoughts and guidance. 
one of the things I will be doing now is plan on 2-3 hrs of downtime notice..
If anything goes wrong...

Thanks you for all the answers!

I might be wrong with 30 mins for downtime, and not sure what is the good amount of time for downtime? How do...

Thank you! for your advice.

Please find the code below for 1 of one the SP's for you to understand  and 'attached' sample data from all the SP's( please see the different workbooks/tabs in .xls)...

Thanks, yes,  I am trying to get the data from all the 10 SP's but the problem is when I try to create the dataset it only allows 1 sp...

Thank you....actually the recurring option for jobs was not checked. That is strange and must have been unchecked by someone doing maintenance or migration.