SQL FileStream - Concurrency support

• Mia2022

  Old Hand

  Points: 342

  More actions

  May 17, 2022 at 10:18 pm

  #4034590

  Hi team,

  We have already enabled a SQL filestream for storing API request and response contents in one of our audit table. It works fine in PROD.

  Now we want to add more traffic to it, earlier, the traffic comes from 1 API, now we want to enable Audit for other APIs with request content with more transactions which means request message will be quite large compared to previous ones..

  Now the question we have ?. Will SQL filestream support concurrency (multiple concurrent request). Will there be any impact in terms of performance leading to Timeout for API ?.. Will there be any impact in nightly back up ?

  Right now, we have single insert procedure to insert the records into that table.. if we feel, it will be a problem for concurrent request, then we can think of splitting the table into multiple for each API and have separate insert stored procedure ?

  Also provide some view on Filestream vs Blob in terms of size

  Thanks

   

   

  • This topic was modified 1 year, 11 months ago by  Mia2022.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734418

  More actions

  May 18, 2022 at 9:36 am

  #4034834

  Please don't cross post.

  Replies here: https://www.sqlservercentral.com/forums/topic/sql-filestream-concurrency-support-2