Hi!

Thanks very much for your answers. It seems like TVP's are not the ideal technique to use in our case then.

In our system we receive a message with a lot...

In our case we cannot batch requests ie messages since we then would have to keep the messages in memory and if the power goes all messages are lost.

We need...

SQL Server is not the cause of your performance issues - it is the design.

What do you mean by that? I notice a overhead when are using three table valued...

According to this article below tempdb is not used for TVP's but sql server works with them partially in memory and partially on disk.

In our scenario, if the sql server...

Ok, below is the data access code and the proc definition followed by the database trace.

After tracing I have seen that the overhead seems to be from the ExecuteNonQuery call...

No one has an answer?

We are using TVP's in a call to a stored procedure. The proc takes three arguments of which all are TVP's. This functionality does not seem to scale at all,...