Good, I'll delete as soon as I get the go ahead.  Thank you for helping out.

Much Appreciated!

Moving application databases went pretty straight forward today. We moved MDF/LDF files to two new drives.  Ran the alter script and we were done.  Brought everything back online.

While that was...

My plan was to change the MaxDop first, then the CTFP after a few days.  Any issue with that?

Tried your query without success.  It's going to take me a bit...

Fundamental questions:
SQL 2016 - what edition?

How long has the application / system been up?  Not talking about a server reboot, the system.  What's the history? Days, Weeks, Months, Years? ...

Review the following URL, it may provide some guidance (copy and paste the url into a browser):
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fea1c821-5092-4e32-8559-f695d6a83a76/sql-server-2014-transaction-log-for-database-is-full-due-to-activetransaction-error?forum=sqldatabaseengine

Posted last month about this.  
Ran Perfmon yesterday at 10 AM.  Duration 3600 seconds // interval 1 second (virtual machine)

Disk Queue Length: 99 - asked the ESX Administrator...

Goher2000,
Yes max memory is configured for SQL Server.  We added memory as well when we first encountered the problem.  Excessive paging still occurs.  Previous comment by Lynn Pettis: "Sue...

Goher2000,
Note that memory was added to the server.  Made no difference.

Ran perfmon late yesterday and this morning.  Still getting excessive paging.  The report showed little activity however,...

Lynn,
"running VMs has the host been over provisioned, more resources allocated to VMs than actually exists.".

That's a good suggestion.  Waiting for our VM administrator to get in...

First, how do you know this is excessive paging? I assume you mean Windows paging to disk.  Or is this VMWare paging? You should be able to tell us that this...

Sometimes things can stare at you right in the face - and eventually you figure it out.  The numbers represent the number of cluster cores.  Couldn't help but notice it...

Anthony,
Your URL is not working - "The page you requested could not be found".  Do you have an updated link?

Thanks for the insights.  A couple of thoughts, you said when you are licensing for the VM it gets more expensive as you need to license for the number of...

The second ldf is the same location as the first.  And there's plenty of space on the drive.  Don't see it running out for several years.  And don't see the...

Issue is resolved.  It's a named instance, once it was modified to include the name - it worked.

The syntax was something like this:
Program/Script
"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE"