why microsoft visual studio 2017 is slow

There are a lot of things that could cause slowdowns, and the methods mentioned above are excellent places to look as well as check for blocking, deadlocks and check your wait stats.

Might want to look at your memory and CPU usage while loading the report. data file is a cache of the table/SP data so repeated executions from within visual studio result in faster reports being presented. Have you tried closing visual studio, removing (or renaming) the. You also say you are doing this through visual studio. Over the last four years I have build over 250 reports and never seen this behavior. Then if I make a change to the report, like a format to the numbers, or simply close Visual Studio and open it again it starts going really slow. What makes this really weird is that sometimes it will generate quickly. That did not help, it still takes forever to generate the report. When that took forever to generate, I changed the sp to perform the summations. My initial sp returned all the rows and I let SSRS sum them and hid the detail. I don't have any groups on the report, although I would like to add one for stock versus non-stock purchases with sums for each. There is one column of text and the other four are all decimal. When I create a SSRS report using the sp it takes over ten minutes to generate the report.

All processing is done at the server - case statements and sums.

I have a stored procedure (sp) that returns six to ten rows of data with ten columns, displaying five of them in the report.

Why microsoft visual studio 2017 is slow