DBCC SHOWCONTIG

• MartinPlant

  Old Hand

  Points: 365

  More actions

  October 15, 2003 at 11:15 am

  #107181

  Hello All

  I am running SAP on SQL2K and need at regular occasions to check the defragmentation on the top 15 largest tables. Is there a script which I can run to check the status of defrag on the tables for all as opposed to individual checking?

• October 20, 2003 at 12:00 pm

  This was removed by the editor as SPAM

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  October 20, 2003 at 1:44 pm

  #478862

  if you are entereing DBCC SHOWCONTIG without any parameter the you will generate the showcontig for ALL tables.

  If you are entering DBCC SHOWCONTIG WITH TABLERESULTS then you will get a tabular result which you can save to a table previsiously created.

  Or to check which are your top n tables you can use my script I've transmitted: sp_toptables

  Very probably your biggest tables are: COEJ, COEP, COSS, GLPCA, GLPCP...

  By the way how big is your database, with how many users?

  We are running SAP on SQL2K as well and ours is over 250GB with over 1300 users.

  I hope I could help

  Bye

  Gabor

  
  
  Bye
  Gabor