We're experiencing about 300 SQL Compilations per second, and we use very little dynamic SQL. However, I noticed that in SQL Profiler our calls look like:
exec cid.dbo.uspCIDLog '9425','19155852234',2 -- null
And I think they should look like this if properly parameterized:
exec cid.dbo.uspCIDLog @sFrom='9425', @sTo='19155852234', @userId=2
Will this make a difference?