Don't bloat plan cache
Fix this query so the nvarchar() parm is of a fixed size (or MAX). As is, each invocation is generating its own execution plan and bloating the plan cache.
(@p0 bigint,@p1 bigint,@p2 nvarchar(560))INSERT INTO [data].[ClusterSqlServerTopQueriesInstances] ([Id], [CollectionDate], [QueryText]) VALUES (@p0, @p1, @p2)
(@p0 bigint,@p1 bigint,@p2 nvarchar(159))INSERT INTO [data].
[ClusterSqlServerTopQueriesInstances] ([Id], [CollectionDate], [QueryText]) VALUES (@p0, @p1, @p2)
1
vote
Anonymous
shared this idea
Completed in v6.0.3
Thanks again for the suggestion, we appreciate your input.
SQL Monitor Development Team
-
This has been implemented for v6.0.3, which will be released soon.
