SQL Profiler and Tuning Advisor for Reporting Services - what events should be selected?

Posted by chris on Stack Overflow See other posts from Stack Overflow or by chris
Published on 2010-03-24T16:13:50Z Indexed on 2010/03/24 16:23 UTC
Read the original article Hit count: 163

Filed under:

sqlserverce

|

sqlprofiler

|

performance-tuning

|

sql-server

I've used the SQL Profiler to generate a trace file, and tuning advisor to take that trace file and provide some recommendations on db updates.

However, the SQL Profiler doesn't seem to track the queries when running against a Reporting Server, the profiler doesn't seem to be capturing any of the queries. I'm logging the defaults (SQL:BatchCompleted and Starting, RPC:completed, and Sessions - Existing Connections)

What events should I be capturing in SQL Profiler in order to run the tuning advisor?

© Stack Overflow or respective owner

Related posts about sqlserverce

How programically check if SqlServerCe is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How programically check if SqlServerCe is installer (System.data.sqlserverce exist) in c# .Net 3.5. Can I get the version on SqlServerCe? >>> More
AssertionFailure: "null identifier" - FluentNH + SQLServerCE

as seen on Stack Overflow - Search for 'Stack Overflow'
The code fails at session.Save(employee); with AssertionFailure "null identifier". What am I doing wrong? using FluentNHibernate.Cfg; using FluentNHibernate.Cfg.Db; using FluentNHibernate.Mapping; using NHibernate; using NHibernate.Cfg; using NHibernate.Tool.hbm2ddl; namespace FNHTest { public… >>> More
Unable to determine the provider name for connection of type 'System.Data.SqlServerCe.SqlCeConnectio

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, i am using the Ado.Net Entity Framework with Code Only (Tutorial at: ADO.NET team blog) and i want to be as much database independent as possible. In my first approach i just want to go for Sql Express and Sql Compact databases. With Sql Express everthing works fine but with Sql Compact i get… >>> More
How programically check if SQL Server CE is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I programmatically check whether SQL Server CE is installed (System.data.sqlserverce exist) in C# .Net 3.5. Can I get the version on SQL Server CE? >>> More
How do I free SQLServerCE's COM instance from the current running process?

as seen on Stack Overflow - Search for 'Stack Overflow'
It's been a while since I touched COM so be nice ;) This is under WindowsCE 5.0 with SQLServerCE 2.0. After calling this to load SQLServerCE 2.0 : - IDBInitialize *pIDBInitialize = NULL; CoCreateInstance(CLSID_SQLSERVERCE_2_0, NULL, CLSCTX_INPROC_SERVER, IID_IDBInitialize, (void**)&pIDBInitialize); Module… >>> More

Related posts about sqlprofiler

Is a SqlProfiler Scan Started bad?

as seen on Stack Overflow - Search for 'Stack Overflow'
If in SqlProfiler you can see that to execute a query a Scan is Started, does this mean a full table scan or can it just be a lookup? If it can be both, how can you tell which one of the two it is? >>> More
Is this a bug in Profiler or Entity Framework?

as seen on Server Fault - Search for 'Server Fault'
Using Entity Framework 4 with stored procedures and SQL Server 2008 SP1... When running SQL Server Profiler (TSQL_SPs template), the lines that show my stored procedure call and its statements say that they executed in DatabaseID = 1 (Master) but it is actually happening in my application database… >>> More
TempDB is Full Issue for SQL Server 2000

as seen on Server Fault - Search for 'Server Fault'
Even though the log file shows that there is over 1 GB of free space, we start receiving an error message every 3 or 4 days saying that the TempDB file is full. I know cursors impact the TempDB file, but is there anything else I should be looking at to see why this keeps happening? I've tried running… >>> More
Unit of Measurement for Duration Column in Sql Profiler

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the Unit of Duration column in SQL Profiler? i thought it is milliseconds but in following profiler row i found it contradicting with start and end time spid=163 duration=11310646 starttime=2010-04-06 17:45:24.480 endtime=2010-04-06 17:45:35.790 reads=152 writes=2 cpu=16 eventclass=12 textdata=… >>> More
SQL Profiler: Read/Write units

as seen on Stack Overflow - Search for 'Stack Overflow'
i've picked a query out of SQL Server Profiler that says it took 1,497 reads: EventClass: SQL:BatchCompleted TextData: SELECT Transactions.... CPU: 406 Reads: 1497 Writes: 0 Duration: 406 So i've taken this query into Query Analyzer, so i may try to reduce… >>> More