DBCC memorystatus

• John Chiu

  SSCrazy

  Points: 2619

  More actions

  July 27, 2004 at 7:54 am

  #102128

  Can someone help me on how to interpret DBCC memorystatus output correctly. I do read the KB doc(http://support.microsoft.com/default.aspx?scid=kb;en-us;271624&Product=sql2k) but still not clear how to interprete the result correctly. I'm specfic looking for clue of memory problem (leak) that I may can find from the output. 

  What I need to do is stress test an XP extended SP and OLE DB object that were called within SP that doing data encryption. I want to make sure these function won't casue memory problem.

   

  Thanks, 

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  July 27, 2004 at 8:43 am

  #516314

  have a look at http://www.sql-server-performance.com/dbcc_commands.asp

  there should be some good explanations there

  MVDBA