How much memory is on the server? - yes 32 GB

Thanks for the link on VMWare and what MS recommends to run SQL on VMWare. I will go through it....

Just a quick update on this, the issue seems to have resolved by adding additional CPU and memory to the server and adjusting the MAX SQL memory to use 80...

Thank you guys for your valuable inputs ! So my first approach would be to increase processor count from 4 to 8 and memory from 16 to 32 GB. I...

CXSYNC_PORT - WAIT - will this cause the CPU usage on the server to go high? I see number of the same SPIDs running simultaneously and CPU touching 100% on...

I think I had resolved this by granting permissions to the RS folder or something like that. I will try to find the resolution later and update you in case...

Some details :

I am configuring SCSM report on SQL SSRS server. For the multimart Data Source I selected Microsoft Analysis Services - as data source type and connection string given...

Thanks for response. I tried with SYS Admin access but same. Actually I restored the databases from SQL 2012 to a SQL 2014 server. Including report databases and the encryption...

Thank you so much! I'll check it out

Thanks guys, so I don't think there would be any limitations other than using this on production.

I hope even the database sizes, memory , CPU / high availability features would...

Thank you Jeff ! and all others!

The issue is fixed by granting access to the GMSA to the folders where the files were extracted and where the backup files were...

Finally it turns out that permissions to the folder were required, permissions to the SQL server service account. Once this was granted

EXEC Master.dbo.xp_DirTree 'D:\Backups\',1,1 ==> Command worked !

Thanks all for...

Hi,

My command is  :  EXEC Master.dbo.xp_DirTree 'D:\Backups\',1,1

And I have one file in the directory, but the out is  : (0 rows affected)

I am running this on SQL Server 2017 version.

Any...

This same bat file ran successfully through Windows task scheduler job.  That is the extractor bat file.

You mean to say ==> : E:\Extractor64 -F "E:\Test\%NewestFile%" -E D:\TestBackups\test.bak  ?

Thank you all for the suggestions/ inputs , really appreciate it.

Previously, I was using my own account to create the task scheduler job and it was running successfully. Now, management...

Thanks for the suggestion Brian,  I also suspect that the GMSA needs to be added to Log on as batch Job and needs to be in the Administrator group. I...