All Questions
Tagged with fragmentation sql-server-2012
12 questions
1
vote
1
answer
191
views
Index maintenance for AG DBs
I wanted to get some opinions on the index maintenance we currently do at the company where I work. One of our production SQL 2012 clusters that consists of 4 nodes, with two instances on each, has ...
- 63
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
5
votes
1
answer
2k
views
SQL Server - Very high disk activity after running query?
I'm running SQL Server Express 12.0.4100 on an AWS instance with 16 cores and 64 GB of RAM with a 3TB and 9000 IOPS EBS attached. This has been running for 2 years perfectly with no issues until this ...
- 183
4
votes
3
answers
17k
views
Query to see Index Fragmentation on all databases without using SP or temp tables
I am trying to compile a index fragmentation report on all databases, in a multi-server environment. The query will be executed via an openquery command, so I would like to make it as simple as ...
- 313
1
vote
1
answer
319
views
Is there any way to find information of index fragmentation, Statistics information with the help of system tables in SQL Server
I am working on a report which will give information for different segments like
blocking process
slow running queries
disk space etc.
I also want to add one more segment where I can get information ...
2
votes
2
answers
994
views
Online & Offline Index Rebuild
I had this weird case today.
Inside a database I had about 50 (1000+ pages, most of them 50000+ pages) tables which had their indexes fragmented above 70% even though I am running a nightly rebuild ...
- 1,802
3
votes
1
answer
2k
views
What is the impact of temporarily setting ALLOW_PAGE_LOCKS ON
The MSDN ALTER INDEX page says "An index cannot be reorganized when ALLOW_PAGE_LOCKS is set to OFF."
I'm modifying our index reorg/rebuild process to be sensitive to indexes that have ...
- 71k
0
votes
1
answer
111
views
One time database shrink catch-22 solution?
I am developing a plan for SQL Server 2012 EE to properly downsize and type (nchar to char types) some needlessly Unicode nvarchar(max) fields and would like to optimize the database size as part of ...
- 175
4
votes
2
answers
3k
views
Join on dm_db_index_physical_stats very slow
I'm running a small query below in a MS Dynamics AX 2012 database and it runs more than 5 minutes which I had to cancel and it is showing PAGEIOLATCH_SH wait type. The database data file is 560GB and ...
- 41
2
votes
2
answers
2k
views
fragmentation for non cluster index growth very fast to 30
i have table with about 7 milion records.index fragmentation was about 90 .
i try rebuild index for all index. and it works fine but after nightly job fragmentation for one of none cluster index ...
- 188
7
votes
2
answers
15k
views
SQL Server clustered index high fragmentation
I've got a Table with an Integer (4bytes) as primary key. it's defined as an identity. it is also the clustered index.
Inserts are working perfectly fine. After inserting 2000 rows the fragmentation ...
- 173
7
votes
2
answers
11k
views
Is high Extent Fragmentation a problem?
DBCC SHOWCONTIG scanning 'MyTable' table...
Table: 'MyTable' (2048062382); index ID: 1, database ID: 28
TABLE level scan performed.
- Pages Scanned................................: 1019182
- Extents ...
- 241