title: Are there any best practices on upper limits how frequently to run an INSERT?
body: <p>An application has the requirement to store data in a simple DB (single table likely, fewer than 10 fields). Data is acquired by polling a remote service about at about 10Hz, we might get a handful of rows each poll.</p>
  
  <p>The application and DB will be on servers used by other products so while it doesn't need to be super-performant, it mustn't cause serious degradation to other applications or hog resources.</p>
  
  <p>How frequently is it advisable to make SQL INSERTs? Is tens or hundreds of INSERTs per second reasonable or is it considered preferable to batch, maybe once per second or every several seconds? Are there any common practices? DBs aren't my main area so the overhead of individual calls (c#) code->DB (MSSQL) isn't something I know anything about.</p>