How to run Typeperf in SQL Agent job

• webrunner

  SSC-Dedicated

  Points: 32099

  More actions

  May 10, 2016 at 9:11 am

  #326290

  Hello experts,

  I am following the advice at this page, which has a nice writeup on how to store Perfmon stats to a database using Typeperf.exe.

  http://tomaslind.net/2014/10/27/performance-monitor-data-sql-server-tables/%5B/url%5D

  TYPEPERF -cf E:\Traces\Typeperf\Counters.txt -si 10 -sc 60 -f SQL -o SQL:SQLServerDS!log1

  That commands works fine when I use it in a cmd window. But when I tried to make it a job step, the job fails.

  There are 3 entries in the job log:

  Message 1 is blank.

  Message 2 is:

  Exiting, please wait...

  Error:

  Call to SQLAllocConnect failed with __.

  Note:

  In order to use typeperf, you must either be a member of the local

  Performance Log Users group, or the command must be executed from an

  elevated command window.

  Message 3 is:

  Executed as user: Domain\User. The step failed.

  However, when I choose the job step type Operating system (CmdExec), which seems required to run this command, the only choice for Run as: is SQL Server Agent Service Account.

  Does anyone have some info on how I can get this setup to run the job successfully?

  Thanks for any help!

  - webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html