does anybody aware of any issues when installing SQL2K in NT4 domain? Help is greatly appreciated.
sorry, forgat to add: using MSCS on W2k3 servers
-- igor_gonik@.dell.com wrote: --
does anybody aware of any issues when installing SQL2K in NT4 domain? Help is greatly appreciated.
|||Nope.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||It should work
Rand
This posting is provided "as is" with no warranties and confers no rights.
Showing posts with label sql2k. Show all posts
Showing posts with label sql2k. Show all posts
Monday, March 19, 2012
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
>
Wednesday, March 7, 2012
Issue with DTS from Sql25k
Hi everyone,
I understand that this is an issue. Microsofts doesn't inform anywhere
When you've got in your workstation both Sql2k and Sql25k clients and try to install the package for design dts 2000 from Sql25k then you'll not be able to re-start your Enterprise Manager from
MMC.
Appears this error:
?ProcessExecute@.@.YAXPAUHWND_@.@.PBG1@.Z dynamic link library procedure start point is not founded (SEMSFC.DLL)
Query Analyzer starts as usual, without problems but you lose your EM.
TIA
If you have both 2000 and 2005 client tools installed, you do not need the "SQL 2005 Compatibility DTS tools" installed. First, uninstall them. Then figure out what is causing your other error, that says you need to install them.My problem seems to have been the SQL 7 client tools were also installed, so I had 7, 2000 and 2005. This confused 2005. As soon as I uninstalled the SQL 7 client tools, the error went away and I was able to run the DTS designer in 2005.|||
Hi Tom,
Thanks for your response. I get the point but at least it could be reported.
|||What it really need to do is give you a valid error message, instead of "install DTS components" which you don't need to do. :) If it said "could not find xxxxx" or "error in .DLL" or something, then it wouldn't lead people, including myself, down the wrong path.
Subscribe to:
Posts (Atom)