Script required

• SQL Galaxy

  One Orange Chip

  Points: 29478

  More actions

  October 20, 2010 at 2:42 am

  #239991

  Hi,

  Alerady I cofigured database mail with SMTP mail server.

  Script require for automating alert an internal SQL database.(2005 version),

  1. Exten scan fragmentation ( range between 25-50%)

  2. Logical scan fragmentation (range > 25%)

  please provide me these script for proactive alert purpose, and how to configured in Alert?

  Thanks

  ananda

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  Follow

  October 20, 2010 at 2:47 am

  #1239524

  Query sys.dm_db_index_physical_stats.

  The column avg_fragmentation_in_percent is logical fragmentation if the row in question is for a clustered or nonclustered index, or extent fragmentation if the object in question is a heap.

  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