Event ID 113 Report Server Windows Service (MSSQLSERVER)

ALAN WHITE 21 Reputation points
2021-10-31T15:58:46.08+00:00

I'm having some issues with Performance counters on a production server. Originally I was getting Event ID 1001 for IISInfoCtrs, Event ID 2001 for usbperf, and Event ID 2002 for Microsoft-Windows-IIS-W3SVC-PerfCounters. So I ran lodctr /r in the System32 and sysWOW64 folders, stopped and restarted performance monitoring and alerting service, and stopped and restarted WMI service (according to https://learn.microsoft.com/en-us/troubleshoot/windows-server/performance/rebuild-performance-counter-library-values). Now I'm sill getting those errors every hour. And every 12 hours Event ID 113 Report Server Windows Service (MSSQLSERVER)-Report Server cannot create the "XXX" Performance Counter for seemingly every performance counter related to MSSQLSERVER:

Total Cache Flushes
Snapshot Updates/Sec
Total Snapshot Updates
Events/Sec
Total Events
Delivers/Sec
Total Deliveries
Cache Misses/Sec (Semantic Models)
Cache Hits/Sec (Semantic Models)
Total Processing Failures
Memory Cache Miss/Sec
Total Memory Cache Misses
Memory Cache Hits/Sec
Total Memory Cache Hits
Requests/Sec
Total Requests
Cache Misses/Sec
Total Cache Misses
Cache Flushes/Sec
Total Cache Flushes
Snapshot Updates/Sec
Total Snapshot Updates
Events/Sec
Total Events
Delivers/Sec
Total Deliveries
Cache Misses/Sec (Semantic Models)
Cache Hits/Sec (Semantic Models)
Total Processing Failures
Memory Cache Miss/Sec
Total Memory Cache Misses
Memory Cache Hits/Sec
Total Memory Cache Hits
Requests/Sec
Total Requests
Cache Misses/Sec
Total Cache Misses
First Session Requests/Sec
Reports Executed/Sec
Total Reports Executed

How can I clear these errors and get the performance counters going on SQL so I can monitor it?

Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,571 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,439 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,991 Reputation points Microsoft Vendor
    2021-11-01T08:12:07.06+00:00

    Hi awhite-aut,

    Now I'm still getting those errors every hour. And every 12 hours Event ID 113 Report Server Windows Service (MSSQLSERVER)-Report Server cannot create the "XXX" Performance Counter for seemingly every performance counter related to MSSQLSERVER:

    Please try to repair the SSRS performance counters in the command prompt with administrator privileges. “Runs as administrator”:

    C:\Windows\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe "< Report Server Bin directory >\ReportingServicesLibrary.dll"  
    

    By default, Report Server Bin directory is located at C:\Program Files\Microsoft SQL Server\MSRSxx.MSSQLSERVER\Reporting Services\ReportServer\bin in SSRS 2016 or earlier.
    Please check How to Rebuild the Report Server Performance Counters (SSRS) which might be helpful.

    Best Regards,
    Amelia


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1 additional answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,991 Reputation points Microsoft Vendor
    2021-11-02T02:35:40.613+00:00

    Hi awhite-aut,
    Thanks for your reply.
    SQL Server report server 2014 requires .NET Framework version 2.0. So you can also use .NET 2.0 Framework directory.
    And you can try to go to C:\Windows\Microsoft.NET\Framework\v3.5 folder and see if InstallUtil.exe exists.
    Here is a doc about reinstating Reporting Services performance counters:

    145664-image.png

    Best Regards,
    Amelia


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.