Page 4 of 8 FirstFirst ... 234567 ... LastLast
Results 31 to 40 of 75
Like Tree2Likes

mga MSSQL admin please share your ideas and knowledge


This discussion is about "mga MSSQL admin please share your ideas and knowledge" in the "Programming" forums.
bai @ rjbhern , unsai mahatag nimo nga advice regarding pag reorganize or rebuild sa fragmented indexes?...

  1. #31
    Junior Member nyor's Avatar
    Join Date
    Jul 2011
    Gender
    Male
    Posts
    443

    bai @rjbhern, unsai mahatag nimo nga advice regarding pag reorganize or rebuild sa fragmented indexes?

  2. #32
    Junior Member rjbhern's Avatar
    Join Date
    Jun 2012
    Gender
    Male
    Posts
    162
    Quote Originally Posted by nyor View Post
    bai @rjbhern, unsai mahatag nimo nga advice regarding pag reorganize or rebuild sa fragmented indexes?
    wa kaayo ko mahatag ana nga idea bai... c sir @defender rajud atong pag.asa ana... by the way bai, katong g.tudlo nga audit ... working rato nimo?

  3. #33
    Junior Member nyor's Avatar
    Join Date
    Jul 2011
    Gender
    Male
    Posts
    443
    Quote Originally Posted by rjbhern View Post
    wa kaayo ko mahatag ana nga idea bai... c sir @defender rajud atong pag.asa ana... by the way bai, katong g.tudlo nga audit ... working rato nimo?

    wala to nako nabuhat bai ky dili available ang kato nga pamaagi sa auditing sa standard edition sa sql, naa ra sa enterprise edition.. nya standard raman among gamit

  4. #34
    Junior Member rjbhern's Avatar
    Join Date
    Jun 2012
    Gender
    Male
    Posts
    162
    Quote Originally Posted by nyor View Post
    wala to nako nabuhat bai ky dili available ang kato nga pamaagi sa auditing sa standard edition sa sql, naa ra sa enterprise edition.. nya standard raman among gamit
    up nato ni bai... asa naman kaha c sir @defender ron sa?

  5. #35
    Junior Member nyor's Avatar
    Join Date
    Jul 2011
    Gender
    Male
    Posts
    443
    Quote Originally Posted by rjbhern View Post
    up nato ni bai... asa naman kaha c sir @defender ron sa?


    mao lagi bai, asa na kaha to.. nya musta man ang mga database server nmo dha bai?

  6. #36
    Junior Member rjbhern's Avatar
    Join Date
    Jun 2012
    Gender
    Male
    Posts
    162
    Quote Originally Posted by nyor View Post
    mao lagi bai, asa na kaha to.. nya musta man ang mga database server nmo dha bai?
    running paman bai... ang ako rang problem kung mo.down ba... manual jud tanan.. nya dako kaayo ug possibilities nga dghang data ang mawala....

  7. #37
    Junior Member nyor's Avatar
    Join Date
    Jul 2011
    Gender
    Male
    Posts
    443
    Quote Originally Posted by rjbhern View Post
    running paman bai... ang ako rang problem kung mo.down ba... manual jud tanan.. nya dako kaayo ug possibilities nga dghang data ang mawala....

    pila ka database imong gi handle bai? nindot inyong set-up da.. unsai mga application running?

  8. #38
    Elite Member defender_1611's Avatar
    Join Date
    Sep 2011
    Gender
    Male
    Posts
    1,543
    mga boss sensya kaayo ninyo kung karon pako ka online...kay busy lang.....kay i was in singapore my boss told me that i will be one of the speakers there....

    from now on i will be giving scripts to help my fellow DB administrator....especially atong mga newbie pa sa DB admin.


    God bless....
    Last edited by defender_1611; 05-29-2015 at 10:32 PM.

  9. #39
    Junior Member nyor's Avatar
    Join Date
    Jul 2011
    Gender
    Male
    Posts
    443
    Quote Originally Posted by defender_1611 View Post
    mga boss sensya kaayo ninyo kung karon pako ka online...kay busy lang.....kay i was in singapore my boss told me that i will be one of the speakers there....

    from now on i will be giving scripts to help my fellow DB administrator....especially atong mga newbie pa sa DB admin.


    God bless....

    nindot na sir.. hehe! regarding sa mga fragmented nga tables, unsai ma advice nimo ana sir? plan unta nko e.reorganize or rebuild pero grabe mn ang growth sa transaction log..

  10. #40
    Elite Member defender_1611's Avatar
    Join Date
    Sep 2011
    Gender
    Male
    Posts
    1,543
    @nyor

    Before learning to eliminate fragmentation, you should have a clear understanding of the types of fragmentation. We can classify fragmentation into two types:

    Internal Fragmentation: When records are stored non-contiguously inside the page, then it is called internal fragmentation. In other words, internal fragmentation is said to occur if there is unused space between records in a page. This fragmentation occurs through the process of data modifications (INSERT, UPDATE, and DELETE statements) that are made against the table and therefore, to the indexes defined on the table. As these modifications are not equally distributed among the rows of the table and indexes, the fullness of each page can vary over time. This unused space causes poor cache utilization and more I/O, which ultimately leads to poor query performance.

    External Fragmentation: When on disk, the physical storage of pages and extents is not contiguous. When the extents of a table are not physically stored contiguously on disk, switching from one extent to another causes higher disk rotations, and this is called Extent Fragmentation.

  11.    Advertisement

Page 4 of 8 FirstFirst ... 234567 ... LastLast

Similar Threads

 
  1. Cebu Aquaponics Hobbyist-Share Your Ideas and Experiences Here.
    By connection2wealth in forum Hobbies & Crafts
    Replies: 743
    Last Post: 04-28-2020, 12:43 PM
  2. need expert.please share your ideas
    By rinizids in forum Computer Hardware
    Replies: 4
    Last Post: 01-08-2015, 01:28 PM
  3. Cebu Aquaponics Hobbyist-Share Your Ideas and Experiences Here.
    By connection2wealth in forum General Discussions
    Replies: 36
    Last Post: 10-05-2011, 12:08 AM
  4. Please share your ideas...
    By bobyray in forum Business, Finance & Economics Discussions
    Replies: 3
    Last Post: 08-10-2011, 10:58 PM
  5. Replies: 17
    Last Post: 03-03-2011, 10:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
about us
We are the first Cebu Online Media.

iSTORYA.NET is Cebu's Biggest, Southern Philippines' Most Active, and the Philippines' Strongest Online Community!
follow us
#top