Perfmon Create New Data Collector Set Grayed Out (FIX)

Recently I wanted to create a new data collector in Windows Performance Monitor (perfmon) and the option to hit “Next” was grayed out (see screenshot below)

Perfmon Greyed Out

I checked Services and noticed the Task Scheduler service was disabled and the option to change it to start was grayed out. Next, I went into the Windows Registry (regedit.exe) and navigated to; HKEY_LOCAL_MACHINE –> SYSTEM –> CurrentControlSet –> servives –> Schedule

…and noticed the Start parameter was set to a value of 4 (see screenshot below).

task-scheduler-4

 

I changed it to a value of 2 (see screenshot below)…

Task Scheduler 2

…restarted the server and launched Windows Perfmon. Lo and behold, the “Next” button was not grayed out and I could create a new data collector set! (see screenshot below). By the way, I am running Windows Server 2008 R2 Enterprise and I had to restart my server in order for the regedit modification to take effect.

Perfmon NOT Greyed Out

2 Replies to “Perfmon Create New Data Collector Set Grayed Out (FIX)”

  1. Hello,
    Users are experiencing more then occasional Slow downs. I have a Win 2008R2 64bit standard OS with 32Gigs mem installed. trying to use perfmon to determine the problem. There are no critical events in event viewer. Memory seems to be in high usage by SQL server but that seems to be normal from everything I read as SQL serve will try to reserve as much memory as it can. How do I determine if I am truly maxing out memory and need to move to an OS with more memory capacity as 2008R2 standard is limited to 32Gigs? Thanks in advance for your assistance.

    1. Hey Bill,
      Thanks for your comment/question. There can be multiple factors as to why there are occasional slow downs.

      You won’t necessarily see “critical events” because of SQL Server being slow. Have you set the max memory setting in SQL Server? If not, then it’ll use all the RAM and bring the OS to a possible halt. There are formulas out there on what to set as your max memory setting in SQL Server based on how much RAM the machine has. Since you have 32 GB, I’d try setting the max memory to 32 – 4 = 28 GB. Allow 4 GB for the OS. Also, are there other services running on the machine (i.e. IIS, Exchange, etc.?) Ideally, there shouldn’t be.

      I would check out Pluralsight courses by SQLSkills. There is a specific one by Paul Randal called, “SQL Server: Performance Troubleshooting Using Wait Statistics” I highly recommend watching it if you haven’t already.

      On a side note: I would upgrade to Win Server 2012 R2. The Standard Edition can go up to 4 TB.

      Hope all this helps!
      Mohammad

Leave a Reply

Your email address will not be published. Required fields are marked *