Tuning sql in SQL Sever 2005 using the dta utility

Tuning sql in SQL Sever 2005 using the dta utility

Post by meytal.wei » Fri, 10 Feb 2006 23:24:38


Hi,

I am using the dta utility successfully.
I have problem to tune query without specifying the schema as prefix in
case the tuning session is not with the login that own the schema, the
dta utility fails.

e.g.

Create a new login: login1, pass1
CREATE USER user1 FOR LOGIN login1 WITH DEFAULT_SCHEMA = user1_schema
Workload file:
select * from table1

Table list file:
[db_recommend].[user1_schema].[table1]

1. If the tuning session of the dta is connected with login1, pass1 the
dta succeed.
2. If the tuning session of the dta is connected with other login the
dta fails.
If I will specify the owner in the workload file the dta in this case
will succeed

Is there a way to update the dta with the correct user/schema
dynamically instead of specifying the owner for each object in the
workload file?
Is there a way to active setuser function in the workload file?
Is there an option in the XML file to set the correct user?

Thanks
Meytal