0

Why are SSIS performance counters: Buffer memory, Buffers in use, Buffers spooled returning 0 even though there are SSIS packages on the sql server; agent jobs configured to run these SSIS packages.

I can confirm this by looking at the SSIS execution reports.

Why are SQL SSIS counters zero even though there are packages running on the server?

5
  • Are you looking at those counters while the SSIS package is in the middle of running?
    – J.D.
    May 10 at 12:06
  • Yes I have it configured in perfmon and the period where the packges run shows no counter value, which puzzles me because I understand (correct me please) that ssis packages run where they are installed (irrespective of where they may be called from.)
    – variable
    May 10 at 12:50
  • Is the ssis started from ssis catalog or job agent? If you run the ssis in VS, it runs in the machine with VS installed, not in the sql server.
    – MBuschi
    May 11 at 7:52
  • The packages are all started via the job agent (there is schedules that run the package every 15 minutes).
    – variable
    May 11 at 8:15
  • I add a counter for all processes and I cannot see process named dtexec - but my ssis execution report shows multiple ssis packages getting executed every hour. What am I missing?
    – variable
    May 12 at 12:40

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.