January 13, 2023 at 10:22 am
hi
I have a problem. I have created a report which shows the data from table in SQL Server (just a "select * from
where catid in (..)).
There is a parameter where I can choose if it should show MAIN categories, OTHER categories or ALL categories - and depend on choose - the list of catid is shorter or longer.
It works fine when I choose MAIN or OTHER categories. But when I choose ALL - after some time I receive an error - out of memory.
Result of this select (for all categories) is quite big - 25k records, but it should just be shown - there are no calculations in the report.
What is more strange - this worked a month ago for me and other people, but a week ago in stopped working on my collegue's computer, but still worked on mine. Today it stopped working also on mine.
I tried to restart (local machines, SQL server) - nothing helped.
Do you have any idea why it happened like that and how to fix it?
Regards
Chris
January 13, 2023 at 1:49 pm
Honestly, sounds like your query is using too much memory. You either need to tune it so that it performs better (and there really isn't a way to tune BRING ME EVERYTHING other than with hardware), or you need to spend money on getting more memory.
----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
The Scary DBA Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
January 13, 2023 at 4:03 pm
What is the error message and is it on the SQL Server side or the SSRS side?
😎
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply