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 ««12

Fragmentation Fear Expand / Collapse
Author
Message
Posted Monday, October 1, 2012 2:51 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334, Visits: 3,069
Agreed, re-indexing is one of several things that should be automated on your db server from the getgo.

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #1366775
Posted Tuesday, October 2, 2012 3:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 21, 2013 8:24 AM
Points: 9, Visits: 32
'It's something that should be scheduled and automated.'

True, if you have the window to do it - not always possible without affecting the system's usage.
Post #1366924
Posted Tuesday, October 2, 2012 8:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334, Visits: 3,069
Databases are not self-healing animals, they require maintenance windows, period. I usually do weekly online re-indexing between 3-5AM on a Sunday morning, after the Sunday backups have taken place. In that way, I don't affect my U.S. systems adversely, even the 24/7 databases. For overseas databases i adjust accordingly.

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #1367096
Posted Sunday, October 21, 2012 6:39 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:32 PM
Points: 35,584, Visits: 32,174
des.browning (10/2/2012)
'It's something that should be scheduled and automated.'

True, if you have the window to do it - not always possible without affecting the system's usage.


Catch-22. Not doing it will likely affect the "system's usage", as well.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1375224
Posted Monday, October 22, 2012 10:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 1,400, Visits: 6,787
Postponing defragmentation till really necessary as there are some many things involved: usage, fragmentation DB level, fragmentation os level, fragmentation storage level...
Post #1375607
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse