Memory Usage

• Imke Cronje

  SSCarpal Tunnel

  Points: 4826

  More actions

  March 11, 2008 at 2:32 am

  #187841

  Hi there,

  How do u check how much memory is being used when a user accesses a database? sp_who2 does not give u the memory usage.

  Is this a sysdadmin or dba function.

  Regards

  IC

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  March 12, 2008 at 10:18 am

  #788678

  How about

  SELECT * FROM master..sysprocesses

  ?