Viewing 15 posts - 556 through 570 (of 2,044 total)
Have a look at the FileShareStorageLocation parameter
You can tell SSRS to store the temp/swapfiles somewhere else
January 5, 2018 at 6:22 am
Sorry polluting sql 2017 administration. Why can't migrating SSRS to 2017 be simple?
October 17, 2017 at 2:53 am
It didn't like the VirtualServiceAccount it was running under;
Changed to an active directory account and it connected
October 16, 2017 at 9:04 pm
October 5, 2017 at 8:19 am
From memory
1. Can you connect to the windows 2012 vm remotely? The vm might use an internal network.
2. SQL Configuration Manager: is TCP protocol enabled?
3. The SQL...
September 14, 2017 at 8:00 am
Source control is important so you can rollback to a previous version.
c# pro:
no license of SSIS needed
flexibility
c# contra:
requires c# skills
no visual flow control
September 14, 2017 at 4:40 am
Searched the web a little further. Refs not supported on san-storage?
Not yet recommeded for clustered volumes due "redirected mode" ( Redirected mode: can't bypass...
September 14, 2017 at 3:35 am
Refs is supported but I can't find more information. Have you tried it in a test-environment?
Refs seems to have a memory impact
September 13, 2017 at 8:59 am
SQL will likely be faster as PL/SQL causes cpu-context-switches.
Perhaps they made cursors for the error-handling?
September 12, 2017 at 6:01 am
Disabling reportlogin and killing reportsessions sounds feasible.
Another option is read committed snapshot isolation ( depends on what kind of ETL is running)
September 7, 2017 at 9:11 am
Can't really recommend further steps, as you checked a lot.
Anything odd on the VM(host) side? Like not running in high-performance mode, overcommitment, old drivers ...
Maybe ssrs is...
September 6, 2017 at 2:20 am
Hello,
If you can't optimize the reports Troubleshooting Reports: Report Performance
you might want to check SSRS subscriptions under the hood
It mentions MaxQueueThreads in the...
September 5, 2017 at 3:55 am
I don't have a compare case Hyper-V versus VMWare
You might want to check the setup of the Hyper-V host , the Hyper-VM , cpu, network, attached storage
MS realises...
July 28, 2017 at 7:58 am
Viewing 15 posts - 556 through 570 (of 2,044 total)