Can Someone explain what these codes are and how they might explain why my ETL Duration times have doubled in the last few weeks?
select collationname(0x0904D00034)
sys.sp_describe_first_result_set;1
Same for these messages, but they are from the logs
The Service Broker endpoint is in disabled or stopped state
SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [<Data File Name.ndf> in database id 18. The OS file handle is 0x0000000000002380. The offset of the latest long I/O is: 0x0000083de64000. The duration of the long I/O is: 29818 ms.
I have researched each, but I cant find any sensible connection between these and longer data population times