I’m running a BMF TPC-C test against a SQL DB on a server with 32 cores and 512GB RAM. The scale used for the “Load Objects” job is 1000 and there’s a constant 40 users for the TPC-C test. There’s a 5 min pre-sampling followed by a 30 min run.
With right at 3 min to go before the end of the test I start getting errors and the TPS starts slowing down. The errors are:
Stock Level Exec Failed
ODBC Error (37000,21C2) - [Microsoft][ODBC SQL Server Driver][SQL Server]The query processor could not start the necessary thread resources for parallel query execution.
I tracked the thread count for the sqlserver.exe process using perfmon and see that the thread count is 250 right up until that 3 min mark and then it jumps to 1495.
I just started using BMF and can’t yet figure out why this is happening. I’m pretty new to SQL also so I won’t rule out something in SQL.
I couldn’t find anything like this on the community or support site so thought I’d see if anyone here has an idea.