All Questions
Tagged with fragmentation sql-server-2008-r2
11 questions
0
votes
1
answer
126
views
Index Fragmentation - log issues
I have a few questions that I want to understand in order to take informed decision. I am not a DBA by profession, I have done some administrative tasks in the past and now I would have to create a ...
- 23
3
votes
1
answer
4k
views
Do we have to run auto update statistics after index rebuild?
I want to rebuild one of my indexes because fragmentation has reached 97 percent.
I want to know if after I rebuild my index, do I have to update the statistics as well? My auto update statistics ...
- 237
1
vote
1
answer
134
views
Considerations for performance comparison with a high fragmented heap?
I am planning to perform some performance comparisons for different structures of one and the same table. The table I want to investigate on is a heap having ~ 1Mio rows and 123 columns.
Setup:
I ...
- 4,827
7
votes
4
answers
3k
views
Manually create index fragmentation
Does anybody have a good approach to manually create a specific fragmentation to an index, ideally without increasing the number of rows in the underlying table?
I need this for the purpose of a ...
- 4,827
8
votes
6
answers
14k
views
Does index rebuild time depend on the fragmentation level?
Is the required time for index rebuild dependent on the level of fragmentation?
Does the rebuild of a 80% fragmented index approximately take 2 minutes if the rebuild of the same index fragmented 40%...
- 4,827
0
votes
1
answer
9k
views
Rebuild Indexes on SQL Server Standard edition
We have SQL Server 2008 R2 Standard on a Windows Server cluster. I want to defrag all indexes on a database.
What is the best approach to disable all connections and allow the rebuild of indexes?
...
- 1,550
5
votes
2
answers
31k
views
Find out when your index was last rebuilt / reorganized
I've recently come across a database, which has very high fragmentation on large tables.
Page count > 1'000'000 with fragmentation 99,...
I would like to know how long this table has gone without a ...
- 2,681
0
votes
3
answers
2k
views
index rebuild/reorganize frequency
I am a dba by accident. I am doing index rebuild/reorganize. I would love to use some scripts once I become comfortable doing these tasks. I did go through some of the forum pages regarding this ...
- 163
5
votes
1
answer
3k
views
Disadvantages of reorganizing all tables nightly
I consider scheduling a SQL Server job that reorganizes all tables nightly. We don't have enterprise, so we cannot rebuild online (this means we need to reorganize). We also don't want to invest too ...
- 7,390
10
votes
2
answers
9k
views
REBUILD - Clustered Index, TABLE, or both?
I'm having trouble finding a definitive resource on this anywhere, so hopefully a guru can give me an answer here.
I have a very large table that we had to add a column to. The clustered index is ...
- 18.1k
1
vote
1
answer
509
views
How should I distribute my tables for better performance from fragmentation point of view
I have a database on SQL Server 2008 R2 with about 20 non-indexed tables that are continuously undergoing INSERTs AND DELETEs. There are about 400,000 records @ 4KB/record being inserted or deleted ...
- 11