I looked in the logs since the Loading bar in the little tool window was suddenly full after beeing only 25% full and found a System.OutOfMemoryException. Currently there are slightly over 27000 stored procedures in the-database… <div>2024-11-27 15:03:29.375 +01:00 [Debug] [the-server].[the-databse] progress: Processing parameters...
[~500 lines omitted for readability]
2024-11-27 15:44:30.746 +01:00 [Warning] Database population step failed for database the-database - step parameters</div><div>System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.</div><div> at Microsoft.Data.SqlClient.TdsParser.TryReadPlpUnicodeChars(Char[]& buff, Int32 offst, Int32 len, TdsParserStateObject stateObj, Int32& totalCharsRead)</div><div> at Microsoft.Data.SqlClient.TdsParser.TryReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)</div><div> at Microsoft.Data.SqlClient.TdsParser.TryReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj, SqlCommandColumnEncryptionSetting columnEncryptionOverride, String columnName, SqlCommand command)</div><div> at Microsoft.Data.SqlClient.SqlDataReader.TryReadColumnData()</div><div> at Microsoft.Data.SqlClient.SqlDataReader.TryReadColumnInternal(Int32 i, Boolean readHeaderOnly, Boolean forStreaming)</div><div> at Microsoft.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn, Boolean forStreaming)</div><div> at Microsoft.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)</div><div> at Microsoft.Data.SqlClient.SqlDataReader.GetValue(Int32 i)</div><div> at Microsoft.Data.SqlClient.SqlDataReader.get_Item(Int32 i)</div><div> at RedGate.SqlPrompt.Cache.Population.Steps.Queries.ObjectDefinitionQuery.Execute(IDbCommand command, ICollection`1 objectIds)</div><div> at RedGate.SqlPrompt.Cache.Population.Steps.Queries.Unfiltered.ParameterQuery.Execute(IDbCommand command)</div><div> at RedGate.SqlPrompt.Cache.Population.Steps.ParameterPopulationStep.Populate(IDbCommand command)</div><div> at RedGate.SqlPrompt.Cache.Population.DatabasePopulator.PopulateStep(DebugLogger logger, DbCommand command, IDatabasePopulationStep populationStep, String databaseName, Single overallPercentageComplete)
</div> / comments
- Community
- SQL Prompt
- SQL Prompt Refreshing very slowly, different query when connecting to DB
I looked in the logs since the Loading bar in the little tool window was suddenly full after beeing only 25% full and found a System.OutOfMemoryException. Currently there are slightly over 27000 st...
0 votes
