Extended Stored Procedure Testing

• dogman

  Old Hand

  Points: 341

  More actions

  April 8, 2004 at 4:20 pm

  #84868

  I've written an extended stored procedure that makes a socket connection and returns data. The procedure works as intended, but how can I really test it to make sure that it's not going to affect the production server? I would like to monitor the memory usage just for that particular DLL or process over a period of time while I'm calling the procedure over and over.

  Any ideas?

  
  :wq

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  April 8, 2004 at 4:40 pm

  #502232

  I'd check out Ken Henderson's book on Extended Stored Procedures.

  http://www.amazon.com/exec/obidos/tg/detail/-/0201700468/qid=1081463879/sr=8-2/ref=pd_ka_2/102-0448774-6156119?v=glance&s=books&n=507846

  or email him. He's done a few of them.