Home Forums SQL Server 2005 Administering How to make data(.mdf) to equal size slices! RE: How to make data(.mdf) to equal size slices!

  • November 17, 2010 at 10:50 pm

    #1252283

    pavan_srirangam (11/17/2010)

    Yes exactly its a contention on my datafile SGAM pages

    In a user database?

    What's the wait type you're predominantly seeing? What's the wait resource? What has led you to the conclusion that you have contention on the SGAM in your user database?

    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