Memory Leak
Posted: Thu 19 Jul 2012 17:41
Hi,
I've found a major memory leak in SQL Complete for Sql Server, which requires me to restart SSMS quite frequently. The time varies, but sometimes SSMS memory usage grows to 1 GB within a few minutes, if I work on large enough files.
I frequently work with large files (~3000 lines or more) with very similar layout, and these seem to cause issues for SQL Complete. The format of these files is as follows:
Could you please look into this and provide a solution for this issue? It does make SQL Complete somewhat unusable for these files, since it also becomes very slow and I frequently lose work from crashes while editing the files.
I've found a major memory leak in SQL Complete for Sql Server, which requires me to restart SSMS quite frequently. The time varies, but sometimes SSMS memory usage grows to 1 GB within a few minutes, if I work on large enough files.
I frequently work with large files (~3000 lines or more) with very similar layout, and these seem to cause issues for SQL Complete. The format of these files is as follows:
Code: Select all
SET IDENTITY_INSERT Table1 ON;
INSERT INTO Table1 (Column1, Column2, ...)
SELECT Column1, Column2, ... FROM (
SELECT Value1_1, Value2_1, ... UNION ALL
SELECT Value1_2, Value2_2, ... UNION ALL
...
SELECT Value1_2999, Value2_2999, ... )
t (Column1, Column 2, ...)
WHERE NOT EXISTS (SELECT * FROM Table1 t1 WHERE t1.Column1 = t.Column1);
SET IDENTITY_INSERT Table1 OFF;