Re: Performance Monitor / Database Storage using ODBC

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" <PetitGosaimass@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FFE6B1F0-33A8-4C3C-984F-434FCA1ED14F@xxxxxxxxxxxxxxxx
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" <PetitGosaimass@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:09E525D3-CE54-45EE-9A05-25EF284F7D7D@xxxxxxxxxxxxxxxx
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" <PetitGosaimass@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:A61547C7-2655-4B44-99B1-F44C102A3380@xxxxxxxxxxxxxxxx
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.







.

Relevant Pages