mga MSSQL admin please share your ideas and knowledge

[nyor]

---

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

[rjbhern]

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?

[nyor]

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

[rjbhern]

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?

[nyor]

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?

[rjbhern]

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....

[nyor]

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?

[defender_1611]

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....

[nyor]

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..

[defender_1611]

@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.