Browse by Tags

• benchmarking
• best practice
• best practices
• blogs
• dbcc
• disk space
• diskkeeper
• file
• fragmentation
• index
• memory
• monitoring
• object
• performance
• read
• security
• showcontig
• sql server
• table
• writes

Handle Disk Fragmentation issues with effective methods within SQL Server enviornment
08 June 09 02:11 PM | SQL Master | 1 Comments   

When you talk about Performance problems then fragmentation & database integrity issues are dearest friends of DBA! As data is modified in the databases, the tables and indexes will become fragmented, which means the data is scattered everywhere in Read More...

Filed under: sql server, security, memory, read, fragmentation, defrag, disk space, benchmarking, best practices, writes

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?
26 March 08 01:01 AM | SQL Master | 5 Comments   

Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best Read More...

Filed under: performance, sql server, dbcc, object, best practice, defrag, showcontig, blogs, disk space, monitoring, diskkeeper, file

Rebuild some fragmented indexes - problem with Extent Scan Fragmentation value
24 August 07 04:24 AM | SQL Master | 2 Comments   

This was the question from SSP forums, I’m trying to rebuild few fragmented indexes on a table that is updated on regular basis. The “dbcc showcontig” gave this result: Table: 'Confidential' (999999999); index ID: 5, database ID: 5 LEAF level scan performed. Read More...

Filed under: performance, sql server, security, table, dbcc, fragmentation, index, defrag, showcontig