![]() ![]() SQL Server takes a little more time with each incoming query, turns the literals into variables, and then checks to see if there’s an execution plan already compiled for it. If I run the same queries again, here’s the new output: sp_BlitzCache showing forced parameterization Setting it to Forced takes effect instantly, doesn’t require a restart, and then has a different behavior. Chuck Norris has the option of Brute Force ![]() The default is Simple, but you can also choose Forced. If you right-click on a database, click Properties, Options, and scroll to the Miscellaneous section, you’ll see Parameterization. So your CPU is still high – you’ve just saved some memory, but not a lot.
0 Comments
Leave a Reply. |