NServiceBus.Persistence.Sql
NServiceBus.Persistence.Sql copied to clipboard
Not specifying parameter size for commands force type conversion which results in higher database CPU usage
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