Hi all,
I am running the ITW against several trace files that were created from a single trace file. I only have the following problem when attempting to save the script file from the analysis of any one of the multiple trace files. I have used the ITW against single trace files with no problem.
Here's the problem:
Everything works fine until I select the "Save Script File" option. After selecting this option, designating a file name to save to, and then clicking the "Next" button, the application appears to hang up. It displays an hourglass pointer, as though it is working, but just sits there forever. Also, when I look at the task manager this application reports that it is "not responding". I have allowed it to sit there in this state for several hours before finaly killing the process. Is there some additional configuration or method required to analyze multiple trace files from a single trace session?
Any suggestions would be greatly appreciated.
Thanks,
RickThis could be a bug. You might want to contact PSS.
Showing posts with label itw. Show all posts
Showing posts with label itw. Show all posts
Friday, March 30, 2012
ITW says workload does not contain events or queries to use
Hi,
I'm having trouble getting the Index Tuning Wizard to analyze my workload.
I'm using SQL Server 2000. I've run the ITW against several different trace
files, and keep getting an error that says, "The workload does not contain
any events or queries that can be tuned against current database. Check to
see that the trace contains valid events or that the SQL script contains
valid queries and you are tuning against the right database."
In one case, as a test I ran the ITW against a trace file that I had run it
on about a month ago and gotten results from. Even with that file I still go
t
this error. In other cases when I try to run ITW on an older trace file, it
crashes. I've tried running ITW from another user's computer, with the same
result, so it doesn't seem to be my computer that's at fault.
I'm using the SqlProfilerTuning trace template. I've checked my trace
template against the same template on another computer to see if I had
changed something and broken it, but the only difference was that mine was
recording one additional data column, ApplicationName.
The events I'm recording are RPC:Completed and SQL:BatchCompleted.
There have definitely been data updates to at least some of the tables I'm
asking it to analyze. In some cases there have not been many updates (a doze
n
to a few dozen)--ITW documentation indicates that the ITW may fail if there
have not been enough changes to analyze, but it doesn't give any indication
as to what is enough.
Any suggestions what might be the problem, or how I could find out what the
problem is?
EachusDid you take a look at BOL Index: "Troubleshooting the Index Tuning Wizard"
?
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Eachus" <Eachus@.discussions.microsoft.com> wrote in message
news:42FB19DB-3631-4F02-A3BB-71A2B7EDFABD@.microsoft.com...
> Hi,
> I'm having trouble getting the Index Tuning Wizard to analyze my workload.
> I'm using SQL Server 2000. I've run the ITW against several different
trace
> files, and keep getting an error that says, "The workload does not contain
> any events or queries that can be tuned against current database. Check to
> see that the trace contains valid events or that the SQL script contains
> valid queries and you are tuning against the right database."
> In one case, as a test I ran the ITW against a trace file that I had run
it
> on about a month ago and gotten results from. Even with that file I still
got
> this error. In other cases when I try to run ITW on an older trace file,
it
> crashes. I've tried running ITW from another user's computer, with the
same
> result, so it doesn't seem to be my computer that's at fault.
> I'm using the SqlProfilerTuning trace template. I've checked my trace
> template against the same template on another computer to see if I had
> changed something and broken it, but the only difference was that mine was
> recording one additional data column, ApplicationName.
> The events I'm recording are RPC:Completed and SQL:BatchCompleted.
> There have definitely been data updates to at least some of the tables I'm
> asking it to analyze. In some cases there have not been many updates (a
dozen
> to a few dozen)--ITW documentation indicates that the ITW may fail if
there
> have not been enough changes to analyze, but it doesn't give any
indication
> as to what is enough.
> Any suggestions what might be the problem, or how I could find out what
the
> problem is?
> Eachus|||Thanks for the suggestion. Yes, I have read that page. It doesn't address
either of the messages that I'm receiving.
The messages I receive most often is:
"The workload does not contain any events or queries that can be tuned
against current database. Check to see that the trace contains valid events
or that the SQL script contains valid queries and you are tuning against the
right database."
Sometimes I get this message:
"There are no events in the workload. Either the trace file contained no SQL
batch or RPC events or the SQL script contained no SQL queries."
According to all the documentation I can find, the RPC:Completed and
SQL:BatchCompleted events that the trace is capturing are what ITW needs, so
that message doesn't make any sense.
Laura
"Vinod Kumar" wrote:
> Did you take a look at BOL Index: "Troubleshooting the Index Tuning Wizard
"
> ?
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
> "Eachus" <Eachus@.discussions.microsoft.com> wrote in message
> news:42FB19DB-3631-4F02-A3BB-71A2B7EDFABD@.microsoft.com...
> trace
> it
> got
> it
> same
> dozen
> there
> indication
> the
>
>
I'm having trouble getting the Index Tuning Wizard to analyze my workload.
I'm using SQL Server 2000. I've run the ITW against several different trace
files, and keep getting an error that says, "The workload does not contain
any events or queries that can be tuned against current database. Check to
see that the trace contains valid events or that the SQL script contains
valid queries and you are tuning against the right database."
In one case, as a test I ran the ITW against a trace file that I had run it
on about a month ago and gotten results from. Even with that file I still go
t
this error. In other cases when I try to run ITW on an older trace file, it
crashes. I've tried running ITW from another user's computer, with the same
result, so it doesn't seem to be my computer that's at fault.
I'm using the SqlProfilerTuning trace template. I've checked my trace
template against the same template on another computer to see if I had
changed something and broken it, but the only difference was that mine was
recording one additional data column, ApplicationName.
The events I'm recording are RPC:Completed and SQL:BatchCompleted.
There have definitely been data updates to at least some of the tables I'm
asking it to analyze. In some cases there have not been many updates (a doze
n
to a few dozen)--ITW documentation indicates that the ITW may fail if there
have not been enough changes to analyze, but it doesn't give any indication
as to what is enough.
Any suggestions what might be the problem, or how I could find out what the
problem is?
EachusDid you take a look at BOL Index: "Troubleshooting the Index Tuning Wizard"
?
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Eachus" <Eachus@.discussions.microsoft.com> wrote in message
news:42FB19DB-3631-4F02-A3BB-71A2B7EDFABD@.microsoft.com...
> Hi,
> I'm having trouble getting the Index Tuning Wizard to analyze my workload.
> I'm using SQL Server 2000. I've run the ITW against several different
trace
> files, and keep getting an error that says, "The workload does not contain
> any events or queries that can be tuned against current database. Check to
> see that the trace contains valid events or that the SQL script contains
> valid queries and you are tuning against the right database."
> In one case, as a test I ran the ITW against a trace file that I had run
it
> on about a month ago and gotten results from. Even with that file I still
got
> this error. In other cases when I try to run ITW on an older trace file,
it
> crashes. I've tried running ITW from another user's computer, with the
same
> result, so it doesn't seem to be my computer that's at fault.
> I'm using the SqlProfilerTuning trace template. I've checked my trace
> template against the same template on another computer to see if I had
> changed something and broken it, but the only difference was that mine was
> recording one additional data column, ApplicationName.
> The events I'm recording are RPC:Completed and SQL:BatchCompleted.
> There have definitely been data updates to at least some of the tables I'm
> asking it to analyze. In some cases there have not been many updates (a
dozen
> to a few dozen)--ITW documentation indicates that the ITW may fail if
there
> have not been enough changes to analyze, but it doesn't give any
indication
> as to what is enough.
> Any suggestions what might be the problem, or how I could find out what
the
> problem is?
> Eachus|||Thanks for the suggestion. Yes, I have read that page. It doesn't address
either of the messages that I'm receiving.
The messages I receive most often is:
"The workload does not contain any events or queries that can be tuned
against current database. Check to see that the trace contains valid events
or that the SQL script contains valid queries and you are tuning against the
right database."
Sometimes I get this message:
"There are no events in the workload. Either the trace file contained no SQL
batch or RPC events or the SQL script contained no SQL queries."
According to all the documentation I can find, the RPC:Completed and
SQL:BatchCompleted events that the trace is capturing are what ITW needs, so
that message doesn't make any sense.
Laura
"Vinod Kumar" wrote:
> Did you take a look at BOL Index: "Troubleshooting the Index Tuning Wizard
"
> ?
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
> "Eachus" <Eachus@.discussions.microsoft.com> wrote in message
> news:42FB19DB-3631-4F02-A3BB-71A2B7EDFABD@.microsoft.com...
> trace
> it
> got
> it
> same
> dozen
> there
> indication
> the
>
>
ITW Errors
Hi,
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
Jerry
Jerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
sql
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
Jerry
Jerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
sql
ITW Errors
Hi,
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
JerryJerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
>> Hi,
>> I'm trying to use the ITW for one of our German servers. I have
>> created an input file using Profiler that captures the
>> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
>> using the input file I recieve the following error:
>> "The workload does not contain any events or queries that can be tuned
>> against the current database. Check to see that the trace contains
>> valid events or that the SQL script contains valid queries and you
>> are tuning against the right database"
>> If I select only certain tables to analyze I recieve the following
>> error:
>> "There are no events in the workload. Either the trace file
>> contained no SQL batch or RPC events or the SQL script contained no
>> SQL queries.
>> I have run a broad trace and a narrow trace using the specific
>> database id as a filter.
>> Both using a file and a table return the same errors.
>> If I use the Query Analyzer Selection option with the ITW with a
>> specific query from the input file then the ITW does work properly. Also,
>> the size of the input file is < 100 rows (just a test at this
>> point).
>> It looks as though the ITW has an issue with the code of one or more
>> of the statements in the input file. Is this an accurate assumption?
>> Does anyone know how to resolve this issue so that I can use ITW with
>> many statements as opposed to using only a few at a time?
>> Thanks
>> Jerry
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
>> David,
>> I saw the KB article that referenced that issue but it looked as
>> though it was fixed in SP1 of Version 7. We're running SP3 of
>> Version 2000. I used the client utilities from a separate client
>> machine here in the states. I had a colleague remote desktop to the
>> SQL Server itself running the tools on the local SQL Server and he
>> received the same errors that I'm getting.
>> Jerry
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
JerryJerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
>> Hi,
>> I'm trying to use the ITW for one of our German servers. I have
>> created an input file using Profiler that captures the
>> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
>> using the input file I recieve the following error:
>> "The workload does not contain any events or queries that can be tuned
>> against the current database. Check to see that the trace contains
>> valid events or that the SQL script contains valid queries and you
>> are tuning against the right database"
>> If I select only certain tables to analyze I recieve the following
>> error:
>> "There are no events in the workload. Either the trace file
>> contained no SQL batch or RPC events or the SQL script contained no
>> SQL queries.
>> I have run a broad trace and a narrow trace using the specific
>> database id as a filter.
>> Both using a file and a table return the same errors.
>> If I use the Query Analyzer Selection option with the ITW with a
>> specific query from the input file then the ITW does work properly. Also,
>> the size of the input file is < 100 rows (just a test at this
>> point).
>> It looks as though the ITW has an issue with the code of one or more
>> of the statements in the input file. Is this an accurate assumption?
>> Does anyone know how to resolve this issue so that I can use ITW with
>> many statements as opposed to using only a few at a time?
>> Thanks
>> Jerry
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
>> David,
>> I saw the KB article that referenced that issue but it looked as
>> though it was fixed in SP1 of Version 7. We're running SP3 of
>> Version 2000. I used the client utilities from a separate client
>> machine here in the states. I had a colleague remote desktop to the
>> SQL Server itself running the tools on the local SQL Server and he
>> received the same errors that I'm getting.
>> Jerry
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
ITW Errors
Hi,
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
JerryJerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
I'm trying to use the ITW for one of our German servers. I have created an
input file using Profiler that captures the SQL:BatchCompleted and the
RPC:Completed events. When I run the ITW using the input file I recieve the
following error:
"The workload does not contain any events or queries that can be tuned
against the current database. Check to see that the trace contains valid
events or that the SQL script contains valid queries and you are tuning
against the right database"
If I select only certain tables to analyze I recieve the following error:
"There are no events in the workload. Either the trace file contained no
SQL batch or RPC events or the SQL script contained no SQL queries.
I have run a broad trace and a narrow trace using the specific database id
as a filter.
Both using a file and a table return the same errors.
If I use the Query Analyzer Selection option with the ITW with a specific
query from the input file then the ITW does work properly. Also, the size
of the input file is < 100 rows (just a test at this point).
It looks as though the ITW has an issue with the code of one or more of the
statements in the input file. Is this an accurate assumption? Does anyone
know how to resolve this issue so that I can use ITW with many statements as
opposed to using only a few at a time?
Thanks
JerryJerry Spivey wrote:
> Hi,
> I'm trying to use the ITW for one of our German servers. I have
> created an input file using Profiler that captures the
> SQL:BatchCompleted and the RPC:Completed events. When I run the ITW
> using the input file I recieve the following error:
> "The workload does not contain any events or queries that can be tuned
> against the current database. Check to see that the trace contains
> valid events or that the SQL script contains valid queries and you
> are tuning against the right database"
> If I select only certain tables to analyze I recieve the following
> error:
> "There are no events in the workload. Either the trace file
> contained no SQL batch or RPC events or the SQL script contained no
> SQL queries.
> I have run a broad trace and a narrow trace using the specific
> database id as a filter.
> Both using a file and a table return the same errors.
> If I use the Query Analyzer Selection option with the ITW with a
> specific query from the input file then the ITW does work properly.
> Also, the size of the input file is < 100 rows (just a test at this
> point).
> It looks as though the ITW has an issue with the code of one or more
> of the statements in the input file. Is this an accurate assumption?
> Does anyone know how to resolve this issue so that I can use ITW with
> many statements as opposed to using only a few at a time?
> Thanks
> Jerry
There used to be a problem with SQL Server 7.0 with running the ITW on a
client PC using a different locale than the one on the server. Have you
tried running the ITW on the server itself (off-hours)?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David,
I saw the KB article that referenced that issue but it looked as though it
was fixed in SP1 of Version 7. We're running SP3 of Version 2000. I used
the client utilities from a separate client machine here in the states. I
had a colleague remote desktop to the SQL Server itself running the tools on
the local SQL Server and he received the same errors that I'm getting.
Jerry
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uMu8ZbIjFHA.3784@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> There used to be a problem with SQL Server 7.0 with running the ITW on a
> client PC using a different locale than the one on the server. Have you
> tried running the ITW on the server itself (off-hours)?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com|||Jerry Spivey wrote:
> David,
> I saw the KB article that referenced that issue but it looked as
> though it was fixed in SP1 of Version 7. We're running SP3 of
> Version 2000. I used the client utilities from a separate client
> machine here in the states. I had a colleague remote desktop to the
> SQL Server itself running the tools on the local SQL Server and he
> received the same errors that I'm getting.
> Jerry
>
Have you examined the contents of the workload file to see what was
actually captured? If so, what happens if you copy one of the commands
and tune is manually from Query Analyzer. Does it work? How many
workload queries did you tell the ITW to examine in the workload file?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Yea that is my approach right now. I'm copy and pasting individual
statements into QA using the QAS option. Haven't found the culprit yet -
about 90 left to go.
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:eOlxUkIjFHA.2904@.tk2msftngp13.phx.gbl...
> Jerry Spivey wrote:
> Have you examined the contents of the workload file to see what was
> actually captured? If so, what happens if you copy one of the commands and
> tune is manually from Query Analyzer. Does it work? How many workload
> queries did you tell the ITW to examine in the workload file?
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
Friday, March 9, 2012
Issue with Index Tuning Wizard.
SQL2K SP4
Howdy all. When trying to use ITW, I get a message saying
"The workload does not contain any any events or queries that can be tuned
against the current database. Check to see the scripty contains valid events
or that the SQL script contains valid queries and that you are tuning
against the right database".
I have verified everything, I am doing it right. I googled this topic, and
see others have posted the same issue, but have found no clear resolution.
Any ideas?
TIA, ChrisRChrisR
If I understood you have ran SQL Server Profiler to collect the events
(queries/stored procuders) and later on you would like to load the file into
ITW?
Can you provide a list of events you have collect to ?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>|||I am on a test box. I have only run 1 sproc while running profiler. I
filtered it down to just my test DB. All I collected was:
Stored Procs
RPC:Completed
TSQL
SQL:BatchCompleted.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
> ChrisR
> If I understood you have ran SQL Server Profiler to collect the events
> (queries/stored procuders) and later on you would like to load the file
> into ITW?
> Can you provide a list of events you have collect to ?
>
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>|||ChisR
Ok, how long did you run a profiler?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>I am on a test box. I have only run 1 sproc while running profiler. I
>filtered it down to just my test DB. All I collected was:
> Stored Procs
> RPC:Completed
> TSQL
> SQL:BatchCompleted.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>|||Long enough to run the sproc and capture it, about 40 seconds.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
> ChisR
> Ok, how long did you run a profiler?
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>|||ChrisR
I did just some testing ( run it about 1 hour) and ITW was able to recommed
some indexes. I think 40sec you have ran the trace is pretty small period of
time for ITW make suggestions
"ChrisR" <ChrisR@.foo.com> wrote in message
news:ONYuBI1LHHA.2028@.TK2MSFTNGP03.phx.gbl...
> Long enough to run the sproc and capture it, about 40 seconds.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
>|||you need to add more events for running profiler and u have to run it
for most of the processes which uses the table u need to indent and to
run for more time to catch enough events. the frequecy of operations
also be considered by the ITW. the best practice is to run the get the
profiler data from an environment with heavy database access.
*** Sent via Developersdex http://www.codecomments.com ***|||I'll try your suggestions first thing.
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>
Howdy all. When trying to use ITW, I get a message saying
"The workload does not contain any any events or queries that can be tuned
against the current database. Check to see the scripty contains valid events
or that the SQL script contains valid queries and that you are tuning
against the right database".
I have verified everything, I am doing it right. I googled this topic, and
see others have posted the same issue, but have found no clear resolution.
Any ideas?
TIA, ChrisRChrisR
If I understood you have ran SQL Server Profiler to collect the events
(queries/stored procuders) and later on you would like to load the file into
ITW?
Can you provide a list of events you have collect to ?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>|||I am on a test box. I have only run 1 sproc while running profiler. I
filtered it down to just my test DB. All I collected was:
Stored Procs
RPC:Completed
TSQL
SQL:BatchCompleted.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
> ChrisR
> If I understood you have ran SQL Server Profiler to collect the events
> (queries/stored procuders) and later on you would like to load the file
> into ITW?
> Can you provide a list of events you have collect to ?
>
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>|||ChisR
Ok, how long did you run a profiler?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>I am on a test box. I have only run 1 sproc while running profiler. I
>filtered it down to just my test DB. All I collected was:
> Stored Procs
> RPC:Completed
> TSQL
> SQL:BatchCompleted.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>|||Long enough to run the sproc and capture it, about 40 seconds.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
> ChisR
> Ok, how long did you run a profiler?
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>|||ChrisR
I did just some testing ( run it about 1 hour) and ITW was able to recommed
some indexes. I think 40sec you have ran the trace is pretty small period of
time for ITW make suggestions
"ChrisR" <ChrisR@.foo.com> wrote in message
news:ONYuBI1LHHA.2028@.TK2MSFTNGP03.phx.gbl...
> Long enough to run the sproc and capture it, about 40 seconds.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
>|||you need to add more events for running profiler and u have to run it
for most of the processes which uses the table u need to indent and to
run for more time to catch enough events. the frequecy of operations
also be considered by the ITW. the best practice is to run the get the
profiler data from an environment with heavy database access.
*** Sent via Developersdex http://www.codecomments.com ***|||I'll try your suggestions first thing.
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>
Issue with Index Tuning Wizard.
SQL2K SP4
Howdy all. When trying to use ITW, I get a message saying
"The workload does not contain any any events or queries that can be tuned
against the current database. Check to see the scripty contains valid events
or that the SQL script contains valid queries and that you are tuning
against the right database".
I have verified everything, I am doing it right. I googled this topic, and
see others have posted the same issue, but have found no clear resolution.
Any ideas?
TIA, ChrisR
ChrisR
If I understood you have ran SQL Server Profiler to collect the events
(queries/stored procuders) and later on you would like to load the file into
ITW?
Can you provide a list of events you have collect to ?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>
|||I am on a test box. I have only run 1 sproc while running profiler. I
filtered it down to just my test DB. All I collected was:
Stored Procs
RPC:Completed
TSQL
SQL:BatchCompleted.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
> ChrisR
> If I understood you have ran SQL Server Profiler to collect the events
> (queries/stored procuders) and later on you would like to load the file
> into ITW?
> Can you provide a list of events you have collect to ?
>
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>
|||ChisR
Ok, how long did you run a profiler?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>I am on a test box. I have only run 1 sproc while running profiler. I
>filtered it down to just my test DB. All I collected was:
> Stored Procs
> RPC:Completed
> TSQL
> SQL:BatchCompleted.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>
|||Long enough to run the sproc and capture it, about 40 seconds.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
> ChisR
> Ok, how long did you run a profiler?
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>
|||ChrisR
I did just some testing ( run it about 1 hour) and ITW was able to recommed
some indexes. I think 40sec you have ran the trace is pretty small period of
time for ITW make suggestions
"ChrisR" <ChrisR@.foo.com> wrote in message
news:ONYuBI1LHHA.2028@.TK2MSFTNGP03.phx.gbl...
> Long enough to run the sproc and capture it, about 40 seconds.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
>
|||you need to add more events for running profiler and u have to run it
for most of the processes which uses the table u need to indent and to
run for more time to catch enough events. the frequecy of operations
also be considered by the ITW. the best practice is to run the get the
profiler data from an environment with heavy database access.
*** Sent via Developersdex http://www.codecomments.com ***
|||I'll try your suggestions first thing.
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>
Howdy all. When trying to use ITW, I get a message saying
"The workload does not contain any any events or queries that can be tuned
against the current database. Check to see the scripty contains valid events
or that the SQL script contains valid queries and that you are tuning
against the right database".
I have verified everything, I am doing it right. I googled this topic, and
see others have posted the same issue, but have found no clear resolution.
Any ideas?
TIA, ChrisR
ChrisR
If I understood you have ran SQL Server Profiler to collect the events
(queries/stored procuders) and later on you would like to load the file into
ITW?
Can you provide a list of events you have collect to ?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>
|||I am on a test box. I have only run 1 sproc while running profiler. I
filtered it down to just my test DB. All I collected was:
Stored Procs
RPC:Completed
TSQL
SQL:BatchCompleted.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
> ChrisR
> If I understood you have ran SQL Server Profiler to collect the events
> (queries/stored procuders) and later on you would like to load the file
> into ITW?
> Can you provide a list of events you have collect to ?
>
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>
|||ChisR
Ok, how long did you run a profiler?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>I am on a test box. I have only run 1 sproc while running profiler. I
>filtered it down to just my test DB. All I collected was:
> Stored Procs
> RPC:Completed
> TSQL
> SQL:BatchCompleted.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>
|||Long enough to run the sproc and capture it, about 40 seconds.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
> ChisR
> Ok, how long did you run a profiler?
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>
|||ChrisR
I did just some testing ( run it about 1 hour) and ITW was able to recommed
some indexes. I think 40sec you have ran the trace is pretty small period of
time for ITW make suggestions
"ChrisR" <ChrisR@.foo.com> wrote in message
news:ONYuBI1LHHA.2028@.TK2MSFTNGP03.phx.gbl...
> Long enough to run the sproc and capture it, about 40 seconds.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
>
|||you need to add more events for running profiler and u have to run it
for most of the processes which uses the table u need to indent and to
run for more time to catch enough events. the frequecy of operations
also be considered by the ITW. the best practice is to run the get the
profiler data from an environment with heavy database access.
*** Sent via Developersdex http://www.codecomments.com ***
|||I'll try your suggestions first thing.
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>
Issue with Index Tuning Wizard.
SQL2K SP4
Howdy all. When trying to use ITW, I get a message saying
"The workload does not contain any any events or queries that can be tuned
against the current database. Check to see the scripty contains valid events
or that the SQL script contains valid queries and that you are tuning
against the right database".
I have verified everything, I am doing it right. I googled this topic, and
see others have posted the same issue, but have found no clear resolution.
Any ideas?
TIA, ChrisRChrisR
If I understood you have ran SQL Server Profiler to collect the events
(queries/stored procuders) and later on you would like to load the file into
ITW?
Can you provide a list of events you have collect to ?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>|||I am on a test box. I have only run 1 sproc while running profiler. I
filtered it down to just my test DB. All I collected was:
Stored Procs
RPC:Completed
TSQL
SQL:BatchCompleted.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
> ChrisR
> If I understood you have ran SQL Server Profiler to collect the events
> (queries/stored procuders) and later on you would like to load the file
> into ITW?
> Can you provide a list of events you have collect to ?
>
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>> SQL2K SP4
>> Howdy all. When trying to use ITW, I get a message saying
>> "The workload does not contain any any events or queries that can be
>> tuned against the current database. Check to see the scripty contains
>> valid events or that the SQL script contains valid queries and that you
>> are tuning against the right database".
>> I have verified everything, I am doing it right. I googled this topic,
>> and see others have posted the same issue, but have found no clear
>> resolution.
>> Any ideas?
>> TIA, ChrisR
>|||ChisR
Ok, how long did you run a profiler?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>I am on a test box. I have only run 1 sproc while running profiler. I
>filtered it down to just my test DB. All I collected was:
> Stored Procs
> RPC:Completed
> TSQL
> SQL:BatchCompleted.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>> ChrisR
>> If I understood you have ran SQL Server Profiler to collect the events
>> (queries/stored procuders) and later on you would like to load the file
>> into ITW?
>> Can you provide a list of events you have collect to ?
>>
>>
>> "ChrisR" <ChrisR@.foo.com> wrote in message
>> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>> SQL2K SP4
>> Howdy all. When trying to use ITW, I get a message saying
>> "The workload does not contain any any events or queries that can be
>> tuned against the current database. Check to see the scripty contains
>> valid events or that the SQL script contains valid queries and that you
>> are tuning against the right database".
>> I have verified everything, I am doing it right. I googled this topic,
>> and see others have posted the same issue, but have found no clear
>> resolution.
>> Any ideas?
>> TIA, ChrisR
>>
>|||Long enough to run the sproc and capture it, about 40 seconds.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
> ChisR
> Ok, how long did you run a profiler?
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>>I am on a test box. I have only run 1 sproc while running profiler. I
>>filtered it down to just my test DB. All I collected was:
>> Stored Procs
>> RPC:Completed
>> TSQL
>> SQL:BatchCompleted.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>> ChrisR
>> If I understood you have ran SQL Server Profiler to collect the events
>> (queries/stored procuders) and later on you would like to load the file
>> into ITW?
>> Can you provide a list of events you have collect to ?
>>
>>
>> "ChrisR" <ChrisR@.foo.com> wrote in message
>> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>> SQL2K SP4
>> Howdy all. When trying to use ITW, I get a message saying
>> "The workload does not contain any any events or queries that can be
>> tuned against the current database. Check to see the scripty contains
>> valid events or that the SQL script contains valid queries and that you
>> are tuning against the right database".
>> I have verified everything, I am doing it right. I googled this topic,
>> and see others have posted the same issue, but have found no clear
>> resolution.
>> Any ideas?
>> TIA, ChrisR
>>
>>
>|||ChrisR
I did just some testing ( run it about 1 hour) and ITW was able to recommed
some indexes. I think 40sec you have ran the trace is pretty small period of
time for ITW make suggestions
"ChrisR" <ChrisR@.foo.com> wrote in message
news:ONYuBI1LHHA.2028@.TK2MSFTNGP03.phx.gbl...
> Long enough to run the sproc and capture it, about 40 seconds.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
>> ChisR
>> Ok, how long did you run a profiler?
>>
>> "ChrisR" <ChrisR@.foo.com> wrote in message
>> news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>>I am on a test box. I have only run 1 sproc while running profiler. I
>>filtered it down to just my test DB. All I collected was:
>> Stored Procs
>> RPC:Completed
>> TSQL
>> SQL:BatchCompleted.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>> ChrisR
>> If I understood you have ran SQL Server Profiler to collect the events
>> (queries/stored procuders) and later on you would like to load the file
>> into ITW?
>> Can you provide a list of events you have collect to ?
>>
>>
>> "ChrisR" <ChrisR@.foo.com> wrote in message
>> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>> SQL2K SP4
>> Howdy all. When trying to use ITW, I get a message saying
>> "The workload does not contain any any events or queries that can be
>> tuned against the current database. Check to see the scripty contains
>> valid events or that the SQL script contains valid queries and that
>> you are tuning against the right database".
>> I have verified everything, I am doing it right. I googled this topic,
>> and see others have posted the same issue, but have found no clear
>> resolution.
>> Any ideas?
>> TIA, ChrisR
>>
>>
>>
>|||I'll try your suggestions first thing.
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>
Howdy all. When trying to use ITW, I get a message saying
"The workload does not contain any any events or queries that can be tuned
against the current database. Check to see the scripty contains valid events
or that the SQL script contains valid queries and that you are tuning
against the right database".
I have verified everything, I am doing it right. I googled this topic, and
see others have posted the same issue, but have found no clear resolution.
Any ideas?
TIA, ChrisRChrisR
If I understood you have ran SQL Server Profiler to collect the events
(queries/stored procuders) and later on you would like to load the file into
ITW?
Can you provide a list of events you have collect to ?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>|||I am on a test box. I have only run 1 sproc while running profiler. I
filtered it down to just my test DB. All I collected was:
Stored Procs
RPC:Completed
TSQL
SQL:BatchCompleted.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
> ChrisR
> If I understood you have ran SQL Server Profiler to collect the events
> (queries/stored procuders) and later on you would like to load the file
> into ITW?
> Can you provide a list of events you have collect to ?
>
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>> SQL2K SP4
>> Howdy all. When trying to use ITW, I get a message saying
>> "The workload does not contain any any events or queries that can be
>> tuned against the current database. Check to see the scripty contains
>> valid events or that the SQL script contains valid queries and that you
>> are tuning against the right database".
>> I have verified everything, I am doing it right. I googled this topic,
>> and see others have posted the same issue, but have found no clear
>> resolution.
>> Any ideas?
>> TIA, ChrisR
>|||ChisR
Ok, how long did you run a profiler?
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>I am on a test box. I have only run 1 sproc while running profiler. I
>filtered it down to just my test DB. All I collected was:
> Stored Procs
> RPC:Completed
> TSQL
> SQL:BatchCompleted.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>> ChrisR
>> If I understood you have ran SQL Server Profiler to collect the events
>> (queries/stored procuders) and later on you would like to load the file
>> into ITW?
>> Can you provide a list of events you have collect to ?
>>
>>
>> "ChrisR" <ChrisR@.foo.com> wrote in message
>> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>> SQL2K SP4
>> Howdy all. When trying to use ITW, I get a message saying
>> "The workload does not contain any any events or queries that can be
>> tuned against the current database. Check to see the scripty contains
>> valid events or that the SQL script contains valid queries and that you
>> are tuning against the right database".
>> I have verified everything, I am doing it right. I googled this topic,
>> and see others have posted the same issue, but have found no clear
>> resolution.
>> Any ideas?
>> TIA, ChrisR
>>
>|||Long enough to run the sproc and capture it, about 40 seconds.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
> ChisR
> Ok, how long did you run a profiler?
>
> "ChrisR" <ChrisR@.foo.com> wrote in message
> news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>>I am on a test box. I have only run 1 sproc while running profiler. I
>>filtered it down to just my test DB. All I collected was:
>> Stored Procs
>> RPC:Completed
>> TSQL
>> SQL:BatchCompleted.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>> ChrisR
>> If I understood you have ran SQL Server Profiler to collect the events
>> (queries/stored procuders) and later on you would like to load the file
>> into ITW?
>> Can you provide a list of events you have collect to ?
>>
>>
>> "ChrisR" <ChrisR@.foo.com> wrote in message
>> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>> SQL2K SP4
>> Howdy all. When trying to use ITW, I get a message saying
>> "The workload does not contain any any events or queries that can be
>> tuned against the current database. Check to see the scripty contains
>> valid events or that the SQL script contains valid queries and that you
>> are tuning against the right database".
>> I have verified everything, I am doing it right. I googled this topic,
>> and see others have posted the same issue, but have found no clear
>> resolution.
>> Any ideas?
>> TIA, ChrisR
>>
>>
>|||ChrisR
I did just some testing ( run it about 1 hour) and ITW was able to recommed
some indexes. I think 40sec you have ran the trace is pretty small period of
time for ITW make suggestions
"ChrisR" <ChrisR@.foo.com> wrote in message
news:ONYuBI1LHHA.2028@.TK2MSFTNGP03.phx.gbl...
> Long enough to run the sproc and capture it, about 40 seconds.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eeLIhE1LHHA.3668@.TK2MSFTNGP02.phx.gbl...
>> ChisR
>> Ok, how long did you run a profiler?
>>
>> "ChrisR" <ChrisR@.foo.com> wrote in message
>> news:%23F087B1LHHA.5000@.TK2MSFTNGP03.phx.gbl...
>>I am on a test box. I have only run 1 sproc while running profiler. I
>>filtered it down to just my test DB. All I collected was:
>> Stored Procs
>> RPC:Completed
>> TSQL
>> SQL:BatchCompleted.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OhBw4%230LHHA.536@.TK2MSFTNGP02.phx.gbl...
>> ChrisR
>> If I understood you have ran SQL Server Profiler to collect the events
>> (queries/stored procuders) and later on you would like to load the file
>> into ITW?
>> Can you provide a list of events you have collect to ?
>>
>>
>> "ChrisR" <ChrisR@.foo.com> wrote in message
>> news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
>> SQL2K SP4
>> Howdy all. When trying to use ITW, I get a message saying
>> "The workload does not contain any any events or queries that can be
>> tuned against the current database. Check to see the scripty contains
>> valid events or that the SQL script contains valid queries and that
>> you are tuning against the right database".
>> I have verified everything, I am doing it right. I googled this topic,
>> and see others have posted the same issue, but have found no clear
>> resolution.
>> Any ideas?
>> TIA, ChrisR
>>
>>
>>
>|||I'll try your suggestions first thing.
"ChrisR" <ChrisR@.foo.com> wrote in message
news:%23UBWE00LHHA.5104@.TK2MSFTNGP06.phx.gbl...
> SQL2K SP4
> Howdy all. When trying to use ITW, I get a message saying
> "The workload does not contain any any events or queries that can be tuned
> against the current database. Check to see the scripty contains valid
> events or that the SQL script contains valid queries and that you are
> tuning against the right database".
> I have verified everything, I am doing it right. I googled this topic, and
> see others have posted the same issue, but have found no clear resolution.
> Any ideas?
> TIA, ChrisR
>
Subscribe to:
Posts (Atom)