Datasource

How can I synchronize a table inside a list if both have different
datasources?
I need to synchronize the table by the list details grouping expression. If
I use the table filter, the table fieldID is always aggregated when inside
a list with a different datasource and it results in error.
and
if I add a field to a table from another datasource it is always in the form
Sum(Fields!Field.Value, "datasource")
which is the total sum of the values of the datasource even though the
datasource is grouped on the same field the table is grouped
how can I break this aggregate by the same field the table is grouped so
that I did not get the always the same total sum of all the values of that
aditional datasource in all rows of the table?
Thank you in advance
Martin Suchy
CBSolutionsWithin a data region you cannot use more than one dataset. You have to write
a single query that supplies data to the list and to the table. In most
cases, this involves a JOIN SQL query.
HTH
Charles Kangai, MCT, MCDBA
"Martin" wrote:
> How can I synchronize a table inside a list if both have different
> datasources?
> I need to synchronize the table by the list details grouping expression. If
> I use the table filter, the table fieldID is always aggregated when inside
> a list with a different datasource and it results in error.
> and
> if I add a field to a table from another datasource it is always in the form
> Sum(Fields!Field.Value, "datasource")
> which is the total sum of the values of the datasource even though the
> datasource is grouped on the same field the table is grouped
> how can I break this aggregate by the same field the table is grouped so
> that I did not get the always the same total sum of all the values of that
> aditional datasource in all rows of the table?
> Thank you in advance
> Martin Suchy
> CBSolutions

Dataset parameters question.

I have a report, which contains student details and the courses to
which the student is registered.
I have 2 datasets, one which retrieves the student data, and another
paramaterized report which retrieves all courses for this student.
What I need to do is set this parameter to be the student_id of the
current student.
e.g. I want the report to be displayed as:
Student Details
Student ID: S1000
Name: AN Other Address: 1 22nd Street
Courses:
Math
Chemistry
Physics
Spanish
I can select the correct dataset and field in the textbox for course
name, but the report keeps asking me to enter a student id. I want it
to use the student id of the current student.
Does anyone know how I go about this?
Appreciate any help.Donâ't you use a student id parameter to filter the student? This one should
be used to filter courses.
If youâ're not filtering the students, you may have more than one student. In
this case you can use a single dataset that joins student and courses, and
group by students.
"DJ" wrote:
> I have a report, which contains student details and the courses to
> which the student is registered.
> I have 2 datasets, one which retrieves the student data, and another
> paramaterized report which retrieves all courses for this student.
> What I need to do is set this parameter to be the student_id of the
> current student.
> e.g. I want the report to be displayed as:
> Student Details
> Student ID: S1000
> Name: AN Other Address: 1 22nd Street
> Courses:
> Math
> Chemistry
> Physics
> Spanish
> I can select the correct dataset and field in the textbox for course
> name, but the report keeps asking me to enter a student id. I want it
> to use the student id of the current student.
> Does anyone know how I go about this?
> Appreciate any help.
>|||IF USING A SUBREPORT
Your Student data is in your main report, and your Course data (including
StudentID) is in your subreport. Your subreport is placed inside the list
(or table or whatever) that iterates on the student data.
In the main report, right-click on the subreport and select Properties.
Then go to the Parameters tab and map the subreport parameters to the
appropriate fields.
IF NOT USING A SUBREPORT
You might be able to do this without a subreport. Just join the course
table to the student table in your dataset. Put everything inside a table
(or nested lists if it's a freeform report). You can put rectangles and
lists inside table cells, which is cool. Map everything to the same dataset.
Then set outer grouping levels at the student level, and inner grouping or
details at the course level.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"DJ" <superdj@.hotmail.com> wrote in message
news:72abb98.0501070456.d13dd9d@.posting.google.com...
>I have a report, which contains student details and the courses to
> which the student is registered.
> I have 2 datasets, one which retrieves the student data, and another
> paramaterized report which retrieves all courses for this student.
> What I need to do is set this parameter to be the student_id of the
> current student.
> e.g. I want the report to be displayed as:
> Student Details
> Student ID: S1000
> Name: AN Other Address: 1 22nd Street
> Courses:
> Math
> Chemistry
> Physics
> Spanish
> I can select the correct dataset and field in the textbox for course
> name, but the report keeps asking me to enter a student id. I want it
> to use the student id of the current student.
> Does anyone know how I go about this?
> Appreciate any help.|||I have tried this using a parameterized sub report, and set the
parameter to be the student id. The dataset that retrieves the student
data is simply 'select * from students' so this should bring back all
the students and the sub report should bring back all the courses for
these students.
But still it asks me to enter a student id!
DJ wrote:
> I have a report, which contains student details and the courses to
> which the student is registered.
> I have 2 datasets, one which retrieves the student data, and another
> paramaterized report which retrieves all courses for this student.
> What I need to do is set this parameter to be the student_id of the
> current student.
> e.g. I want the report to be displayed as:
> Student Details
> Student ID: S1000
> Name: AN Other Address: 1 22nd Street
> Courses:
> Math
> Chemistry
> Physics
> Spanish
> I can select the correct dataset and field in the textbox for course
> name, but the report keeps asking me to enter a student id. I want it
> to use the student id of the current student.
> Does anyone know how I go about this?
> Appreciate any help.|||In your parent report parameters, check for a student_id field. You might
have specified one earlier that needs to be deleted. The data source for
your subreport should be something like "select * from courses where
student_id = @.student_id". Then you can link the parameters in the parent
and child reports.
On the other hand, you could do the whole thing in a single report, with a
data source like "select * from students inner join courses on
students.student_id = courses.student_id". Then you put the fields in a
table with student info in the header rows, and group info in the detail
rows.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
<superdj@.hotmail.com> wrote in message
news:1105349201.298466.198340@.c13g2000cwb.googlegroups.com...
>I have tried this using a parameterized sub report, and set the
> parameter to be the student id. The dataset that retrieves the student
> data is simply 'select * from students' so this should bring back all
> the students and the sub report should bring back all the courses for
> these students.
> But still it asks me to enter a student id!
>
> DJ wrote:
>> I have a report, which contains student details and the courses to
>> which the student is registered.
>> I have 2 datasets, one which retrieves the student data, and another
>> paramaterized report which retrieves all courses for this student.
>> What I need to do is set this parameter to be the student_id of the
>> current student.
>> e.g. I want the report to be displayed as:
>> Student Details
>> Student ID: S1000
>> Name: AN Other Address: 1 22nd Street
>> Courses:
>> Math
>> Chemistry
>> Physics
>> Spanish
>> I can select the correct dataset and field in the textbox for course
>> name, but the report keeps asking me to enter a student id. I want it
>> to use the student id of the current student.
>> Does anyone know how I go about this?
>> Appreciate any help.
>

Databases Marked "Suspect"

What can be done to recover a database that has been marked "suspect."
I know this is a loaded question, so here are the details;
The client had a hardware failure and after resolving the failure, in
recovering their databases discovered they had only been backing up the .mdf
files, and not their associated .ldf files.
When Enterprise Manager is brought back up, the database is marked
"suspect," likely due to the missing logfiles. What can be done to get the
database back to a consistent state at that point?
Thanks in advance for any input.
- JohnHi John,
The best option is definitely to restore from backup. However if that is
not possible or desirable, I suggest you to call Microsoft Product Support
since it could be complicated depending on the extent of the damage.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

database Vendor Code: 1843

Im getting above error code when tried to preview the report. The full message as below:
Failed to retrieve data from the database.
Details: ORA-01843: not a valid month
[database Vendor Code: 1843]There is date format error when sending SQL statement or you set month
more than 12 in input argument.|||ORA-01843: not a valid month
Cause: A date specified an invalid month. Valid months are: January-December, for format code MONTH, and Jan-Dec, for format code MON.
Action: Enter a valid month value in the correct format.

Database Tuning Advisor problems

Anyone know where I can find details on why my DTA stopped? It keeps halting
on the very first part of the process, "Submitting Configuration
Information". And the only error message it's giving me is "Tuning Process
exited unexpectedly.(DTAEngine)".
The first time around, I thought it was because of the time limit set on the
DTA, so I moved the "Limit Tuning Time". This time, though, it stopped well
before the time limit hit, and on the exact same step.
Unfortunately, I can see anything in the SQL Server or SQL Server Agent Logs
that gives me a clue on why it's choking on my tuning workload. My original
workload isn't terribly huge. It's a trace file based off the Tuning
template in Profiler and is less than 19 MB in size.
This is my first time using the DTA, so thoughts would be appreciated. I
did have to add the procs and tables to MSDB before I could get DTA to work
(for some reason, they're missing in all our instances) and I'm running 2k5
SP1 + hotfix.
Catadmin
--
MCDBA, MCSA, MCTS
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)Try focusing in on just a tiny part of the database to begin with. For
example, find a long running query that hits several tables. Turn on the
profiler, let it run. Now run the long running query about three times. Go
back to the profiler and save the trace. Open the trace in the tuning
advisor. Browse to the trace file. Select the database(s) that have the
tables you tested in the long running query. Select only those tables and
use only one of the databases. If you have more than one database you can
reuse the same trace. Let it run against those smallest of parameters.
Generally you will get results. Sometimes there isn't enough information in
the trace to kick off the process. At least that's my take on it.
--
Regards,
Jamie
"Catadmin" wrote:
> Anyone know where I can find details on why my DTA stopped? It keeps halting
> on the very first part of the process, "Submitting Configuration
> Information". And the only error message it's giving me is "Tuning Process
> exited unexpectedly.(DTAEngine)".
> The first time around, I thought it was because of the time limit set on the
> DTA, so I moved the "Limit Tuning Time". This time, though, it stopped well
> before the time limit hit, and on the exact same step.
> Unfortunately, I can see anything in the SQL Server or SQL Server Agent Logs
> that gives me a clue on why it's choking on my tuning workload. My original
> workload isn't terribly huge. It's a trace file based off the Tuning
> template in Profiler and is less than 19 MB in size.
> This is my first time using the DTA, so thoughts would be appreciated. I
> did have to add the procs and tables to MSDB before I could get DTA to work
> (for some reason, they're missing in all our instances) and I'm running 2k5
> SP1 + hotfix.
> Catadmin
> --
> MCDBA, MCSA, MCTS
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)|||Be VERY leery of using DTA. It does REALLY bad things sometimes - like
creating indexes that contain 80% of the columns in the table, multiple
indexes with nothing more than additional columns added to the set, etc. I
advise my clients to not use it.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Catadmin" <goldpetalgraphics@.yahoo.com> wrote in message
news:179FC3C7-2370-47CF-BF72-6F574B0280E9@.microsoft.com...
> Anyone know where I can find details on why my DTA stopped? It keeps
> halting
> on the very first part of the process, "Submitting Configuration
> Information". And the only error message it's giving me is "Tuning
> Process
> exited unexpectedly.(DTAEngine)".
> The first time around, I thought it was because of the time limit set on
> the
> DTA, so I moved the "Limit Tuning Time". This time, though, it stopped
> well
> before the time limit hit, and on the exact same step.
> Unfortunately, I can see anything in the SQL Server or SQL Server Agent
> Logs
> that gives me a clue on why it's choking on my tuning workload. My
> original
> workload isn't terribly huge. It's a trace file based off the Tuning
> template in Profiler and is less than 19 MB in size.
> This is my first time using the DTA, so thoughts would be appreciated. I
> did have to add the procs and tables to MSDB before I could get DTA to
> work
> (for some reason, they're missing in all our instances) and I'm running
> 2k5
> SP1 + hotfix.
> Catadmin
> --
> MCDBA, MCSA, MCTS
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the
> back?
> @.=)|||Jamie,
Hmm. Not sure why it wouldn't have enough information since the trace ran
off of Production during business hours, but I'll do as you suggest in a test
DB. See if that makes a difference.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"thejamie" wrote:
> Try focusing in on just a tiny part of the database to begin with. For
> example, find a long running query that hits several tables. Turn on the
> profiler, let it run. Now run the long running query about three times. Go
> back to the profiler and save the trace. Open the trace in the tuning
> advisor. Browse to the trace file. Select the database(s) that have the
> tables you tested in the long running query. Select only those tables and
> use only one of the databases. If you have more than one database you can
> reuse the same trace. Let it run against those smallest of parameters.
> Generally you will get results. Sometimes there isn't enough information in
> the trace to kick off the process. At least that's my take on it.
> --
> Regards,
> Jamie
>
> "Catadmin" wrote:
> > Anyone know where I can find details on why my DTA stopped? It keeps halting
> > on the very first part of the process, "Submitting Configuration
> > Information". And the only error message it's giving me is "Tuning Process
> > exited unexpectedly.(DTAEngine)".
> >
> > The first time around, I thought it was because of the time limit set on the
> > DTA, so I moved the "Limit Tuning Time". This time, though, it stopped well
> > before the time limit hit, and on the exact same step.
> >
> > Unfortunately, I can see anything in the SQL Server or SQL Server Agent Logs
> > that gives me a clue on why it's choking on my tuning workload. My original
> > workload isn't terribly huge. It's a trace file based off the Tuning
> > template in Profiler and is less than 19 MB in size.
> >
> > This is my first time using the DTA, so thoughts would be appreciated. I
> > did have to add the procs and tables to MSDB before I could get DTA to work
> > (for some reason, they're missing in all our instances) and I'm running 2k5
> > SP1 + hotfix.
> >
> > Catadmin
> > --
> > MCDBA, MCSA, MCTS
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)|||Kevin,
I'm trying to run this offline, so I can consolidate or get rid of indexes.
Believe me, the last thing I'm going to do is run it online and allow it to
change stuff without me approving it.
Problem is, I can't even get it to run to begin with... GRRR. Oh, well.
I'll try Jamie's suggestion on a test DB and see if it runs that way.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"TheSQLGuru" wrote:
> Be VERY leery of using DTA. It does REALLY bad things sometimes - like
> creating indexes that contain 80% of the columns in the table, multiple
> indexes with nothing more than additional columns added to the set, etc. I
> advise my clients to not use it.
> --
> Kevin G. Boles
> TheSQLGuru
> Indicium Resources, Inc.
>
> "Catadmin" <goldpetalgraphics@.yahoo.com> wrote in message
> news:179FC3C7-2370-47CF-BF72-6F574B0280E9@.microsoft.com...
> > Anyone know where I can find details on why my DTA stopped? It keeps
> > halting
> > on the very first part of the process, "Submitting Configuration
> > Information". And the only error message it's giving me is "Tuning
> > Process
> > exited unexpectedly.(DTAEngine)".
> >
> > The first time around, I thought it was because of the time limit set on
> > the
> > DTA, so I moved the "Limit Tuning Time". This time, though, it stopped
> > well
> > before the time limit hit, and on the exact same step.
> >
> > Unfortunately, I can see anything in the SQL Server or SQL Server Agent
> > Logs
> > that gives me a clue on why it's choking on my tuning workload. My
> > original
> > workload isn't terribly huge. It's a trace file based off the Tuning
> > template in Profiler and is less than 19 MB in size.
> >
> > This is my first time using the DTA, so thoughts would be appreciated. I
> > did have to add the procs and tables to MSDB before I could get DTA to
> > work
> > (for some reason, they're missing in all our instances) and I'm running
> > 2k5
> > SP1 + hotfix.
> >
> > Catadmin
> > --
> > MCDBA, MCSA, MCTS
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the
> > back?
> > @.=)
>
>

Database Tuning Advisor problems

Anyone know where I can find details on why my DTA stopped? It keeps halting
on the very first part of the process, "Submitting Configuration
Information". And the only error message it's giving me is "Tuning Process
exited unexpectedly.(DTAEngine)".
The first time around, I thought it was because of the time limit set on the
DTA, so I moved the "Limit Tuning Time". This time, though, it stopped well
before the time limit hit, and on the exact same step.
Unfortunately, I can see anything in the SQL Server or SQL Server Agent Logs
that gives me a clue on why it's choking on my tuning workload. My original
workload isn't terribly huge. It's a trace file based off the Tuning
template in Profiler and is less than 19 MB in size.
This is my first time using the DTA, so thoughts would be appreciated. I
did have to add the procs and tables to MSDB before I could get DTA to work
(for some reason, they're missing in all our instances) and I'm running 2k5
SP1 + hotfix.
Catadmin
MCDBA, MCSA, MCTS
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
Try focusing in on just a tiny part of the database to begin with. For
example, find a long running query that hits several tables. Turn on the
profiler, let it run. Now run the long running query about three times. Go
back to the profiler and save the trace. Open the trace in the tuning
advisor. Browse to the trace file. Select the database(s) that have the
tables you tested in the long running query. Select only those tables and
use only one of the databases. If you have more than one database you can
reuse the same trace. Let it run against those smallest of parameters.
Generally you will get results. Sometimes there isn't enough information in
the trace to kick off the process. At least that's my take on it.
Regards,
Jamie
"Catadmin" wrote:

> Anyone know where I can find details on why my DTA stopped? It keeps halting
> on the very first part of the process, "Submitting Configuration
> Information". And the only error message it's giving me is "Tuning Process
> exited unexpectedly.(DTAEngine)".
> The first time around, I thought it was because of the time limit set on the
> DTA, so I moved the "Limit Tuning Time". This time, though, it stopped well
> before the time limit hit, and on the exact same step.
> Unfortunately, I can see anything in the SQL Server or SQL Server Agent Logs
> that gives me a clue on why it's choking on my tuning workload. My original
> workload isn't terribly huge. It's a trace file based off the Tuning
> template in Profiler and is less than 19 MB in size.
> This is my first time using the DTA, so thoughts would be appreciated. I
> did have to add the procs and tables to MSDB before I could get DTA to work
> (for some reason, they're missing in all our instances) and I'm running 2k5
> SP1 + hotfix.
> Catadmin
> --
> MCDBA, MCSA, MCTS
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
|||Be VERY leery of using DTA. It does REALLY bad things sometimes - like
creating indexes that contain 80% of the columns in the table, multiple
indexes with nothing more than additional columns added to the set, etc. I
advise my clients to not use it.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Catadmin" <goldpetalgraphics@.yahoo.com> wrote in message
news:179FC3C7-2370-47CF-BF72-6F574B0280E9@.microsoft.com...
> Anyone know where I can find details on why my DTA stopped? It keeps
> halting
> on the very first part of the process, "Submitting Configuration
> Information". And the only error message it's giving me is "Tuning
> Process
> exited unexpectedly.(DTAEngine)".
> The first time around, I thought it was because of the time limit set on
> the
> DTA, so I moved the "Limit Tuning Time". This time, though, it stopped
> well
> before the time limit hit, and on the exact same step.
> Unfortunately, I can see anything in the SQL Server or SQL Server Agent
> Logs
> that gives me a clue on why it's choking on my tuning workload. My
> original
> workload isn't terribly huge. It's a trace file based off the Tuning
> template in Profiler and is less than 19 MB in size.
> This is my first time using the DTA, so thoughts would be appreciated. I
> did have to add the procs and tables to MSDB before I could get DTA to
> work
> (for some reason, they're missing in all our instances) and I'm running
> 2k5
> SP1 + hotfix.
> Catadmin
> --
> MCDBA, MCSA, MCTS
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the
> back?
> @.=)
|||Jamie,
Hmm. Not sure why it wouldn't have enough information since the trace ran
off of Production during business hours, but I'll do as you suggest in a test
DB. See if that makes a difference.
Catadmin
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"thejamie" wrote:
[vbcol=seagreen]
> Try focusing in on just a tiny part of the database to begin with. For
> example, find a long running query that hits several tables. Turn on the
> profiler, let it run. Now run the long running query about three times. Go
> back to the profiler and save the trace. Open the trace in the tuning
> advisor. Browse to the trace file. Select the database(s) that have the
> tables you tested in the long running query. Select only those tables and
> use only one of the databases. If you have more than one database you can
> reuse the same trace. Let it run against those smallest of parameters.
> Generally you will get results. Sometimes there isn't enough information in
> the trace to kick off the process. At least that's my take on it.
> --
> Regards,
> Jamie
>
> "Catadmin" wrote:
|||Kevin,
I'm trying to run this offline, so I can consolidate or get rid of indexes.
Believe me, the last thing I'm going to do is run it online and allow it to
change stuff without me approving it.
Problem is, I can't even get it to run to begin with... GRRR. Oh, well.
I'll try Jamie's suggestion on a test DB and see if it runs that way.
Catadmin
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"TheSQLGuru" wrote:

> Be VERY leery of using DTA. It does REALLY bad things sometimes - like
> creating indexes that contain 80% of the columns in the table, multiple
> indexes with nothing more than additional columns added to the set, etc. I
> advise my clients to not use it.
> --
> Kevin G. Boles
> TheSQLGuru
> Indicium Resources, Inc.
>
> "Catadmin" <goldpetalgraphics@.yahoo.com> wrote in message
> news:179FC3C7-2370-47CF-BF72-6F574B0280E9@.microsoft.com...
>
>

Database Tuning Advisor problems

Anyone know where I can find details on why my DTA stopped? It keeps haltin
g
on the very first part of the process, "Submitting Configuration
Information". And the only error message it's giving me is "Tuning Process
exited unexpectedly.(DTAEngine)".
The first time around, I thought it was because of the time limit set on the
DTA, so I moved the "Limit Tuning Time". This time, though, it stopped well
before the time limit hit, and on the exact same step.
Unfortunately, I can see anything in the SQL Server or SQL Server Agent Logs
that gives me a clue on why it's choking on my tuning workload. My original
workload isn't terribly huge. It's a trace file based off the Tuning
template in Profiler and is less than 19 MB in size.
This is my first time using the DTA, so thoughts would be appreciated. I
did have to add the procs and tables to MSDB before I could get DTA to work
(for some reason, they're missing in all our instances) and I'm running 2k5
SP1 + hotfix.
Catadmin
--
MCDBA, MCSA, MCTS
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)Try focusing in on just a tiny part of the database to begin with. For
example, find a long running query that hits several tables. Turn on the
profiler, let it run. Now run the long running query about three times. Go
back to the profiler and save the trace. Open the trace in the tuning
advisor. Browse to the trace file. Select the database(s) that have the
tables you tested in the long running query. Select only those tables and
use only one of the databases. If you have more than one database you can
reuse the same trace. Let it run against those smallest of parameters.
Generally you will get results. Sometimes there isn't enough information in
the trace to kick off the process. At least that's my take on it.
--
Regards,
Jamie
"Catadmin" wrote:

> Anyone know where I can find details on why my DTA stopped? It keeps halt
ing
> on the very first part of the process, "Submitting Configuration
> Information". And the only error message it's giving me is "Tuning Proces
s
> exited unexpectedly.(DTAEngine)".
> The first time around, I thought it was because of the time limit set on t
he
> DTA, so I moved the "Limit Tuning Time". This time, though, it stopped we
ll
> before the time limit hit, and on the exact same step.
> Unfortunately, I can see anything in the SQL Server or SQL Server Agent Lo
gs
> that gives me a clue on why it's choking on my tuning workload. My origin
al
> workload isn't terribly huge. It's a trace file based off the Tuning
> template in Profiler and is less than 19 MB in size.
> This is my first time using the DTA, so thoughts would be appreciated. I
> did have to add the procs and tables to MSDB before I could get DTA to wor
k
> (for some reason, they're missing in all our instances) and I'm running 2k
5
> SP1 + hotfix.
> Catadmin
> --
> MCDBA, MCSA, MCTS
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
'
> @.=)|||Be VERY leery of using DTA. It does REALLY bad things sometimes - like
creating indexes that contain 80% of the columns in the table, multiple
indexes with nothing more than additional columns added to the set, etc. I
advise my clients to not use it.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Catadmin" <goldpetalgraphics@.yahoo.com> wrote in message
news:179FC3C7-2370-47CF-BF72-6F574B0280E9@.microsoft.com...
> Anyone know where I can find details on why my DTA stopped? It keeps
> halting
> on the very first part of the process, "Submitting Configuration
> Information". And the only error message it's giving me is "Tuning
> Process
> exited unexpectedly.(DTAEngine)".
> The first time around, I thought it was because of the time limit set on
> the
> DTA, so I moved the "Limit Tuning Time". This time, though, it stopped
> well
> before the time limit hit, and on the exact same step.
> Unfortunately, I can see anything in the SQL Server or SQL Server Agent
> Logs
> that gives me a clue on why it's choking on my tuning workload. My
> original
> workload isn't terribly huge. It's a trace file based off the Tuning
> template in Profiler and is less than 19 MB in size.
> This is my first time using the DTA, so thoughts would be appreciated. I
> did have to add the procs and tables to MSDB before I could get DTA to
> work
> (for some reason, they're missing in all our instances) and I'm running
> 2k5
> SP1 + hotfix.
> Catadmin
> --
> MCDBA, MCSA, MCTS
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the
> back?
> @.=)|||Jamie,
Hmm. Not sure why it wouldn't have enough information since the trace ran
off of Production during business hours, but I'll do as you suggest in a tes
t
DB. See if that makes a difference.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"thejamie" wrote:
[vbcol=seagreen]
> Try focusing in on just a tiny part of the database to begin with. For
> example, find a long running query that hits several tables. Turn on the
> profiler, let it run. Now run the long running query about three times.
Go
> back to the profiler and save the trace. Open the trace in the tuning
> advisor. Browse to the trace file. Select the database(s) that have the
> tables you tested in the long running query. Select only those tables and
> use only one of the databases. If you have more than one database you ca
n
> reuse the same trace. Let it run against those smallest of parameters.
> Generally you will get results. Sometimes there isn't enough information
in
> the trace to kick off the process. At least that's my take on it.
> --
> Regards,
> Jamie
>
> "Catadmin" wrote:
>|||Kevin,
I'm trying to run this offline, so I can consolidate or get rid of indexes.
Believe me, the last thing I'm going to do is run it online and allow it to
change stuff without me approving it.
Problem is, I can't even get it to run to begin with... GRRR. Oh, well.
I'll try Jamie's suggestion on a test DB and see if it runs that way.
Catadmin
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"TheSQLGuru" wrote:

> Be VERY leery of using DTA. It does REALLY bad things sometimes - like
> creating indexes that contain 80% of the columns in the table, multiple
> indexes with nothing more than additional columns added to the set, etc.
I
> advise my clients to not use it.
> --
> Kevin G. Boles
> TheSQLGuru
> Indicium Resources, Inc.
>
> "Catadmin" <goldpetalgraphics@.yahoo.com> wrote in message
> news:179FC3C7-2370-47CF-BF72-6F574B0280E9@.microsoft.com...
>
>