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

HKosova - it's possible it could be embedded in a SVCHost process. Which can make it hard to spot. Not sure if the TC Object Browser can show you that?

 

MulgraveTester - in task manager, if you right click on the service, it should give you an option to go to the associated process. (The option will be greyed out if the service is not running) That should tell you if it's a SVCHost process or it's own one. If it is a SVCHost one, I don't know if they always get assigned the same one. If they don't, you'd need to get the PID and use that as there are often multiple SVCHost processes running.

HKosova's avatar
HKosova
SmartBear Alumni (Retired)
8 years ago

Colin_McCrae, SQL Server has its own process. You can add the "Process name" column in the Task Manager to see the process names. Services that live in svchost are labelled "Service Host: <something>".

  • Colin_McCrae's avatar
    Colin_McCrae
    Community Hero
    8 years ago

    Yeah. That's certainly how it shows up for me. It's a separate and distinct process.

     

    Wasn't so sure if it was embedded in a host file so that's handy info. (Although, getting the PID would achieve the same result :) )