have a look at http://byobi.com/2015/12/3-methods-for-shredding-analysis-services-extended-events/ - one of the methods is a C# one that you can do in SSIS.

Not if using...

from my own experience if your cpu is at 80% during etl/processing then CPU is not even being used as well as it should/could - I would look elsewhere.

Some of...

8 core license - see http://download.microsoft.com/download/7/8/c/78cdf005-97c1-4129-926b-ce4a6fe92cf5/sql_server_2017_licensing_guide.pdf - page 16

Note that for Standard the only option is to license the individual VM - if it was Enterprise the whole physical server...

Steve -  someone calendar messed up - your post is dated "December 3, 2019 at 12:00 am"

file group definition does not matter for this.

How you defined the tables on the destination server (e.g. heap/clustered,  and with/without compression) as well as how you copied the data is...

it depends.

if it is a select with just a few joins and small amount of data then 3 mins is too much (assuming server is capable and not hugely constrained)

but...

original backup was created with compression - the one you did on your workstation didn't use the compress option

don't know what you tried but for sure you didn't look where you should.

1 - Add new variable - @package - type string

2  - Add new Execute Package task

2.1 -...

sometimes you need to manually add them to the toolbox - see https://www.sqlservercentral.com/forums/topic/using-attunity-connectors-to-connect-to-oracle

And in some versions there was a need to tweek a registry entry.

also make sure you have...

if you have Enterprise with SA you can install Power BI Report Server on the same licensed server instead of the standard SSRS installation - PB RS is a superset...

this will be interesting reading https://docs.microsoft.com/en-us/sql/integration-services/data-flow/data-flow-performance-features?redirectedfrom=MSDN&view=sql-server-ver15

what you can do is to implement it using powershell.

See this http://byobi.com/2015/10/powershell-scripts-for-collecting-ssas-related-perfmon-and-xevent-trace-data/ for example from Aaron Bertrand

and then this one to load them onto a sql server table for analysis...

depending on the size of those db's and also no how many have  "MAX" datatypes the following would be an option

restore the current db onto a new name.

add a new...

• This reply was modified 6 years, 9 months ago by frederico_fonseca.

look at https://dba.stackexchange.com/questions/171395/troubleshooting-powershell-errors-from-sql-agent-job

Possible solution is to change that step to be a cmd file instead of direct posh