NServiceBus.Persistence.Sql icon indicating copy to clipboard operation
NServiceBus.Persistence.Sql copied to clipboard

Not specifying parameter size for commands force type conversion which results in higher database CPU usage

Open andreasohlund opened this issue 3 years ago • 0 comments

Not specifying the size of the parameters forces the execution engine to convert parameters to the max size specified in the column definition. This increases CPU usage on the database server.

While this should apply to all commands issued by persister we have a user report specifically for the outbox inserts https://discuss.particular.net/t/nservicebus-inefficient-sql-with-persistence/2945

andreasohlund avatar Feb 17 '22 12:02 andreasohlund