Be careful with using RegEx on x64 bit boxes

I have been working on a case where a customer reported that, once he plugged in his custom assembly which implemented a set of SqlFunctions and he invoked those functions from T-SQL, SQL Server started eagerly eating all memory and performance dropped significantly. We collected perfmon memory counters and the output from DBCC MEMORYSTATUS which…

1