访问 Advantage Management Utility 值以获取反馈
在我们的报告生成应用程序中，有一些相当大的查询需要花费大量时间才能运行。到目前为止，用户反馈基本上都是压缩的，而服务器则根据他们的请求进行处理。我注意到 ADA 管理实用程序上有一个选项卡，以完成百分比和估计剩余秒数形式显示查询进度。我尝试翻查表格，看看是否能找到任何公开的信息，并翻阅 ADBS 可用的有限文档，但找不到任何有用的信息。
有谁知道是否有办法可以在 ADA 之外挑选这些信息来提供一些所需的用户反馈？
In our report generation application, there's some pretty hefty queries that take a considerable amount of time to run. User feedback up until this point has been basically zip while the server chugs away at their request. I noticed that there's a tab on the ADA Management Utility that shows progress on the query both as percent complete and estimated seconds remaining. I tried digging through the tables to see if I could find any of this information exposed, as well as picking through the limited documentation available for ADBS and couldn't find anything useful.
Does anyone know if there's a way I can cull this information outside ADA to provide some needed user feedback?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
ADA 正在从 sp_GetSQLStatements 系统过程获取该信息。
但是，为任何操作提供进度信息的传统方法是通过 回调函数。
ADA is getting that information from the sp_GetSQLStatements system procedure.
However, the traditional way of providing progress information for any operation is through a callback function.
这不是问题的答案，但可能有助于减少在报表中运行查询所需的时间。您可能已经完成了此操作并对其进行了尽可能的优化。但如果没有，您可以查看 Advantage Data Architect 中的查询计划来检查优化问题。在运行查询的查询窗口中，您可以从
SQL菜单中选择显示计划（或单击工具栏中的 按钮）。这将显示带有优化信息的执行计划，这些信息可能有助于识别丢失的索引。另一个可能有助于识别未优化查询的工具是通过查询日志记录。 此处也对此进行了讨论。
This isn't an answer to the question but might be useful in helping reduce the time it takes to run the queries in the report. You may have already done this and made it as optimized as it gets. But if not, you might look at the query plan within Advantage Data Architect to check for optimization issues. In the query window where you run a query, you can choose
Show Planfrom theSQLmenu (or click the button in the toolbar). This will display the execution plan with optimization information that might help identify missing indexes.Another tool that might be helpful in identifying unoptimized queries is through query logging. It is also discussed here.