dbcc updateusage

• charipg

  SSCrazy Eights

  Points: 9888

  More actions

  September 4, 2009 at 12:21 pm

  #73893

  i want to schedule a job with dbcc updateusage(dbname) then run the dbcc sqlperf (logspace) in the same job.

  how to do this.any suggessions pls...

  thanks.........

• ps.

  One Orange Chip

  Points: 29422

  More actions

  September 5, 2009 at 4:30 am

  #1049714

  whats the problem in creating it?

  for dbcc sqlperf(logspace) you may want to capture the results to a table... use dynamic query for this..

  ---

  
  Pradeep Singh

• ps.

  One Orange Chip

  Points: 29422

  More actions

  September 5, 2009 at 4:40 am

  #1049716

  for the logspace part, the following code will write the results in a table which you can query later.

  create table tblLogSize(dbname varchar(100),

  logsize float,

  used float,

  status int

  )

  go

  ----------------------

  create procedure LogSpace

  as

  dbcc sqlperf(logspace)

  go

  -----------------------

  Create Procedure InsertIntoTable

  as

  truncate table tblLogSize

  insert into tblLogSize exec LogSpace

  go

  -----------------------

  exec InsertIntoTable

  select * from tblLogSize

  ---

  
  Pradeep Singh

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 5, 2009 at 10:19 am

  #1049755

  charipg (9/4/2009)

  ---

  i want to schedule a job with dbcc updateusage(dbname) then run the dbcc sqlperf (logspace) in the same job.

  Why? What's the purpose of UpdateUsage in there?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass