July 30, 2018 at 8:51 am
I recently made some changes to a sproc that wasn't running well to a point it runs great now! It was doing magic for maybe 2 weeks, but suddenly nothing comes back now? It does show in the log file that it processed, but nothing is coming back?
The change was simple. Just switched the indexes on temp tables after data inserted vs. before, which it was doing.
Again, it worked great for 2 weeks, but now nothing returns.
I was talking to the developer and suggested to redeploy the RDL. Not sure what else to try?
October 29, 2018 at 2:45 pm
SqlServerDBA318, I am unsure of your environment/rdl but things I would check:
1) Are you performing index maintenance on the new indexes
2) What else is running at the same time the stored procedure execution (maybe another process is overlapping this process and completely removes any indexes you created)
I do not think the SSRS rdl needs to be redeployed since the issues seem to be within the SQL Server itself and not with code changes in the rdl itself.
October 29, 2018 at 3:54 pm
Does the stored procedure return data when you run in SSMS?
October 29, 2018 at 4:00 pm
Thanks Lynn, I forgot that one. =)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply