Questions tagged [fragmentation]

An unefficient usage of disk storage in memory or hard drive.

189 questions
1
vote
1 answer

Programmatically determine a file's fragmentation status

Is it possible to determine a specific file's fragmentation status (that is, the amount of distinct fragments this file occupies)? If so, how can this be done using .net? The motivation is this: my application is keeping data in a FileStream,…
M.A. Hanin
  • 8,044
  • 33
  • 51
1
vote
3 answers

Easy way to create fragmented IPv4 packets

I'm working on a network stack at the moment, and I'm trying to implement IPv4 fragmentation. Whilst I have an implementation which works in theory, I would like to actually test that it works by throwing actual fragmented packets at it. Is there…
Matthew Iselin
  • 10,400
  • 4
  • 51
  • 62
1
vote
4 answers

SQL Server 2005 Index Fragmentation

Several keys in a SQL Server 2005 database I inherited have very high fragmentation percentages. When using the following SQL: select OBJECT_NAME(object_id), avg_fragmentation_in_percent, record_count, * from sys.dm_db_index_physical_stats…
Blather
  • 1,118
  • 5
  • 15
  • 25
1
vote
3 answers

Sql server 2005 needs daily index defrag

Our production database needs daily index defragmentation on one of its tables. The table has several indexes and one of them will get to 90% fragmentation each day. The index is on two date fields ( a start time and an end time). We do not get this…
Matt
  • 91
  • 1
  • 8
1
vote
1 answer

How to use DPI scaling factor (float) to set margins (int)

My Android app looks great at 480x800 pixels resolution but it breaks at LDPI screen with 240x400 pixels. I know I can get scaling factor of screen in activity using getResources().getDisplayMetrics().density which would give the exact float value…
Kushal
  • 3,112
  • 10
  • 50
  • 79
1
vote
1 answer

TSQL Index fragmentation query returning confusing data

I have a very simple, standard query to show me the fragmentation of indexes within a database, as follows: SELECT DB_NAME(DB_ID()) AS DatabaseName, OBJECT_NAME(ddips.[object_id]) AS TableName, ind.[name] AS IndexName, …
Skkra
  • 121
  • 2
  • 5
0
votes
0 answers

Does iPhone optimize calls to c++ new?

When you use c++ new for an iPhone app does it optimize the call at all to minimize fragmentation(without implementing any manual memory management)? For example I've heard that iPhone supports a special type of virtual memory.
Ryan
  • 5,883
  • 13
  • 56
  • 93
0
votes
1 answer

Can MongoDB have fragmentation?

I have heard that if the goal is to modify a data in SQL, deleting and re-saving it is not a good idea because it can lead to fragmentation issues. Does this also happen in MongoDB? If so, how should I edit the information inside a…
asd asd
  • 96
  • 8
0
votes
0 answers

Does memcached send packets that fragment on IP layer using UDP and not TCP?

question is in title. I have read that memcached fragments only on application layer for large responses. Is this always the case? If TCP is not used e.g. client -> a.b.c.d:UDP/11211 ; a.b.c.d:UDP/11211 -> client, how can the memcached server know…
the_dude
  • 11
  • 2
0
votes
0 answers

Fragmentation-Does Anyone know what the alignment of _alloca() is?

So I'm using Windows 10/ 32-bit OS and the compiler is Visual Studio 2022 This is the Code: (note this code is meant only for learning) #include #include int main() { int64_t p = (int64_t)_alloca(16); int64_t o =…
Coffee
  • 13
  • 3
0
votes
2 answers

Rebuild or Reorganize indexes

I want to reorganize or rebuild indexes. I know the sql to perform this action on all indexes in a table is alter index all on table_name reorganize; But I only want to rebuild or reorganize if fragmentation percentage on each index is between a…
user17329786
0
votes
1 answer

Many open files leading to uninterruptible sleep "D state"

I created a ~3TB binary file (located on an AWS EBS volume) intended to store an MxN matrix of doubles representing uniform financial time series across multiple days. There are M=37932 different time series, each of which has N=10415118 elements. I…
galpo
  • 183
  • 1
  • 7
0
votes
1 answer

How does Network layer knows if it has to fragment the packet

I got basic question. Trying to understand the mechanism how network layer identify when it receive packet larger than its interface MTU configured and has to fragment it. For example. If the data to be transmitted by application is 2000byte where…
Shekhar
  • 3
  • 1
0
votes
1 answer

Frequent, highly fragmented index on heap table

I have a table (a heap table) with a nonclustered index that frequently becomes highly fragmented. The data in column ID comes from (is imported from) data from a csv file and the ID is thereafter used in other table relations for reporting…
0
votes
1 answer

Defragmenting File Programatically On Windows

I am attempting to follow this tutorial: Defragmenting Files. I call DeviceIoControl() with FSCTL_GET_VOLUME_BITMAP on a handle to the C: volume, and I get a proper response. I then open a handle to another file (I tried files from 10KB to a few MB)…
Carol Victor
  • 331
  • 1
  • 7