0

I'm not sure Microsoft SQL Server 2014 limit or unlimited incoming request(record or transaction)/sec.If it has parameter to config please share me please.

NPS
  • 9
  • 2
  • There is no limit on the number of requests. The server will process as much as it can. If you're looking at limiting resources, look at Resource Governor. – Jeroen Mostert Apr 23 '20 at 09:52
  • 2
    What problem are you trying to solve? – Dan Guzman Apr 23 '20 at 09:53
  • @DanGuzman My teammate use replication tool (dbmoto) to replicate data from as400 to MSSQL2014 but really slow replication,So they ask me MSSQL2014 have something limit or not because CPU and Disk usage is not peak. – NPS Apr 23 '20 at 13:10
  • @JeroenMostert thanks – NPS Apr 23 '20 at 13:13
  • If all looks good on the SQL box, I would look at the iSeries machine or tool. – Dan Guzman Apr 23 '20 at 14:29

0 Answers0