Is there a document that details what the fields in the ExecutionLog
represent. For example, what is the RowCount based on? Or how are the
TimeDataRetrieval, TimeProcessing & TimeRendering fields calculated?You may want to check this related thread for an explanation of execution
log times:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=599418b6-d837-446b-b02b-26394c4a8a7b&sloc=en-us
The RowCount column shows the total number of rows read in _all_ datasets
during the report execution. This includes also dataset rows read for
query-based report parameters.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Propwash" <scott.tyree@.crossmark.com> wrote in message
news:1115137030.760735.158180@.o13g2000cwo.googlegroups.com...
> Is there a document that details what the fields in the ExecutionLog
> represent. For example, what is the RowCount based on? Or how are the
> TimeDataRetrieval, TimeProcessing & TimeRendering fields calculated?
>|||Ok, just to make sure I am fully understanding. If I have a SP that
joins three tables (A,B,C), then my RowCound will be the sum of tables
A, B & C plus the resulting recordset. Is this correct?|||No. The RowCount represents only the number of rows in the resulting record
set. If you join multiple table into one dataset inside the stored
procedure, it will not influence the RowCount.
However, if you use the record set in a report parameter and in the report,
you may say a higher count than if you only use it in the report.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Propwash" <scott.tyree@.crossmark.com> wrote in message
news:1115209799.601180.4530@.g14g2000cwa.googlegroups.com...
> Ok, just to make sure I am fully understanding. If I have a SP that
> joins three tables (A,B,C), then my RowCound will be the sum of tables
> A, B & C plus the resulting recordset. Is this correct?
>
Showing posts with label rowcount. Show all posts
Showing posts with label rowcount. Show all posts
Friday, February 24, 2012
Wednesday, February 15, 2012
execution plan
Hi ,
The execution plan shows the estimated rows count and row
count which a big diff means the statistics is not up to
date ?
which utility will show the logical scan and extended
scan which high % means the index is fragemented ?
and also is there any help on how to interpret the results
return by the statistics ?
thks & rdgs
Hi,
Use the command DBCC SHOWCONTIG to get the fragmentation information. See
books online for command usage and details.
You could update the statistics of the table using the below command and see
the execution plan again
update statistics <table_name>
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs
|||Perhaps it would be better to update the statistics with the FULLSCAN option
if you are still getting sub-optimal plans.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs
The execution plan shows the estimated rows count and row
count which a big diff means the statistics is not up to
date ?
which utility will show the logical scan and extended
scan which high % means the index is fragemented ?
and also is there any help on how to interpret the results
return by the statistics ?
thks & rdgs
Hi,
Use the command DBCC SHOWCONTIG to get the fragmentation information. See
books online for command usage and details.
You could update the statistics of the table using the below command and see
the execution plan again
update statistics <table_name>
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs
|||Perhaps it would be better to update the statistics with the FULLSCAN option
if you are still getting sub-optimal plans.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs
execution plan
Hi ,
The execution plan shows the estimated rows count and row
count which a big diff means the statistics is not up to
date ?
which utility will show the logical scan and extended
scan which high % means the index is fragemented ?
and also is there any help on how to interpret the results
return by the statistics ?
thks & rdgsHi,
Use the command DBCC SHOWCONTIG to get the fragmentation information. See
books online for command usage and details.
You could update the statistics of the table using the below command and see
the execution plan again
update statistics <table_name>
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs|||Perhaps it would be better to update the statistics with the FULLSCAN option
if you are still getting sub-optimal plans.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs
The execution plan shows the estimated rows count and row
count which a big diff means the statistics is not up to
date ?
which utility will show the logical scan and extended
scan which high % means the index is fragemented ?
and also is there any help on how to interpret the results
return by the statistics ?
thks & rdgsHi,
Use the command DBCC SHOWCONTIG to get the fragmentation information. See
books online for command usage and details.
You could update the statistics of the table using the below command and see
the execution plan again
update statistics <table_name>
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs|||Perhaps it would be better to update the statistics with the FULLSCAN option
if you are still getting sub-optimal plans.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:afb901c488cf$55873a70$a401280a@.phx.gbl...
> Hi ,
> The execution plan shows the estimated rows count and row
> count which a big diff means the statistics is not up to
> date ?
> which utility will show the logical scan and extended
> scan which high % means the index is fragemented ?
> and also is there any help on how to interpret the results
> return by the statistics ?
> thks & rdgs
Subscribe to:
Posts (Atom)