I'm trying to profile SQL reporting services, used from ASP.NET application. In SQL profiler all the SQL run by ASP.NET shows up. It looks like the reporting SQL (from the RDL) doesn't show. Is there some setting or filter I'm missing?
我正在尝试分析从ASP.NET应用程序使用的SQL报告服务。在SQL事件探查器中,ASP.NET运行的所有SQL都会显示出来。看起来报告SQL(来自RDL)没有显示。我缺少一些设置或过滤器吗?
3 个解决方案
#1
3
Application name column = Reporting Services (or similar) usually.
应用程序名称列通常是Reporting Services(或类似)。
You may need to trace SQL batch complete and RPC call complete I've been bitten with this before...
您可能需要跟踪SQL批处理完成和RPC调用完成我之前已被咬过这个...
#2
0
When you get that big ball of mess, you can search it. I would search for an sp or sql statement that you know could only be used by SSRS. (If this doesn't exist, then force something in there just for testing purposes). Look at all the columns. There may be a column that jumps out at you as unique to reporting services that you could use as a filter.
当你得到那个混乱的大球时,你可以搜索它。我会搜索一个你知道只能被SSRS使用的sp或sql语句。 (如果这不存在,那么只是出于测试目的强制某些东西)。查看所有列。对于您可以用作过滤器的报告服务,可能会有一个向您跳出的列。
#3
0
So there's a few ways I profile that could help you.
所以有一些方法可以帮助你。
- Add the column named "HostName" and you'll get the server name appearing as the computer running the report.
- Add a reporting login name to the database and use that name on the reporting service's Shared Data Source, and then filter by LoginName.
- If you add a comment to the report, then you will see that comment and the sql of the report appear in the Data window.
添加名为“HostName”的列,您将获得服务器名称显示为运行报告的计算机。
将报告登录名添加到数据库,并在报告服务的共享数据源上使用该名称,然后按LoginName进行筛选。
如果向报表添加注释,则会看到该注释和报表的sql出现在“数据”窗口中。
For the third one, what I mean is do this:
对于第三个,我的意思是这样做:
-- Get Products Report
- 获取产品报告
select productid, productname from products
从产品中选择productid,productname
And the comment line will appear in the window along with the SQL, which makes it very easy to track to a report when you're noticing one of them is causing issues, further on down the track.
注释行将与SQL一起显示在窗口中,这使得当您注意到其中一个引起问题时,可以非常轻松地跟踪报告。
Hope that helps.
希望有所帮助。
#1
3
Application name column = Reporting Services (or similar) usually.
应用程序名称列通常是Reporting Services(或类似)。
You may need to trace SQL batch complete and RPC call complete I've been bitten with this before...
您可能需要跟踪SQL批处理完成和RPC调用完成我之前已被咬过这个...
#2
0
When you get that big ball of mess, you can search it. I would search for an sp or sql statement that you know could only be used by SSRS. (If this doesn't exist, then force something in there just for testing purposes). Look at all the columns. There may be a column that jumps out at you as unique to reporting services that you could use as a filter.
当你得到那个混乱的大球时,你可以搜索它。我会搜索一个你知道只能被SSRS使用的sp或sql语句。 (如果这不存在,那么只是出于测试目的强制某些东西)。查看所有列。对于您可以用作过滤器的报告服务,可能会有一个向您跳出的列。
#3
0
So there's a few ways I profile that could help you.
所以有一些方法可以帮助你。
- Add the column named "HostName" and you'll get the server name appearing as the computer running the report.
- Add a reporting login name to the database and use that name on the reporting service's Shared Data Source, and then filter by LoginName.
- If you add a comment to the report, then you will see that comment and the sql of the report appear in the Data window.
添加名为“HostName”的列,您将获得服务器名称显示为运行报告的计算机。
将报告登录名添加到数据库,并在报告服务的共享数据源上使用该名称,然后按LoginName进行筛选。
如果向报表添加注释,则会看到该注释和报表的sql出现在“数据”窗口中。
For the third one, what I mean is do this:
对于第三个,我的意思是这样做:
-- Get Products Report
- 获取产品报告
select productid, productname from products
从产品中选择productid,productname
And the comment line will appear in the window along with the SQL, which makes it very easy to track to a report when you're noticing one of them is causing issues, further on down the track.
注释行将与SQL一起显示在窗口中,这使得当您注意到其中一个引起问题时,可以非常轻松地跟踪报告。
Hope that helps.
希望有所帮助。