快速查询在SSRS第2部分中缓慢运行
参考 ssrs中快速查询运行缓慢我的情况是1行，97列，97列（我知道很多列 - 我可以更改参数以获取更多行）也有9个参数，我有一个select语句调用多语句功能优化选项以避免参数嗅探，仍然没有区别。在其他两个测试环境中，该功能或PROC在生产中的2秒内运行稍慢一些。 SSRS报告在其他环境中大约6至40秒内运行，在视觉工作室中，您第一次运行时40秒钟，然后单击“刷新”按钮6秒6秒，但是prod 20至30分钟，是的，是否听到了我的声音。
我知道你们中有些人会说白痴减少了您的列数，将代码从功能中移出到PROC中（我想但是该功能在其他报告中共享）或升级您的SSR和Visual Studio（IT即将来临的信任我是在2012年1月记录在《登录书》中的）。除非我可以尝试的其他建议？
Referring to Fast query runs slow in SSRS my scenario is 1 row, 97 columns (I know a lot of columns - I can change the parameters to get more rows) also 9 parameters, I had a select statement calling a multi statement function so I tried moving to a proc but still calling the function made no difference, tried all the optimize options to avoid parameter sniffing, still makes no difference. The function or proc runs in 2 seconds in production a little slower in 2 other test environments. The SSRS report runs in about 6 to 40 seconds in the other environments, within Visual Studio like 40 seconds the first time you run then if you click the refresh button 6 seconds however PROD 20 to 30 mins yes heard me right minutes.
I know some of you are going to say you idiot reduce your number of columns, move your code out of the function into the proc (I would like to but the function is shared across other reports) or upgrade your SSRS and Visual Studio (it is coming trust me in was recorded in Jan 2012 in the things to do log book). Barring those suggestions anything else I can try?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论