Forum Discussion

MulgraveTester's avatar
MulgraveTester
Frequent Contributor
8 years ago
Solved

Get SQL memory usage

Hi, I have been using code to get the memory and CPU usage of processes for some time.   VBScript       set objMyProcess= Sys.WaitProcess("My Process Name",0)       log.message ("CPU usage = " & ...
  • HKosova's avatar
    HKosova
    8 years ago
    MulgraveTester wrote:

     

     

    Now I want to be able to get the same for SQL but SQL does not appear in the Object Browser. It appears in the Task Manager under Background Processes. I believe the reason why SQL does not appear in the Object Browser is because it is actually a service (not a process).

     

    If it's in Task Manager, it's in Object Browser too. Make sure the buttons to show the system processes are pressed. If the SQL Server is running as admin, make sure to run TestComplete as admin as well.

     

MulgraveTester's avatar
MulgraveTester
Frequent Contributor

Thanks HKosova, That was it. I had to run TestComplete as administrator to be able to see the process "sqlsevr" in the object browser.

MulgraveTester's avatar
MulgraveTester
Frequent Contributor
8 years ago

I found a way to get the SQL memory usage without having to run TC as an administrator.

 

VBScript:

 

function getProcessMB(processName)
'Returns the number of MB the specified process is consuming in memory
'Processname: String : e.g. "SQLServr.exe"
'This method is required instead of TestComplete's built in process.memUsage because TC would have to run as an administrator
  getProcessMB = 0
  Set objWMI = GetObject("winmgmts:{impersonationLevel=impersonate}!\\localhost\root\cimv2")
  Set objProc = objWMI.ExecQuery("SELECT * FROM Win32_Process WHERE name=""" & processName & """")
  For Each Process In objProc 
   getProcessMB = formatnumber(Process.WorkingSetSize / 1024 / 1024, 0)
  Next
end function