Sql Server Job

• Asan

  Newbie

  Points: 1

  More actions

  November 14, 2005 at 11:20 pm

  #110846

  Hi,

  Im running the job everyday using sql server 2000,sometime memory failure log is coming. So that i want to know how much free space required(in system) for job to run, How can i find out? plz help me out!

   

  Regards,

  Asan

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  November 15, 2005 at 7:39 am

  #603913

  can you please provide more specific information on this problem.            [Error number /complete error message]

  If its Sql 2000  and dynamic memeory settings are in place then there is no question of determining free space for any job to execute.

  Though you can use performance monitor to check Buffer Cache Hit ratio[recommended 99 %] or Memory: Page/Sec

   

  Kindest Regards,

  Sameer Raval [Sql Server DBA]
  Geico Insurance
  RavalSameer@hotmail.com