<div>
Check the performance of VM via VMware Performance report.
</div>


Check the performance of VM via VMware Performance report.

<div>
Looks like the issue has been isolated to SSIS - the ISServerExec.exe is spiking the CPU and memory over 99%. &nbsp;I would like to add more memory, but don't think that will resolve it. &nbsp;Does anyone have any suggestions? &nbsp;I'm thinking a DMV query to isolate the issue further. &nbsp;Any thoughts?
</div>


Looks like the issue has been isolated to SSIS - the ISServerExec.exe is spiking the CPU and memory over 99%.  I would like to add more memory, but don't think that will resolve it.  Does anyone have any suggestions?  I'm thinking a DMV query to isolate the issue further.  Any thoughts?

<div>
I have give you already some thoughts but you &nbsp;seem to ignore them. :)<br />
<br />
The sp_whoisactive procedure already incorporates any DMVs and queries in the system tables to help you find the problem.
</div>


I have give you already some thoughts but you  seem to ignore them. :)

The sp_whoisactive procedure already incorporates any DMVs and queries in the system tables to help you find the problem.

<div>
<div class="content wysiwyg-content">
The server does not allow me to access it via RDP, or via the VMware console. &nbsp;The windows Welcome screen displays. &nbsp;Our monitoring threshold does not reveal/indicate any issue with RAM, CPU, etc., but our support team states that they've seen an SSIS package pegging the CPU at 100%. &nbsp;Is there a perfmon or any other utility native to Windows that we can use for troubleshooting/isolating this issue? &nbsp;Right now it feels as if we are searching for a needle in a hay stack.
</div>
</div>


The server does not allow me to access it via RDP, or via the VMware console.  The windows Welcome screen displays.  Our monitoring threshold does not reveal/indicate any issue with RAM, CPU, etc., but our support team states that they've seen an SSIS package pegging the CPU at 100%.  Is there a perfmon or any other utility native to Windows that we can use for troubleshooting/isolating this issue?  Right now it feels as if we are searching for a needle in a hay stack.

SQL Server Hanging - 2012 Enterprise Edition

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.

SSIS

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.