February 17, 2012 at 4:00 am
Hi,
I have created trace file for 1 hour, after that analysis the workload at DTA
as per this report what indication exact tell to us and what type tuned done these two category at internally in database.
Number of events tuned3101
Number of statements tuned30657
Workload fileD:\worklad\TracDATA.trc
Maximum tuning time59 Minutes
Time taken for tuning1 Hour 10 Minutes
Estimated percentage improvement 0.00
Maximum space for recommendation (MB)1385
Space used currently (MB)1051
Space used by recommendation (MB)1051
Number of events in workload370483
Number of events tuned3101
Number of statements tuned30657
Percent SELECT statements in the tuned set42
Percent INSERT statements in the tuned set35
Percent DELETE statements in the tuned set22
thanks
ananda
February 17, 2012 at 4:38 am
Is there a question here?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 17, 2012 at 4:45 am
yes, tuning analysis summary report, I want to know
1. Number of events tuned 3101, - what does event exactly tuned done at Database itself?
Number of statements tuned 30657 - what does statement exactly tuned done at Database itself?
Thanks
ananda
February 17, 2012 at 4:57 am
Not sure I understand you.
The numbers are to do with what DTA processed in the trace.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 17, 2012 at 5:06 am
ok, thanks for reply..
DTA result, these number are tuned process event & statement from trace file, so nothing was done automatically tuned at database level. am i correct?
February 17, 2012 at 5:35 am
I think maybe you misunderstand how DTA works. When it's given a trace file, it tunes the statements in the trace file by either recommending or creating (depending on the settings for the DTA session) indexes and statistics in the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 17, 2012 at 5:48 am
Yes, Thanks for your reply...
I got it and Now clearly understand DTA process work.
when given trace file to DTA, first tuned the all the event and statement whatever stored in trace file, If problem found in statement and Event level DTA will produce recomendation. as pre my workload analysis there is no any issues found for statement and Event. after processed these numbers.
February 17, 2012 at 6:58 am
It's not looking for problems in the statements, it's not going to pick up sub-optimal coding practices. It's just looking to see if indexes and/or statistics are needed (and depending on settings it may consider partitioning)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply