thanks guys.

I did list the statements...

Below is the query to generate 3 statements:

declare @count as int = 1;
declare @strCount as char(5) = ''
declare @colname as varchar(20) = 'col'
declare...

Hi Eirikur,

Thanks for your reply, if you have a look statement 1 and 2, insert one row with 1000 columns is fine, there is still free space in the page.

my...

Thanks Steve, I did use BCP, thanks again.

Thanks Jeff, I managed to switch out the old data, and moved the data to new server.

It is Intel(R) Xeon(R) Gold 6254 CPU @ 3.10GHz.

I have not found anyone else reported the same issue I have.

we have multiple instances installed on that those servers, I can assign cpu affinity to logical cores not exists, it is working, but I just don't know how it works...

It is enabled...

C:\Windows\system32>wmic

wmic:root\cli>CPU Get NumberOfCores,NumberOfLogicalProcessors /Format:List

NumberOfCores=18

NumberOfLogicalProcessors=36

NumberOfCores=18

NumberOfLogicalProcessors=36

wmic:root\cli>

The best solution is migration, e.g. moving all databases to a SQL Server 2016 AlwaysOn ready environment, but unless you have enough budget, or in case you have new hardware...

In...

I restored it to standby mode which shrink the data file successfully.

(no operation can be performed in norecovery mode)

sp_statement_completed is captured in this case.
Columns are:
c.value('(@name)[1]', 'nvarchar(250)') AS [XEC_EventName],
c.value('(data[@name="duration"]/value)[1]', N'bigint') AS [XEC_Duration],
c.value('(data[@name="cpu_time"]/value)[1]', N'bigint') AS [XEC_CpuTime],
c.value('(data[@name="writes"]/value)[1]', N'bigint') AS [XEC_Writes],
c.value('(data[@name="logical_reads"]/value)[1]', N'bigint') AS [XEC_LogicalReads],
c.value('(data[@name="physical_reads"]/value)[1]', N'bigint')...

Thanks!

I checked the RetryPeriodOnFailure which shows 1 min, but according to the critical events, it tries 3 times in...

separate physical switches, yes.