No announcements
Found 14995 threads
-
0 VotesFragment GetActivity
User164819 postedHi, I ran into problem with fragment ..Answered | 4 Replies | 8281 Views | Created by Anonymous - Tuesday, November 3, 2015 10:13 AM | Last reply by Anonymous - Friday, October 13, 2017 4:10 PM
-
3 Votes
Fragmentation?
SO here due to free space on page this fragmentation is known as internal fragmentation.Answered | 5 Replies | 2835 Views | Created by cchandra shekar - Tuesday, April 9, 2013 7:31 PM | Last reply by princerastogi - Saturday, April 13, 2013 2:04 PM -
3 Votes
Fragmentation %
What is the impact of fragmentation when my tables fragmentation is 99% but page count is 300 only?Answered | 5 Replies | 1122 Views | Created by Amit mishra - Thursday, January 22, 2015 9:22 AM | Last reply by Amit mishra - Thursday, June 25, 2015 12:21 AM -
2 Votes
Fragmentation
In one of database some table index Fragmentations are utilizing above 90% There is nothing like index utilization 90 % this is totally wrong.Answered | 10 Replies | 1299 Views | Created by subu999 - Monday, March 16, 2015 1:21 PM | Last reply by SQLZealots - Wednesday, March 18, 2015 12:43 PM -
0 Votes
Disk Fragmentation Vs SQL Server fragmentation
Hi Zainu SQL Server doesn't know about file-level fragmentation.Answered | 4 Replies | 7283 Views | Created by Zainu - Friday, November 20, 2009 10:40 AM | Last reply by Ewan - Monday, November 23, 2009 12:59 PM -
0 Votes
Issue with fragmentation
I personally ignore fragmentation when page count is less than 60.Answered | 3 Replies | 1015 Views | Created by karthiksqldba - Tuesday, April 22, 2014 12:42 PM | Last reply by Ed at Hammar Technology - Tuesday, April 22, 2014 1:09 PM -
0 Votes
Index Fragmentation
You should ask yourself why you want to get rid of the fragmentation?Answered | 6 Replies | 5265 Views | Created by Reddy Balaji C - Tuesday, August 3, 2010 10:22 AM | Last reply by Raoul Illyes - Tuesday, August 3, 2010 9:57 PM -
0 Votes
fragmentation myth
For that purpose I need a fragmented database...Answered | 9 Replies | 874 Views | Created by maca128 - Sunday, May 24, 2015 9:14 PM | Last reply by Shanky_621 - Tuesday, May 26, 2015 5:49 AM -
0 Votes
Index fragmentation script doesnt seem to be reducing fragmentation
http://sqlblog.com/blogs/kalen_delaney/archive/2008/02/28/fragmentation-revisited.aspx AMB ...Answered | 1 Replies | 5625 Views | Created by MrFlinstone - Monday, November 8, 2010 1:17 PM | Last reply by Hunchback - Monday, November 8, 2010 4:05 PM -
0 Votes
Index Fragmentation
Can someone let me know how there can be no logical fragmentation but 12.5% (one extent) extent fragmentation?Answered | 2 Replies | 1016 Views | Created by Andrew Pruski - Wednesday, November 20, 2013 4:26 PM | Last reply by Andrew Pruski - Tuesday, November 26, 2013 3:22 PM -
0 Votes
Fragmentation on tables
Maint plans has no functionality to get rid of fragmentation in heaps.Answered | 4 Replies | 1395 Views | Created by ashwan - Thursday, October 24, 2019 11:17 PM | Last reply by TiborK - Friday, October 25, 2019 9:15 AM -
0 Votes
De-Fragmentation
As the keys are guid the data is still somewhat fragmented, but as the number pages are low doing I/O should not be a performance problem on fetches via guid as the key.Answered | 4 Replies | 4614 Views | Created by Haroon Said - Thursday, May 7, 2009 6:39 AM | Last reply by Haroon Said - Wednesday, May 20, 2009 8:39 PM -
0 Votes
Excessive Fragmentation
This means that your DBA or some other admin has created a user defined alert for reporting the fragmentation on the database.Answered | 3 Replies | 5035 Views | Created by Prakash Nandwana - Wednesday, January 27, 2010 8:17 PM | Last reply by Amit Banerjee - Thursday, January 28, 2010 2:16 AM -
2 Votes
What is index fragmentation
Hi, Just a quiet note - index fragmentation is not the root of all evil.Answered | 2 Replies | 10934 Views | Created by Andrea Caldarone - Friday, February 24, 2012 4:12 PM | Last reply by Zoltán Horváth - Friday, February 24, 2012 5:35 PM -
11 Votes
High fragmentation and primary key
I agree first i need to defrag as some of the tables are 96% fragmented and then see how quickly they get fragmented again and how much difference it makes ...Answered | 11 Replies | 2748 Views | Created by panlondon - Wednesday, July 3, 2019 12:57 PM | Last reply by TiborK - Friday, July 5, 2019 8:30 AM -
0 Votes
what is database fragmentation
check: https://blogs.technet.com/b/magi/archive/2009/05/22/fragmentation-the-database-performance-killer.aspx http://blog.sqlauthority.com/2010/01/12/sql ...Answered | 3 Replies | 1966 Views | Created by adilahmed - Wednesday, March 5, 2014 8:13 AM | Last reply by Jayakumaur (JK) - Wednesday, March 5, 2014 9:52 AM -
10 Votes
suggestions on fragmentation stats?
Why should a NCI reduce the fragmentation of the HEAP itself?Answered | 14 Replies | 2600 Views | Created by '''HuuM''' - Tuesday, July 23, 2013 1:15 PM | Last reply by Ed Price - MSFT - Saturday, July 27, 2013 7:24 AM -
11 Votes
Fragmentation percentage , is this Good or Bad?
Moreover they are highly fragmented.Answered | 13 Replies | 11807 Views | Created by '''HuuM''' - Thursday, November 28, 2013 9:04 PM | Last reply by Alankar Chakravorty - Friday, November 29, 2013 7:55 AM -
0 Votes
Physical Fragmentation
If you use sysinternals contig (http://technet.microsoft.com/en-us/sysinternals/bb897428) with the -a option it can tell you how fragmented the specific file is.Answered | 1 Replies | 3431 Views | Created by DBA Dude - Thursday, October 6, 2011 7:56 PM | Last reply by Jonathan Kehayias - Friday, October 7, 2011 1:58 AM -
4 Votes
Identifying cause of index fragmentation
Is it possible to identify when an index becomes fragmented or what causes the fragmentation?Answered | 4 Replies | 718 Views | Created by runnerpaul - Wednesday, November 16, 2016 8:01 AM | Last reply by Naomi N - Wednesday, November 16, 2016 1:17 PM - Items 1 to 20 of 14995 Next ›
No announcements
