Re: PerfMon recording to SQL 2005

I would always use a file rather than a database to avoid it being a
bottleneck, in the same way I would use profiler!

I have logged perfmon counters at pretty high frequency (e.g. every two
seconds or even every ne second) from a busy server to a database on another
server, and that has worked out well so far.

Linchi

"John Bell" wrote:

I would always use a file rather than a database to avoid it being a
bottleneck, in the same way I would use profiler!

This is what I have configured.
A System DSN, specifying windows authentication, and change to an existing
database when logged on.
Login an database tested through DSN and QA.
Perfmon counter created and uses log file to make sure it worked!
On the general tab, the user is set to Administrator for the local
administrator (.\Administrator also works!) and the password has been set.
On the Perfmon counter Log Files tab, SQL Database has been set, End File
names is un-checked.
Configuring the log file, choose the tested DSN as the System DSN

HTH

John

"Tony" <tsheehan@xxxxxxxxxxxxxxxx> wrote in message
news:%23N0IZLL4JHA.1380@xxxxxxxxxxxxxxxxxxxxxxx
Hi John,

I tried it on two servers, one was the SQL box and the other was one that
isn't currently used for anything. They are both Windows 2003 and I am
running a Windows 2003 domain. I've done this before at another location
but that was about 3 years ago so I am familiar with setting up the
counters and assigned them to be recorded via a DSN I created to the
database on SQL. The user account I created in SQL is an owner of the
database so writing to it shouldn't be an issue.

From what I can tell the problem has to do with the log in credentials,
which is evident from the error message. Maybe I need to call Microsoft?

Thanks,
Tony

"John Bell" <jbellnewsposts@xxxxxxxxxxx> wrote in message
news:647611AA-4681-40A9-AAC6-8D04B84F6656@xxxxxxxxxxxxxxxx
Hi Tony

Can you go through the steps you have used to create this? Have you made
this work on a different server?

John

"Tony" <tsheehan@xxxxxxxxxxxxxxxx> wrote in message
news:Oyqv6uH4JHA.1712@xxxxxxxxxxxxxxxxxxxxxxx
Hi John,

Unfortunately I don't have support but I can call if I can't figure it
out soon.

Here are the answers to your questions:
1. I am logged in with a domain account - mine, I'll try logging in
with the domain admin account.
2. Yes
3. No, I'd rather save this as a last resort.

Thanks,
Tony

"John Bell" <jbellnewsposts@xxxxxxxxxxx> wrote in message
news:OIYnZZH4JHA.4872@xxxxxxxxxxxxxxxxxxxxxxx

"Tony" <tsheehan@xxxxxxxxxxxxxxxx> wrote in message
news:OdCZtLH4JHA.1424@xxxxxxxxxxxxxxxxxxxxxxx
I continue to receive error 2059, which states "Invalid username or
password for the {Counter's name} log session. This session will not
be started."

I know the username and password are correct because I'm using the
Administrator account for it to "Run As;" if I use my personal account
I receive three additional errors that basically tell me they don't
know what the errors are.

I've added mine and the administrator's accounts to the "Performance
Log Users" group on the local computer, in Active Directory, and to
the local group on my SQL 2005 box.

I've look all across the Internet and cannot find the answer to this
problem.

Can anyone help me figure this out?

Thank you,
Tony Sheehan

Hi

This seems to be a rare error!!! It could be a case for PSS if you have
support. It does seem to be an authentication issue!!

Are you logged in with a domain or local account?
Have you tried domain admins as well as local admins?
Have you tired removing the machine from the domain and re-adding it?

John







.

Relevant Pages

  • Re: PerfMon recording to SQL 2005
    ... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: PerfMon recording to SQL 2005
    ... I would always use a file rather than a database to avoid it being a bottleneck, in the same way I would use profiler! ... Configuring the log file, choose the tested DSN as the System DSN ... I tried it on two servers, one was the SQL box and the other was one that isn't currently used for anything. ... The user account I created in SQL is an owner of the database so writing to it shouldn't be an issue. ...
    (microsoft.public.sqlserver.server)
  • Re: PerfMon recording to SQL 2005
    ... I log the perfmon stats to a database table for exactly the smae reason -- ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to parse file into db-type layout?
    ... That's an awful lot of columns to put into a database table, ... The rows are identified by Letter type and an account number (always the ... Off to search for dictionaries and databases now. ... > What you need is a clear appreciation of what you are trying to do ...
    (comp.lang.python)
Loading