Script required

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply