"PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in message
news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...
> Hello,
>
> i am trying to to store some performance monitor counters into a SQl
> Server
> Database (SQL 2005 Std, on a W2K3 cluster environment).
>
> It seems to be working, using an ODBC Datasource with the SQLServer driver
> (th native client is not compatible with an odbc feature according to a
> message in the event viewer).
>
> But, it cannot return on Physical Disk Queue Length. And the reason seams
> quite simple : my server is French...thus there is a quote in "Longueur de
> file d'attente", which produces this error. Same problem with any other
> counter that includes a quote ' in its name.
>
> And it doesn't seem that the performznce monitor sends tsql batch using
> quotes, which would have help with the quoted_identifiers ON.
>
> Do you have any work around for this problem ?
>
> Thank you very much
>
> X.M.
>

"Andrew J. Kelly" wrote:

> Are you logging directly from Perfmon to SQL Server? If so try logging to a
> file first and then using Relog to load to a table. I am not sure if this
> will matter or not since they both use ODBC but there may be a slight
> difference in the way Relog works over Perfmon when connecting.
>
> relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o SQL:YourDSN!YourDescriptor
>
> Type relog.exe /? for details on the commands.
>
>
> --
> Andrew J. Kelly    SQL MVP
> Solid Quality Mentors
>
>
> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in message
> news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...
> > Hello,
> >
> > i am trying to to store some performance monitor counters into a SQl
> > Server
> > Database (SQL 2005 Std, on a W2K3 cluster environment).
> >
> > It seems to be working, using an ODBC Datasource with the SQLServer driver
> > (th native client is not compatible with an odbc feature according to a
> > message in the event viewer).
> >
> > But, it cannot return on Physical Disk Queue Length. And the reason seams
> > quite simple : my server is French...thus there is a quote in "Longueur de
> > file d'attente", which produces this error. Same problem with any other
> > counter that includes a quote ' in its name.
> >
> > And it doesn't seem that the performznce monitor sends tsql batch using
> > quotes, which would have help with the quoted_identifiers ON.
> >
> > Do you have any work around for this problem ?
> >
> > Thank you very much
> >
> > X.M.
> >
>
>

"PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in message
news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@microsoft.com...
> Andrew,
>
> thank you for this answer.
> Yes, I log striaght into SQL Server from Perfmon.
>
> Following your advice, I used relog, but unfortunately, the same problem
> occurs when it tries to insert the CounterDetail line with the containing
> the
> quote mark.
> Same problem as with the Performance Monitor. Same ODBC Problem I guess
> regarding quotation mark and quoted identifiers.
>
> You will find below the SQL Batch and the error caught in the SQL Profiler
>
> Any other workaround ?
>
> Xavier
>
>
> SQL Error
> Exception : Error: 105, Severity: 15, State: 1
> USer Error Message : Ouvrez les guillemets après la chaîne de caractères
> ',NULL,NULL,NULL,10000000,0) Select @@Identity commit transaction
> AddCounterDetails'.
> SQL Batch
> begin transaction AddCounterDetails insert into CounterDetails values
> ('\\MyServer','Disque physique','Long. moy. de file d'attente du
> disque',5571840,2,'1 M:',NULL,NULL,NULL,10000000,0) Select @@Identity
> commit
> transaction AddCounterDetails
>
> "Andrew J. Kelly" wrote:
>
>> Are you logging directly from Perfmon to SQL Server? If so try logging to
>> a
>> file first and then using Relog to load to a table. I am not sure if this
>> will matter or not since they both use ODBC but there may be a slight
>> difference in the way Relog works over Perfmon when connecting.
>>
>> relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o
>> SQL:YourDSN!YourDescriptor
>>
>> Type relog.exe /? for details on the commands.
>>
>>
>> --
>> Andrew J. Kelly    SQL MVP
>> Solid Quality Mentors
>>
>>
>> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
>> message
>> news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...
>> > Hello,
>> >
>> > i am trying to to store some performance monitor counters into a SQl
>> > Server
>> > Database (SQL 2005 Std, on a W2K3 cluster environment).
>> >
>> > It seems to be working, using an ODBC Datasource with the SQLServer
>> > driver
>> > (th native client is not compatible with an odbc feature according to a
>> > message in the event viewer).
>> >
>> > But, it cannot return on Physical Disk Queue Length. And the reason
>> > seams
>> > quite simple : my server is French...thus there is a quote in "Longueur
>> > de
>> > file d'attente", which produces this error. Same problem with any other
>> > counter that includes a quote ' in its name.
>> >
>> > And it doesn't seem that the performznce monitor sends tsql batch using
>> > quotes, which would have help with the quoted_identifiers ON.
>> >
>> > Do you have any work around for this problem ?
>> >
>> > Thank you very much
>> >
>> > X.M.
>> >
>>
>>

"Andrew J. Kelly" wrote:

> What type of file are you using to log to, Binary?  All I can think of is to
> try different file types to see if there is one that works better with ODBC.
>
> --
> Andrew J. Kelly    SQL MVP
> Solid Quality Mentors
>
>
> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in message
> news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@microsoft.com...
> > Andrew,
> >
> > thank you for this answer.
> > Yes, I log striaght into SQL Server from Perfmon.
> >
> > Following your advice, I used relog, but unfortunately, the same problem
> > occurs when it tries to insert the CounterDetail line with the containing
> > the
> > quote mark.
> > Same problem as with the Performance Monitor. Same ODBC Problem I guess
> > regarding quotation mark and quoted identifiers.
> >
> > You will find below the SQL Batch and the error caught in the SQL Profiler
> >
> > Any other workaround ?
> >
> > Xavier
> >
> >
> > SQL Error
> > Exception : Error: 105, Severity: 15, State: 1
> > USer Error Message : Ouvrez les guillemets après la chaîne de caractères
> > ',NULL,NULL,NULL,10000000,0) Select @@Identity commit transaction
> > AddCounterDetails'.
> > SQL Batch
> > begin transaction AddCounterDetails insert into CounterDetails values
> > ('\\MyServer','Disque physique','Long. moy. de file d'attente du
> > disque',5571840,2,'1 M:',NULL,NULL,NULL,10000000,0) Select @@Identity
> > commit
> > transaction AddCounterDetails
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Are you logging directly from Perfmon to SQL Server? If so try logging to
> >> a
> >> file first and then using Relog to load to a table. I am not sure if this
> >> will matter or not since they both use ODBC but there may be a slight
> >> difference in the way Relog works over Perfmon when connecting.
> >>
> >> relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o
> >> SQL:YourDSN!YourDescriptor
> >>
> >> Type relog.exe /? for details on the commands.
> >>
> >>
> >> --
> >> Andrew J. Kelly    SQL MVP
> >> Solid Quality Mentors
> >>
> >>
> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
> >> message
> >> news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...
> >> > Hello,
> >> >
> >> > i am trying to to store some performance monitor counters into a SQl
> >> > Server
> >> > Database (SQL 2005 Std, on a W2K3 cluster environment).
> >> >
> >> > It seems to be working, using an ODBC Datasource with the SQLServer
> >> > driver
> >> > (th native client is not compatible with an odbc feature according to a
> >> > message in the event viewer).
> >> >
> >> > But, it cannot return on Physical Disk Queue Length. And the reason
> >> > seams
> >> > quite simple : my server is French...thus there is a quote in "Longueur
> >> > de
> >> > file d'attente", which produces this error. Same problem with any other
> >> > counter that includes a quote ' in its name.
> >> >
> >> > And it doesn't seem that the performznce monitor sends tsql batch using
> >> > quotes, which would have help with the quoted_identifiers ON.
> >> >
> >> > Do you have any work around for this problem ?
> >> >
> >> > Thank you very much
> >> >
> >> > X.M.
> >> >
> >>
> >>
>
>

"PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in message
news:FFE6B1F0-33A8-4C3C-984F-434FCA1ED14F@microsoft.com...
> Andrew,
>
> I tried csv, tsv, blg and circular blg...it doesn't make any difference.
> Still the ' error.
>
> Any other possibilities ?
>
> Xavier
>
> "Andrew J. Kelly" wrote:
>
>> What type of file are you using to log to, Binary?  All I can think of is
>> to
>> try different file types to see if there is one that works better with
>> ODBC.
>>
>> --
>> Andrew J. Kelly    SQL MVP
>> Solid Quality Mentors
>>
>>
>> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
>> message
>> news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@microsoft.com...
>> > Andrew,
>> >
>> > thank you for this answer.
>> > Yes, I log striaght into SQL Server from Perfmon.
>> >
>> > Following your advice, I used relog, but unfortunately, the same
>> > problem
>> > occurs when it tries to insert the CounterDetail line with the
>> > containing
>> > the
>> > quote mark.
>> > Same problem as with the Performance Monitor. Same ODBC Problem I guess
>> > regarding quotation mark and quoted identifiers.
>> >
>> > You will find below the SQL Batch and the error caught in the SQL
>> > Profiler
>> >
>> > Any other workaround ?
>> >
>> > Xavier
>> >
>> >
>> > SQL Error
>> > Exception : Error: 105, Severity: 15, State: 1
>> > USer Error Message : Ouvrez les guillemets après la chaîne de
>> > caractères
>> > ',NULL,NULL,NULL,10000000,0) Select @@Identity commit transaction
>> > AddCounterDetails'.
>> > SQL Batch
>> > begin transaction AddCounterDetails insert into CounterDetails values
>> > ('\\MyServer','Disque physique','Long. moy. de file d'attente du
>> > disque',5571840,2,'1 M:',NULL,NULL,NULL,10000000,0) Select @@Identity
>> > commit
>> > transaction AddCounterDetails
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> Are you logging directly from Perfmon to SQL Server? If so try logging
>> >> to
>> >> a
>> >> file first and then using Relog to load to a table. I am not sure if
>> >> this
>> >> will matter or not since they both use ODBC but there may be a slight
>> >> difference in the way Relog works over Perfmon when connecting.
>> >>
>> >> relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o
>> >> SQL:YourDSN!YourDescriptor
>> >>
>> >> Type relog.exe /? for details on the commands.
>> >>
>> >>
>> >> --
>> >> Andrew J. Kelly    SQL MVP
>> >> Solid Quality Mentors
>> >>
>> >>
>> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
>> >> message
>> >> news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...
>> >> > Hello,
>> >> >
>> >> > i am trying to to store some performance monitor counters into a SQl
>> >> > Server
>> >> > Database (SQL 2005 Std, on a W2K3 cluster environment).
>> >> >
>> >> > It seems to be working, using an ODBC Datasource with the SQLServer
>> >> > driver
>> >> > (th native client is not compatible with an odbc feature according
>> >> > to a
>> >> > message in the event viewer).
>> >> >
>> >> > But, it cannot return on Physical Disk Queue Length. And the reason
>> >> > seams
>> >> > quite simple : my server is French...thus there is a quote in
>> >> > "Longueur
>> >> > de
>> >> > file d'attente", which produces this error. Same problem with any
>> >> > other
>> >> > counter that includes a quote ' in its name.
>> >> >
>> >> > And it doesn't seem that the performznce monitor sends tsql batch
>> >> > using
>> >> > quotes, which would have help with the quoted_identifiers ON.
>> >> >
>> >> > Do you have any work around for this problem ?
>> >> >
>> >> > Thank you very much
>> >> >
>> >> > X.M.
>> >> >
>> >>
>> >>
>>
>>

"Andrew J. Kelly" wrote:

> Well the only other thing I can think of is to log to a character format
> (CSV etc.) and edit the file by replacing those offending quotes with
> something else before importing with Relog to the table.
>
> --
> Andrew J. Kelly    SQL MVP
> Solid Quality Mentors
>
>
> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in message
> news:FFE6B1F0-33A8-4C3C-984F-434FCA1ED14F@microsoft.com...
> > Andrew,
> >
> > I tried csv, tsv, blg and circular blg...it doesn't make any difference.
> > Still the ' error.
> >
> > Any other possibilities ?
> >
> > Xavier
> >
> > "Andrew J. Kelly" wrote:
> >
> >> What type of file are you using to log to, Binary?  All I can think of is
> >> to
> >> try different file types to see if there is one that works better with
> >> ODBC.
> >>
> >> --
> >> Andrew J. Kelly    SQL MVP
> >> Solid Quality Mentors
> >>
> >>
> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
> >> message
> >> news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@microsoft.com...
> >> > Andrew,
> >> >
> >> > thank you for this answer.
> >> > Yes, I log striaght into SQL Server from Perfmon.
> >> >
> >> > Following your advice, I used relog, but unfortunately, the same
> >> > problem
> >> > occurs when it tries to insert the CounterDetail line with the
> >> > containing
> >> > the
> >> > quote mark.
> >> > Same problem as with the Performance Monitor. Same ODBC Problem I guess
> >> > regarding quotation mark and quoted identifiers.
> >> >
> >> > You will find below the SQL Batch and the error caught in the SQL
> >> > Profiler
> >> >
> >> > Any other workaround ?
> >> >
> >> > Xavier
> >> >
> >> >
> >> > SQL Error
> >> > Exception : Error: 105, Severity: 15, State: 1
> >> > USer Error Message : Ouvrez les guillemets après la chaîne de
> >> > caractères
> >> > ',NULL,NULL,NULL,10000000,0) Select @@Identity commit transaction
> >> > AddCounterDetails'.
> >> > SQL Batch
> >> > begin transaction AddCounterDetails insert into CounterDetails values
> >> > ('\\MyServer','Disque physique','Long. moy. de file d'attente du
> >> > disque',5571840,2,'1 M:',NULL,NULL,NULL,10000000,0) Select @@Identity
> >> > commit
> >> > transaction AddCounterDetails
> >> >
> >> > "Andrew J. Kelly" wrote:
> >> >
> >> >> Are you logging directly from Perfmon to SQL Server? If so try logging
> >> >> to
> >> >> a
> >> >> file first and then using Relog to load to a table. I am not sure if
> >> >> this
> >> >> will matter or not since they both use ODBC but there may be a slight
> >> >> difference in the way Relog works over Perfmon when connecting.
> >> >>
> >> >> relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o
> >> >> SQL:YourDSN!YourDescriptor
> >> >>
> >> >> Type relog.exe /? for details on the commands.
> >> >>
> >> >>
> >> >> --
> >> >> Andrew J. Kelly    SQL MVP
> >> >> Solid Quality Mentors
> >> >>
> >> >>
> >> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...
> >> >> > Hello,
> >> >> >
> >> >> > i am trying to to store some performance monitor counters into a SQl
> >> >> > Server
> >> >> > Database (SQL 2005 Std, on a W2K3 cluster environment).
> >> >> >
> >> >> > It seems to be working, using an ODBC Datasource with the SQLServer
> >> >> > driver
> >> >> > (th native client is not compatible with an odbc feature according
> >> >> > to a
> >> >> > message in the event viewer).
> >> >> >
> >> >> > But, it cannot return on Physical Disk Queue Length. And the reason
> >> >> > seams
> >> >> > quite simple : my server is French...thus there is a quote in
> >> >> > "Longueur
> >> >> > de
> >> >> > file d'attente", which produces this error. Same problem with any
> >> >> > other
> >> >> > counter that includes a quote ' in its name.
> >> >> >
> >> >> > And it doesn't seem that the performznce monitor sends tsql batch
> >> >> > using
> >> >> > quotes, which would have help with the quoted_identifiers ON.
> >> >> >
> >> >> > Do you have any work around for this problem ?
> >> >> >
> >> >> > Thank you very much
> >> >> >
> >> >> > X.M.
> >> >> >
> >> >>
> >> >>
> >>
> >>
>
>

"PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in message
news:6DF209C3-3BF1-408B-BC49-87EFD30E1130@microsoft.com...
> Thanks for you reply
>
> but this doesn't seems to me a good solution : there will be hundreds of
> lines in the files, and a lot of servers to manage in a very near future.
> This solution would be just working temporarily (a few servers), but not
> on
> a larger scale.
> Do you know if MOM would allow to get all these perfomance counters for a
> hundred servers ?
> What price would it be ?
>
> Thanks for your help.
>
> XM
>
> "Andrew J. Kelly" wrote:
>
>> Well the only other thing I can think of is to log to a character format
>> (CSV etc.) and edit the file by replacing those offending quotes with
>> something else before importing with Relog to the table.
>>
>> --
>> Andrew J. Kelly    SQL MVP
>> Solid Quality Mentors
>>
>>
>> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
>> message
>> news:FFE6B1F0-33A8-4C3C-984F-434FCA1ED14F@microsoft.com...
>> > Andrew,
>> >
>> > I tried csv, tsv, blg and circular blg...it doesn't make any
>> > difference.
>> > Still the ' error.
>> >
>> > Any other possibilities ?
>> >
>> > Xavier
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> What type of file are you using to log to, Binary?  All I can think of
>> >> is
>> >> to
>> >> try different file types to see if there is one that works better with
>> >> ODBC.
>> >>
>> >> --
>> >> Andrew J. Kelly    SQL MVP
>> >> Solid Quality Mentors
>> >>
>> >>
>> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
>> >> message
>> >> news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@microsoft.com...
>> >> > Andrew,
>> >> >
>> >> > thank you for this answer.
>> >> > Yes, I log striaght into SQL Server from Perfmon.
>> >> >
>> >> > Following your advice, I used relog, but unfortunately, the same
>> >> > problem
>> >> > occurs when it tries to insert the CounterDetail line with the
>> >> > containing
>> >> > the
>> >> > quote mark.
>> >> > Same problem as with the Performance Monitor. Same ODBC Problem I
>> >> > guess
>> >> > regarding quotation mark and quoted identifiers.
>> >> >
>> >> > You will find below the SQL Batch and the error caught in the SQL
>> >> > Profiler
>> >> >
>> >> > Any other workaround ?
>> >> >
>> >> > Xavier
>> >> >
>> >> >
>> >> > SQL Error
>> >> > Exception : Error: 105, Severity: 15, State: 1
>> >> > USer Error Message : Ouvrez les guillemets après la chaîne de
>> >> > caractères
>> >> > ',NULL,NULL,NULL,10000000,0) Select @@Identity commit transaction
>> >> > AddCounterDetails'.
>> >> > SQL Batch
>> >> > begin transaction AddCounterDetails insert into CounterDetails
>> >> > values
>> >> > ('\\MyServer','Disque physique','Long. moy. de file d'attente du
>> >> > disque',5571840,2,'1 M:',NULL,NULL,NULL,10000000,0) Select
>> >> > @@Identity
>> >> > commit
>> >> > transaction AddCounterDetails
>> >> >
>> >> > "Andrew J. Kelly" wrote:
>> >> >
>> >> >> Are you logging directly from Perfmon to SQL Server? If so try
>> >> >> logging
>> >> >> to
>> >> >> a
>> >> >> file first and then using Relog to load to a table. I am not sure
>> >> >> if
>> >> >> this
>> >> >> will matter or not since they both use ODBC but there may be a
>> >> >> slight
>> >> >> difference in the way Relog works over Perfmon when connecting.
>> >> >>
>> >> >> relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o
>> >> >> SQL:YourDSN!YourDescriptor
>> >> >>
>> >> >> Type relog.exe /? for details on the commands.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Andrew J. Kelly    SQL MVP
>> >> >> Solid Quality Mentors
>> >> >>
>> >> >>
>> >> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote
>> >> >> in
>> >> >> message
>> >> >> news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...
>> >> >> > Hello,
>> >> >> >
>> >> >> > i am trying to to store some performance monitor counters into a
>> >> >> > SQl
>> >> >> > Server
>> >> >> > Database (SQL 2005 Std, on a W2K3 cluster environment).
>> >> >> >
>> >> >> > It seems to be working, using an ODBC Datasource with the
>> >> >> > SQLServer
>> >> >> > driver
>> >> >> > (th native client is not compatible with an odbc feature
>> >> >> > according
>> >> >> > to a
>> >> >> > message in the event viewer).
>> >> >> >
>> >> >> > But, it cannot return on Physical Disk Queue Length. And the
>> >> >> > reason
>> >> >> > seams
>> >> >> > quite simple : my server is French...thus there is a quote in
>> >> >> > "Longueur
>> >> >> > de
>> >> >> > file d'attente", which produces this error. Same problem with any
>> >> >> > other
>> >> >> > counter that includes a quote ' in its name.
>> >> >> >
>> >> >> > And it doesn't seem that the performznce monitor sends tsql batch
>> >> >> > using
>> >> >> > quotes, which would have help with the quoted_identifiers ON.
>> >> >> >
>> >> >> > Do you have any work around for this problem ?
>> >> >> >
>> >> >> > Thank you very much
>> >> >> >
>> >> >> > X.M.
>> >> >> >
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>

"Andrew J. Kelly" wrote:

> Well I was talking about writing something that would programmatically do
> the search and replace and the inserts not manually.  But yes MOM can
> collect Perfmon data and is designed to work across an enterprise so that
> should not be a problem. I have no idea on the price though.
>
> --
> Andrew J. Kelly    SQL MVP
> Solid Quality Mentors
>
>
> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in message
> news:6DF209C3-3BF1-408B-BC49-87EFD30E1130@microsoft.com...
> > Thanks for you reply
> >
> > but this doesn't seems to me a good solution : there will be hundreds of
> > lines in the files, and a lot of servers to manage in a very near future.
> > This solution would be just working temporarily (a few servers), but not
> > on
> > a larger scale.
> > Do you know if MOM would allow to get all these perfomance counters for a
> > hundred servers ?
> > What price would it be ?
> >
> > Thanks for your help.
> >
> > XM
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Well the only other thing I can think of is to log to a character format
> >> (CSV etc.) and edit the file by replacing those offending quotes with
> >> something else before importing with Relog to the table.
> >>
> >> --
> >> Andrew J. Kelly    SQL MVP
> >> Solid Quality Mentors
> >>
> >>
> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
> >> message
> >> news:FFE6B1F0-33A8-4C3C-984F-434FCA1ED14F@microsoft.com...
> >> > Andrew,
> >> >
> >> > I tried csv, tsv, blg and circular blg...it doesn't make any
> >> > difference.
> >> > Still the ' error.
> >> >
> >> > Any other possibilities ?
> >> >
> >> > Xavier
> >> >
> >> > "Andrew J. Kelly" wrote:
> >> >
> >> >> What type of file are you using to log to, Binary?  All I can think of
> >> >> is
> >> >> to
> >> >> try different file types to see if there is one that works better with
> >> >> ODBC.
> >> >>
> >> >> --
> >> >> Andrew J. Kelly    SQL MVP
> >> >> Solid Quality Mentors
> >> >>
> >> >>
> >> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@microsoft.com...
> >> >> > Andrew,
> >> >> >
> >> >> > thank you for this answer.
> >> >> > Yes, I log striaght into SQL Server from Perfmon.
> >> >> >
> >> >> > Following your advice, I used relog, but unfortunately, the same
> >> >> > problem
> >> >> > occurs when it tries to insert the CounterDetail line with the
> >> >> > containing
> >> >> > the
> >> >> > quote mark.
> >> >> > Same problem as with the Performance Monitor. Same ODBC Problem I
> >> >> > guess
> >> >> > regarding quotation mark and quoted identifiers.
> >> >> >
> >> >> > You will find below the SQL Batch and the error caught in the SQL
> >> >> > Profiler
> >> >> >
> >> >> > Any other workaround ?
> >> >> >
> >> >> > Xavier
> >> >> >
> >> >> >
> >> >> > SQL Error
> >> >> > Exception : Error: 105, Severity: 15, State: 1
> >> >> > USer Error Message : Ouvrez les guillemets après la chaîne de
> >> >> > caractères
> >> >> > ',NULL,NULL,NULL,10000000,0) Select @@Identity commit transaction
> >> >> > AddCounterDetails'.
> >> >> > SQL Batch
> >> >> > begin transaction AddCounterDetails insert into CounterDetails
> >> >> > values
> >> >> > ('\\MyServer','Disque physique','Long. moy. de file d'attente du
> >> >> > disque',5571840,2,'1 M:',NULL,NULL,NULL,10000000,0) Select
> >> >> > @@Identity
> >> >> > commit
> >> >> > transaction AddCounterDetails
> >> >> >
> >> >> > "Andrew J. Kelly" wrote:
> >> >> >
> >> >> >> Are you logging directly from Perfmon to SQL Server? If so try
> >> >> >> logging
> >> >> >> to
> >> >> >> a
> >> >> >> file first and then using Relog to load to a table. I am not sure
> >> >> >> if
> >> >> >> this
> >> >> >> will matter or not since they both use ODBC but there may be a
> >> >> >> slight
> >> >> >> difference in the way Relog works over Perfmon when connecting.
> >> >> >>
> >> >> >> relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o
> >> >> >> SQL:YourDSN!YourDescriptor
> >> >> >>
> >> >> >> Type relog.exe /? for details on the commands.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Andrew J. Kelly    SQL MVP
> >> >> >> Solid Quality Mentors
> >> >> >>
> >> >> >>
> >> >> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote
> >> >> >> in
> >> >> >> message
> >> >> >> news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...
> >> >> >> > Hello,
> >> >> >> >
> >> >> >> > i am trying to to store some performance monitor counters into a
> >> >> >> > SQl
> >> >> >> > Server
> >> >> >> > Database (SQL 2005 Std, on a W2K3 cluster environment).
> >> >> >> >
> >> >> >> > It seems to be working, using an ODBC Datasource with the
> >> >> >> > SQLServer
> >> >> >> > driver
> >> >> >> > (th native client is not compatible with an odbc feature
> >> >> >> > according
> >> >> >> > to a
> >> >> >> > message in the event viewer).
> >> >> >> >
> >> >> >> > But, it cannot return on Physical Disk Queue Length. And the
> >> >> >> > reason
> >> >> >> > seams
> >> >> >> > quite simple : my server is French...thus there is a quote in
> >> >> >> > "Longueur
> >> >> >> > de
> >> >> >> > file d'attente", which produces this error. Same problem with any
> >> >> >> > other
> >> >> >> > counter that includes a quote ' in its name.
> >> >> >> >
> >> >> >> > And it doesn't seem that the performznce monitor sends tsql batch
> >> >> >> > using
> >> >> >> > quotes, which would have help with the quoted_identifiers ON.
> >> >> >> >
> >> >> >> > Do you have any work around for this problem ?
> >> >> >> >
> >> >> >> > Thank you very much
> >> >> >> >
> >> >> >> > X.M.
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>

"PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in message
news:9A447D69-E621-4131-9A9F-E6F74243CC91@microsoft.com...
>I agree, i would not have changed the quotation mark manually. I am too
>lazy
> for this. And there should be a hundrer servers in the same
> case....definitely too much for me.
> But i am not sure my company will buy MOM, so i will probably write this
> quotation mark eraser (using dts i guess).
>
> Could this problem be assisgned to a bug, or referenced in the knowledge
> base, since all French dba will have the same problem) ? I spent a few a
> hours on this...that could help other people to be aware faster than i
> have
> been.
>
> Thanks a lot
>
> Xavier Marcatel
>
>
>
>
>
> "Andrew J. Kelly" wrote:
>
>> Well I was talking about writing something that would programmatically do
>> the search and replace and the inserts not manually.  But yes MOM can
>> collect Perfmon data and is designed to work across an enterprise so that
>> should not be a problem. I have no idea on the price though.
>>
>> --
>> Andrew J. Kelly    SQL MVP
>> Solid Quality Mentors
>>
>>
>> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
>> message
>> news:6DF209C3-3BF1-408B-BC49-87EFD30E1130@microsoft.com...
>> > Thanks for you reply
>> >
>> > but this doesn't seems to me a good solution : there will be hundreds
>> > of
>> > lines in the files, and a lot of servers to manage in a very near
>> > future.
>> > This solution would be just working temporarily (a few servers), but
>> > not
>> > on
>> > a larger scale.
>> > Do you know if MOM would allow to get all these perfomance counters for
>> > a
>> > hundred servers ?
>> > What price would it be ?
>> >
>> > Thanks for your help.
>> >
>> > XM
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> Well the only other thing I can think of is to log to a character
>> >> format
>> >> (CSV etc.) and edit the file by replacing those offending quotes with
>> >> something else before importing with Relog to the table.
>> >>
>> >> --
>> >> Andrew J. Kelly    SQL MVP
>> >> Solid Quality Mentors
>> >>
>> >>
>> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote in
>> >> message
>> >> news:FFE6B1F0-33A8-4C3C-984F-434FCA1ED14F@microsoft.com...
>> >> > Andrew,
>> >> >
>> >> > I tried csv, tsv, blg and circular blg...it doesn't make any
>> >> > difference.
>> >> > Still the ' error.
>> >> >
>> >> > Any other possibilities ?
>> >> >
>> >> > Xavier
>> >> >
>> >> > "Andrew J. Kelly" wrote:
>> >> >
>> >> >> What type of file are you using to log to, Binary?  All I can think
>> >> >> of
>> >> >> is
>> >> >> to
>> >> >> try different file types to see if there is one that works better
>> >> >> with
>> >> >> ODBC.
>> >> >>
>> >> >> --
>> >> >> Andrew J. Kelly    SQL MVP
>> >> >> Solid Quality Mentors
>> >> >>
>> >> >>
>> >> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com> wrote
>> >> >> in
>> >> >> message
>> >> >> news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@microsoft.com...
>> >> >> > Andrew,
>> >> >> >
>> >> >> > thank you for this answer.
>> >> >> > Yes, I log striaght into SQL Server from Perfmon.
>> >> >> >
>> >> >> > Following your advice, I used relog, but unfortunately, the same
>> >> >> > problem
>> >> >> > occurs when it tries to insert the CounterDetail line with the
>> >> >> > containing
>> >> >> > the
>> >> >> > quote mark.
>> >> >> > Same problem as with the Performance Monitor. Same ODBC Problem I
>> >> >> > guess
>> >> >> > regarding quotation mark and quoted identifiers.
>> >> >> >
>> >> >> > You will find below the SQL Batch and the error caught in the SQL
>> >> >> > Profiler
>> >> >> >
>> >> >> > Any other workaround ?
>> >> >> >
>> >> >> > Xavier
>> >> >> >
>> >> >> >
>> >> >> > SQL Error
>> >> >> > Exception : Error: 105, Severity: 15, State: 1
>> >> >> > USer Error Message : Ouvrez les guillemets après la chaîne de
>> >> >> > caractères
>> >> >> > ',NULL,NULL,NULL,10000000,0) Select @@Identity commit transaction
>> >> >> > AddCounterDetails'.
>> >> >> > SQL Batch
>> >> >> > begin transaction AddCounterDetails insert into CounterDetails
>> >> >> > values
>> >> >> > ('\\MyServer','Disque physique','Long. moy. de file d'attente du
>> >> >> > disque',5571840,2,'1 M:',NULL,NULL,NULL,10000000,0) Select
>> >> >> > @@Identity
>> >> >> > commit
>> >> >> > transaction AddCounterDetails
>> >> >> >
>> >> >> > "Andrew J. Kelly" wrote:
>> >> >> >
>> >> >> >> Are you logging directly from Perfmon to SQL Server? If so try
>> >> >> >> logging
>> >> >> >> to
>> >> >> >> a
>> >> >> >> file first and then using Relog to load to a table. I am not
>> >> >> >> sure
>> >> >> >> if
>> >> >> >> this
>> >> >> >> will matter or not since they both use ODBC but there may be a
>> >> >> >> slight
>> >> >> >> difference in the way Relog works over Perfmon when connecting.
>> >> >> >>
>> >> >> >> relog C:\Perflogs\YourTraceLogFile.blg -f SQL -o
>> >> >> >> SQL:YourDSN!YourDescriptor
>> >> >> >>
>> >> >> >> Type relog.exe /? for details on the commands.
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Andrew J. Kelly    SQL MVP
>> >> >> >> Solid Quality Mentors
>> >> >> >>
>> >> >> >>
>> >> >> >> "PetitGosaimass" <PetitGosaim***@discussions.microsoft.com>
>> >> >> >> wrote
>> >> >> >> in
>> >> >> >> message
>> >> >> >> news:A61547C7-2655-4B44-99B1-F44C102A3380@microsoft.com...
>> >> >> >> > Hello,
>> >> >> >> >
>> >> >> >> > i am trying to to store some performance monitor counters into
>> >> >> >> > a
>> >> >> >> > SQl
>> >> >> >> > Server
>> >> >> >> > Database (SQL 2005 Std, on a W2K3 cluster environment).
>> >> >> >> >
>> >> >> >> > It seems to be working, using an ODBC Datasource with the
>> >> >> >> > SQLServer
>> >> >> >> > driver
>> >> >> >> > (th native client is not compatible with an odbc feature
>> >> >> >> > according
>> >> >> >> > to a
>> >> >> >> > message in the event viewer).
>> >> >> >> >
>> >> >> >> > But, it cannot return on Physical Disk Queue Length. And the
>> >> >> >> > reason
>> >> >> >> > seams
>> >> >> >> > quite simple : my server is French...thus there is a quote in
>> >> >> >> > "Longueur
>> >> >> >> > de
>> >> >> >> > file d'attente", which produces this error. Same problem with
>> >> >> >> > any
>> >> >> >> > other
>> >> >> >> > counter that includes a quote ' in its name.
>> >> >> >> >
>> >> >> >> > And it doesn't seem that the performznce monitor sends tsql
>> >> >> >> > batch
>> >> >> >> > using
>> >> >> >> > quotes, which would have help with the quoted_identifiers ON.
>> >> >> >> >
>> >> >> >> > Do you have any work around for this problem ?
>> >> >> >> >
>> >> >> >> > Thank you very much
>> >> >> >> >
>> >> >> >> > X.M.
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>