All Tags »
Performance »
memory »
procedure cache (RSS)
Sorry, but there are no more tags available to filter with.
-
If you've read many of my blog posts, you know
that I consider lack of procedure cache control to be a major SQL Server pain point. Badly written apps
that use non-parameterized ad hoc queries can quickly flood SQL Server's memory
pools and bring the server to its knees.
SQL Server 2005 brought some relief in the form of
the Forced ...