<div>
<div class="content wysiwyg-content">
I ran a trace on one of our webserver-facing SQL Servers, and counted the &quot;RPC:Completed&quot;* events. &nbsp;I got an average of 287.5 RPC's/second (290 when I include RPC events not from the web apps). &nbsp;However, during that same period, I was running a Perfmon log which showed an average of 147.9 BatchRequests/Sec - a ratio of 1.94 of the RPC events to every 1 of the &quot;RPC:Completed&quot; events.<br />
<br />
Does anyone know what can account for this difference? &nbsp;If the RPC's getting &quot;rolled up&quot; into batches somehow, what logic determines how they're being batched?<br />

</div>
</div>


I ran a trace on one of our webserver-facing SQL Servers, and counted the "RPC:Completed"* events.  I got an average of 287.5 RPC's/second (290 when I include RPC events not from the web apps).  However, during that same period, I was running a Perfmon log which showed an average of 147.9 BatchRequests/Sec - a ratio of 1.94 of the RPC events to every 1 of the "RPC:Completed" events.

Does anyone know what can account for this difference?  If the RPC's getting "rolled up" into batches somehow, what logic determines how they're being batched?


Perfmon vs Profiler

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).