Forum Discussion

MulgraveTester's avatar
MulgraveTester
Frequent Contributor
8 years ago

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.

     

Colin_McCrae's avatar
Colin_McCrae
Community Hero
8 years ago

You should be able to get the PID back from the Service. Which would allow you to query it's process.

 

https://msdn.microsoft.com/en-us/library/aa394418(v=vs.85).aspx#properties

 

Although, SQL processes should be pretty obvious in task manager? Certainly are on my install. But mine isn't SQL Express, which may be different. Never used it. But certainly sqlsrvr (SQL Server) is an obvious process for me. Along with it's gigantic memory footprint! Guess Express must be embedded in a SVCHost process?

 

And if you want to use a Win32_Service object to query it, here's some info on that: http://www.computerperformance.co.uk/vbscript/wmi_services.htm

 

I use the above to check, start and stop services during runs. But you need to get from the service to it's process in order to get memory footprint info as far as I can see. The PID should do that. I think. :)

  • MulgraveTester's avatar
    MulgraveTester
    Frequent Contributor
    8 years ago

    Thanks for all your help on this Colin. The screenshot that I attached showed the process in the Task Manager. I wasn't able to see it in the TestComplete Object Browser because I wasn't running TestComplete as an administrator. Once I did that I was able to get the process and its memory usage as before.

     

    Thanks.