<cffunction name="getSQLMonitor" output="no" returntype="any" description="reports information about how busy SQL Server has been">
<cfset var getSQLMonitor = StructNew()>
<!---
dataset1:
last_run - Time sp_monitor was last run.
current_run - Time sp_monitor is being run.
seconds - Number of elapsed seconds since sp_monitor was run.
dataset2:
cpu_busy - Number of seconds that the server computer's CPU has been doing SQL Server work.
io_busy - Number of seconds that SQL Server has spent doing input and output operations.
idle - Number of seconds that SQL Server has been idle.
dataset3:
packets_received - Number of input packets read by SQL Server.
packets_sent - Number of output packets written by SQL Server.
packet_errors - Number of errors encountered by SQL Server while reading and writing packets.
dataset4:
total_read - Number of reads by SQL Server.
total_write - Number of writes by SQL Server.
total_errors - Number of errors encountered by SQL Server while reading and writing.
connections - Number of logins or attempted logins to SQL Server.
--->
<cfstoredproc datasource="yourdsn" username="youruserName" password="yourpasswd" procedure="sp_monitor">
<cfprocresult name="getSQLMonitor.RS1" resultset="1">
<cfprocresult name="getSQLMonitor.RS2" resultset="2">
<cfprocresult name="getSQLMonitor.RS3" resultset="3">
<cfprocresult name="getSQLMonitor.RS4" resultset="4">
</cfstoredproc>
<cfreturn getSQLMonitor>
</cffunction>
Example of usage:
<cfdump var="#getSQLMonitor()#">
Note that you will need special permissions to run this script.