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 18, 2010 at 11:21 am

    #1252665

    @Gila

    Wait type is pagelatch_up and wait resource is 5:1:3

    5 is my database id 1 is the file group and 3 is the page id

    when you see in sys.dm_os_buffer_descriptors it says SGAM Page and there are lot of waits

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]