How to speed up StreamInsight, to make it take all processor power?

Question

I run my console application, and create StreamInsght engine and StreamInsght application in my console application ("in process").

And my console application take maximum only 4% of all CPU, of 24 cores = 1 core. Does it mean that StreamInsight can work only on one core with one chained query?

How to speed up StreamInsight, to make it work on more than one processor core, to make it take all processor power?

To make it work in multithreading not on one core, but on all cores.

Answer 1

Hi MCP_User,

 

I suppose you are hit by the license limitation.

There are two flavours of StreamInsight: Standard (which corresponds to SQL Server up to Enterprise version) and Premium (corresponding to SQL Server Data Center version).
Only Premium will profit of multi-core; the Standard edition is limited to single core.

 

Thanks,
Marius

---

Marius

Answer 2

Yes)))

Thank you, Marius Zaharia, very much. I read about it while studying streamInsight, and then forgot.