Despite the fact that COM Components are considered legacy technology now, because Microsoft never made a clear cut decision to retire COM Components in newer versions of their Operating System these Libraries still linger around in many Applications, and have made their way into many .NET based Applications through DLL Referencing. Here is an error I have come across from time to time that doesn’t tell you a whole lot unfortunately:
Retrieving the COM class factory for component with CLSID {XXXXXXXX-XX…} failed due to the following error: 80040154
There are several ways to resolve this issue. Here is a short list:
Modify your project’s platform from ‘Any CPU’ to ‘X86′ in Project Properties, Build/Platform’s Target in Visual Studio
If your Application is a Web-Based Application, try setting IIS to run in 32-bit mode. You can do this by going to IIS Manager, selecting the Application Pool, then choosing “Advanced Settings”. The second option from the top is “Enable 32-bit Applications”.
If your Application is Web-Based, it could be that the com object was not configured to allow launch and access permissions for the aspnet user identity. Under administrative tools > Component services under the tree view, go to Component Services > Computers > My Computer > DCOM Config and find the registered com object. Right click for properties. Under the security tag, customize the Permissions to allow asp.net user
Usually one of the above 3 methods solves this problem

If you want to log you results using the CounterLogs functionality take the following steps
1) Stop the Performance Logs & Alerts service from services.msc
2) Open up the registry editor (regedit.exe), browse down to HKLM\System\CurrentControlSet\Services\Sysmonlog.
3) Change the ImagePath from the default value to %SystemRoot%\syswow64\smlogsvc.exe.( This would launch the 32-bit service on starting the Counter logs)
4) Open the 32-bit Perfmon from Start - Run - %SystemRoot%\syswow64\perfmon.exe, & add the SQL counter objects to a Counter log.
5) Set the various parameters of the Counter log, & start it to collect the data.