Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Index Fragmentation Expand / Collapse
Author
Message
Posted Wednesday, March 26, 2014 5:37 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 6:01 AM
Points: 601, Visits: 770
Hi,

I am working in the test environment. They are doing the performance testing (Perf environment). In perf environment do we need to consider about the index fragmentation or no need? Is it better to tell the team to check about the indexes or anyway it is perf environment so we don't need to worry about the fragmentation issues. Please let me know.

Thanks,
Ramana
Post #1555225
Posted Wednesday, March 26, 2014 5:42 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:18 PM
Points: 3,952, Visits: 7,170
It depends on what is being tested. If they are performance testing queries against the database, then I would recommend you rebuild/reorganize your indexes. If they are testing performance of the disk subsystems using a tool like IOMeter or SQLIO then you wouldn't need to bother.

What is the nature of the test(s)?


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1555229
Posted Wednesday, March 26, 2014 5:52 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 6:01 AM
Points: 601, Visits: 770
Hi Jessie,
Thanks for you reply. They are doing some load test. Not exactly database they are doing load test of a tool but that tool brings the data from SQL database.
Post #1555230
Posted Wednesday, March 26, 2014 7:17 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:18 PM
Points: 3,952, Visits: 7,170
If they haven't told you the nature of the test, I'd leave it
(although if you're in a DBA-type role, you ought to have inquired as to the nature of the test(s))


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1555239
Posted Wednesday, March 26, 2014 8:12 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 9, 2014 3:22 PM
Points: 177, Visits: 522
ramana3327 (3/26/2014)
Hi Jessie,
Thanks for you reply. They are doing some load test. Not exactly database they are doing load test of a tool but that tool brings the data from SQL database.

I think that if they will select from database, it is needed update statistics and rebuild index. But depends on which tables, because if they will use sys view I think that is not needed.
Post #1555241
Posted Wednesday, March 26, 2014 11:47 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:18 PM
Points: 3,952, Visits: 7,170
Possibly true, but the OP doesn't really state (or know) anything about the tests at this point. For all we know there's nothing but system databases in existence on the server (unlikely)

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1555269
Posted Thursday, March 27, 2014 12:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
I guess testing of tool performance should not be based on the fregmentation. The reason is that index fragmentation is always vary through out the day due to many DML. But surely after the reindex it will help to guage howmuch reindex can help.

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1555285
Posted Thursday, March 27, 2014 4:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:25 AM
Points: 13,872, Visits: 28,268
Assuming you're trying to replicate the production environment, I'd have whatever type of fragmentation management you have in production in place on the test machine. Same with statistics maintenance and even backups. But, as has already been said, it depends on what you're trying to do with the tests.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1555342
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse