All posts by aboyd

BizTalk360 Analytics Report CPU Graphs Issue

Problem:

I am using BizTalk360 version 8.9.5112.2201 in a BizTalk2016 environment. In setting up reports, I came across an interesting issue.  If you have looked at the CPU usage reports, you may have noticed that the graphs do not match actual performance.

Consider the following SQL Servers Performance graph.

SQL Servers Performance
SQL Servers Performance

You will notice that the left-side legend is displaying 0-100%. I make the assumption that this is Total CPU and the right-side legend is memory usage.

Continue reading BizTalk360 Analytics Report CPU Graphs Issue

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Error:

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'

Continue reading SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Determine DLLs hosted by Process

tasklist /m /fi "IMAGENAME eq wmiprvse.exe"

/M     [module]         Lists all tasks currently using the given
exe/dll name. If the module name is not
specified all loaded modules are displayed.

/FI    filter           Displays a set of tasks that match a
given criteria specified by the filter.

If you want DLL's hosted by any/all processes, remove the /FI filter parameter. In the example, we list dll's in use by the WMIPRVSE services.

Another example might be;

tasklist /m /fi "IMAGENAME eq cmd.exe"

You can filter on many different items, such as PID. Below we list dll's used by the SYSTEM process.

tasklist /m /fi "pid eq 4"