and I have to query the design of that process - why do you have 2 different VM's trying to delete older rows from dbo.Logs_Epass without any other criteria than...

with few exceptions, and when number of cpu is now, maxdop should not be set to higher than half the number of cores - so one query does not hog...

not if you need to keep part of the data on the source table - a SWITCH means all table contents gets "moved" to a new table, or 1 partition...

sample DTSX package attached.

you will also need to install Oracle Client for Microsoft tools -...

• This reply was modified 1 year, 7 months ago by frederico_fonseca.

even with SSIS...

you can start by reading the manual - https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/get-date?view=powershell-7.4

and as alternative, you pass your desired date in date format to your sql, and within the sql itself you convert to...

I'll see if I can find one - I know I have some outside SSIS,...

there are commercial tools for it , and this one from MS https://www.microsoft.com/en-us/download/details.aspx?id=103016 - never used it though

regardless - check every server that is part of that AG and ensure that only the 64 bit version of the driver is installed.

use script from https://www.powershellgallery.com/packages/LegacyData/3.2.0/Content/Public%5CGet-InstalledDatabaseDriverList.ps1

can be called as

Get-InstalledDatabaseDriverList...

this looks like a failover issue where the servers installed version isn't the same - one has a 32 bit version and the other a 64bit version.

I would check this.

Hi All,

How important is it archiving old data ? In recent days, We saw some timeouts and blockings happening for app API calls to the database.  Later, found that...

Appreciate the replies!

The script I used most recently is this:

declare @period varchar(10) = '2024MAR'
 
declare @innerCommand varchar(500) = 'select * from FACT_GL_ACTUALS where TRX_PERIOD = ''''' +...

Thanks all...

I tried using a dynamically generated openquery statement and, while it's not as fast as I was hoping, it's definitely a lot faster than before.  Going to try...

based on what you said I STRONGLY recommend that you change the process to use either a ETL tool (SSIS or plain C#- SSIS will likely be the slowest -...

you saying that "select * from remoteoracle where a = b" is slow?

or is it when you are joining to local tables (big NO NO).

but regardless - access to remote...

• This reply was modified 1 year, 7 months ago by frederico_fonseca.