SQL Server 7.0 Memory

• x04user

  SSC Veteran

  Points: 220

  More actions

  February 12, 2008 at 9:11 am

  #186747

  What tools or type of profiling can I use within SQL server to monitor the memory used daily specifically by SQL server 7.0? I am looking to get an overview of how much memory SQL server is using on a daily basis. I am unable to use Windows performance monitor.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736254

  More actions

  February 12, 2008 at 10:13 am

  #777426

  Why can you not use Performance Monitor? Those same counters are what SQL Server would report.

  You can try sysperfinfo. not sure if that existed in SQL 7.