Huge CPU and RAM Usage when compiling objects

girish.joshi

Hi There

Has anyone else noticed that the 2K9 CC (classic client) can go kinda crazy when compiling objects?

I have SQL2k5 running with a max memory limit of 250MB.

I try to compile all objects with 2K9 CC, and SQL Server starts maxing out its memory (normal), but the finsql.exe uses 250MB as well! And about 65% of my 2Ghz CPU. That's pretty intense for compiling the objects in the standard db.

kine

Do not forget that there is C# compilation behind that (first translation from C/AL into C# and after that compilation of the C#). And it took some resource... 8)

girish.joshi

Ah, that's right.

Thanks, kine!