SQL 2005 Database Tuning Advisor
-
Hi all,
new to this forum and to SQL 2005.
Rite now tuning some low performance queries using DTA. i came across a documentation which says this single queries to be tuned....
When tuning, DTA assumes that the input workload is representative. If you want DTA to take into account the cost of updating indexes, the input workload given to DTA must include the appropriate update statements in addition to the query to tune.
can someone please throw some light on what one means by appropriate update statement?? i tried including UPDATE STATISTICS followed by the actual query so that the DTA gets an idea about existing indexes but m getin an error as 'S008 UPDATE STATISTICS timecorp.commit_pay_sum commit_pay_sum_pk 1 Event does not reference any tables'
below is the snapshot of the workload that i am using
use
timecorp
go
UPDATE STATISTICS timecorp.commit_pay_sum commit_pay_sum_pk
go
UPDATE
timecorp.commit_pay_sum SET dept_id = '', job_id = ''
WHERE locid = '' AND emp_id = '' AND dept_id = ''
AND job_id = ''
go
DTA is suggesting indexes but it is ignoring the already existing indexes as the update statistics is giving an error......
CAN SOMEONE PLEASE HELP ME WITH THIS??????????????????
-
Remove your update stats and try only with the update statement.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
i have tried that and i get reccomendations.
for that matter i get the recomendatiosn even with the update statistics, but DTA gives the error and does not consider the update stat.... and so the existing indexes. but my problem is that i want recomendations considering the existing indexes on the table so that the recos are very close to the actual scenario!! thats why i thought of UPDATE STATISTICS!!
is there any other way i can achieve this????
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply