Questions tagged [defragmentation]

The process of decreasing the amount of fragmented files on a computer's system hard drive.

76 questions
0
votes
0 answers

Shrink Disk and NTFS MetaFile Defragmentation ($BITMAP)

Shrink Disk and Defragmentation I'm trying to shrink a disk. The volume is about 1 To large, and only 200 Go are curretly used. It is a virtual disk. When i ask to the disk management tool to shrink my disk, it lets me shrink only 73 Go and says…
Marc
  • 1
0
votes
1 answer

etcd 3.5 db_size growing constantly

I have 3-node etcd cluster version 3.5.2. I noticed a sitituation that endpoint's db_size is constantly growing. I have to perform compaction and defrag manually so that the db_size value cannot reach to limitation. I have not faced any similar…
0
votes
1 answer

Memory pool: force allocating resources (map / vector) to reallocate for continuity

I have a memory pool of fixed size. A custom allocator is used to put std::vector and std::unordered_map elements into that pool. Over time the memory pool gets fragmented and even though there might be enough memory available if you scrap all the…
glades
  • 3,778
  • 1
  • 12
  • 34
0
votes
0 answers

PowerShell Script looping using results stored in variable

I'm creating a PowerShell script (will post the script at the end) with the goal of automating the optimization process of multiple vhdx files in a directory. To sum up the script I currently have it prompting the user for the directory location of…
0
votes
1 answer

File System Filter Driver: Creating a Defragmenter

I've just started working on a file system filter driver that monitors for I/O writes to any file (listening for IRP_MJ_WRITE requests), and defragments the file transparently if it becomes fragmented. Currently, I have code like this: NTSTATUS…
user541686
  • 205,094
  • 128
  • 528
  • 886
0
votes
1 answer

MS-SQL: Space overhead for rebuild vs. recreate

we need to remove old data from a huge table once a year. The rows of the table are rather compact (around 40 bytes) and there is just a clustered index on the table. The database is about 750 GB in total, and the table worked on is 640 GB in size…
Ralf
  • 538
  • 1
  • 6
  • 17
0
votes
0 answers

Receiving errors with Ola's defrag script

When using EXECUTES to rebuild and exclude indexes from the defrag SP, I receive the following errors: Msg 50000, Level 16, State 1, Procedure IndexOptimize, Line 918 The value for the parameter @Indexes is not supported. Msg 50000, Level 16, State…
D. Spigle
  • 541
  • 2
  • 5
  • 15
0
votes
0 answers

Is rebuilding of database indexes reflected in the .bak file?

I have used the following query in my local computer to rebuild an INDEX on a table of database. After that I have created a .bak file to move the database to the server. I am not sure if rebuilding an INDEX is reflected into the .bak file or it is…
Ali Sheikhpour
  • 10,475
  • 5
  • 41
  • 82
0
votes
1 answer

(SQL Server) How to defragment indexes with LOBs?

In SQL Server, are there some points on defragmenting indexes with LOBs? Such as text, ntext, image, varchar(max), nvarchar(max), varbinary(max), xml. Thanks.
Just a learner
  • 26,690
  • 50
  • 155
  • 234
0
votes
1 answer

Clustered Columnstore Index Fragmentation - Index Properties and dm_db_column_store_row_group_physical_stats differences

We are using Clustered Column store Indexes in multiple tables. To determine Fragmentation, When I use sys.dm_db_column_store_row_group_physical_stats I see 0% fragmentation, When I query sys.dm_db_index_physical_stats I see 90.10% fragmentation…
0
votes
3 answers

Disk Defrag and Disk Clean up using Python Script

Can you help me on how to make this script work. For Defrag import os; defragmentation=os.popen('defrag.exe /C').read() print(defragmentation); For Disk Clean up import os; clean=os.popen('cleanmgr.exe /sagerun:1').read() print(clean); Upon trying…
Aouie
  • 119
  • 2
  • 8
  • 17
0
votes
1 answer

Defragment Memory Blocks in C Memory Pool

I've built a simple memory pool in C and I've also implemented the ability to implement memory blocks in this pool. The memory blocks themselves are quite simple, just a doubly linked list with a free flag and size property. What I'm trying to do…
Liam Potter
  • 1,732
  • 8
  • 24
  • 47
0
votes
0 answers

Run progress bar along with Disk Defragmentation in WPF

I am developing a exe for hard disk defragmentation. For this I am using StartDefragmentation(String DeviceName) method of IDefragmenter Interface for defragmentation of hard disk particular drive. It works properly, but I have to also run progress…
Khatri
  • 11
  • 4
0
votes
1 answer

Index Defragmentation in SQL Server 2012

I'm running different scripts from SQLFOOL & SQL Authorities an etc. but when I check the database I cannot see any defragmentation at all. I wrote a bit code which is not working, could you please give me a hand? Declare @table_name Varchar…
0
votes
1 answer

Windows. Create new file at specific logical cluster

The relevant Microsoft doc is: https://msdn.microsoft.com/en-us/library/aa363911.aspx But it describe how to move existing fragmented file to new continuous logical blocks. I want to create new file without fragmentation. At first i get free…
Andy
  • 1