CellarTracker Main Site
Register for Forum | Login | My Profile | Member List | Search

Planned maintenance

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Cellar Talk] >> Release Notes >> Planned maintenance Page: [1] 2   next >   >>
Login
Message << Older Topic   Newer Topic >>
Planned maintenance - 1/13/2015 2:58:22 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		Today I am doing some "once per year" maintenance on the main site to rebuild all of the core database indices. This is a good thing for overall performance of the site. (I am also decreasing the fillfactor of the indices to help slow down future fragmentation.)

Since this is just a rare operation, I am not 100% sure how long it will take. When I did the comparable operation on two of the "read only" databases yesterday (these are what guests use to see the site) they both took about an hour. (The joy of having multiples of those is that I can do it without inconveniencing anyone.)

So for now the main site is in read-only mode for logged-in users. You can browse everything but can't edit.

We are nine minutes in and have rebuilt 124 of 720 indices.

I will update here a few times over the next 60-90 minutes until it is done.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker
Post #: 1
RE: Planned maintenance - 1/13/2015 3:09:34 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 20 minutes in. We have rebuilt 178 of 720 indices or 24.7%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 2
RE: Planned maintenance - 1/13/2015 3:14:19 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 25 minutes in. We have rebuilt 225 of 720 indices or 31.3%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 3
RE: Planned maintenance - 1/13/2015 3:24:27 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 30 minutes in. We have rebuilt 240 of 720 indices or 33.33%.

FWIW, some indices are tiny and rebuild in millseconds. Others are very big and can take minutes.

Unfortunately our 3am backup is running and seems to be slowing things down.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 4
RE: Planned maintenance - 1/13/2015 3:34:57 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 45 minutes in, and we have rebuilt 247 of 720 indices or 34.3%.

The concurrent backup is nearly done at 88%, and then hopefully the index rebuild will start really cooking again.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 5
RE: Planned maintenance - 1/13/2015 3:41:59 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, the backup is done, and the index rebuild is screaming along again. I need to make a note for next year to stop the backup job so these don't collide.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 6
RE: Planned maintenance - 1/13/2015 3:43:58 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 55 minutes in, and we have rebuilt 315 of 720 indices or 43.8%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 7
RE: Planned maintenance - 1/13/2015 3:49:22 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 60 minutes in, and we have rebuilt 390 of 720 indices or 54.2%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 8
RE: Planned maintenance - 1/13/2015 3:54:15 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 65 minutes in, and we have rebuilt 442 of 720 indices or 61.4%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 9
RE: Planned maintenance - 1/13/2015 3:59:21 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 70 minutes in, and we have rebuilt 468 of 720 indices or 65.0%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 10
RE: Planned maintenance - 1/13/2015 4:04:08 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 75 minutes in, and we have rebuilt 522 of 720 indices or 72.5%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 11
RE: Planned maintenance - 1/13/2015 4:09:14 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 80 minutes in, and we have rebuilt 564 of 720 indices or 78.3%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 12
RE: Planned maintenance - 1/13/2015 4:14:10 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 85 minutes in, and we have rebuilt 579 of 720 indices or 80.4%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 13
RE: Planned maintenance - 1/13/2015 4:19:03 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		88 minutes. All done!

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 14
RE: Planned maintenance - 10/29/2015 2:17:27 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, I am going to run this job again in about 25 minutes. When I did this in January it took 88 minutes, but it also collided quite badly with a 40 minute backup job. This time I will disable that job, so I am hoping that things are closer to 65 minutes. I will let you know as soon as it kicks off and update you regularly as it proceeds.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 15
RE: Planned maintenance - 10/29/2015 2:53:24 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, here we go.

740 indices to rebuild

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 16
RE: Planned maintenance - 10/29/2015 2:58:12 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 5 minutes in. We have rebuilt 117 of 740 indices or 15.8%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 17
RE: Planned maintenance - 10/29/2015 3:13:02 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		Uggh, here is another note for the future. Sometimes SQL Server will orphan a few running queries. They are mostly harmless, and once a month when I apply Windows Updates they get cleaned out. (I have found you cannot stop or kill these without recycling the SQL Processes.) Anyway, after my 5 minute update above, the system sat grinding on the same index for the next 5 minutes before I noticed that it was blocked. Sigh. So I stopped the job, restarted SQL Server, and now I am rerunning the job from the start. So we lost 10 minutes (the job rebuilds all indices from scratch and cannot really tell which ones have been done already.) So note to self for the future: recycle SQL Server before I kick off the index rebuild.

Take 2. OK, 5 minutes in. We have rebuilt 82 of 740 indices or 11.1%.

(And if you are wondering why it made different progress, it is due to the fact that it processes the indices in order of fragmentation. So this second run is working on different indices. And some indices are tiny and rebuild in seconds, while others are huge and take minutes.)

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 18
RE: Planned maintenance - 10/29/2015 3:16:32 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 10 minutes in. We have rebuilt 90 of 740 indices or 12.2%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 19
RE: Planned maintenance - 10/29/2015 3:21:37 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 15 minutes in. We have rebuilt 107 of 740 indices or 14.5%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 20
RE: Planned maintenance - 10/29/2015 3:26:33 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 20 minutes in. We have rebuilt 139 of 740 indices or 18.8%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 21
RE: Planned maintenance - 10/29/2015 3:32:34 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 25 minutes in. We have rebuilt 176 of 740 indices or 23.8%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 22
RE: Planned maintenance - 10/29/2015 3:36:34 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 30 minutes in. We have rebuilt 176 of 740 indices or 30.0%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 23
RE: Planned maintenance - 10/29/2015 3:41:35 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 35 minutes in. We have rebuilt 285 of 740 indices or 38.5%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 24
RE: Planned maintenance - 10/29/2015 3:46:50 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 40 minutes in. We have rebuilt 350 of 740 indices or 47.3%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 25
RE: Planned maintenance - 10/29/2015 3:51:33 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 45 minutes in. We have rebuilt 390 of 740 indices or 52.7%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 26
RE: Planned maintenance - 10/29/2015 3:56:29 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 50 minutes in. We have rebuilt 412 of 740 indices or 55.7%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 27
RE: Planned maintenance - 10/29/2015 4:01:26 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 55 minutes in. We have rebuilt 482 of 740 indices or 65.1%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 28
RE: Planned maintenance - 10/29/2015 4:06:43 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 60 minutes in. We have rebuilt 515 of 740 indices or 69.6%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 29
RE: Planned maintenance - 10/29/2015 4:11:30 AM   
Eric

 

Posts: 17314
Joined: 10/10/2003
From: Seattle, WA
Status: offline 		OK, 65 minutes in. We have rebuilt 529 of 740 indices or 71.5%.

_____________________________

Cheers!
-Eric LeVine

http://twitter.com/cellartracker
http://facebook.com/cellartracker

(in reply to Eric)
Post #: 30
Page:   [1] 2   next >   >>
All Forums >> [Cellar Talk] >> Release Notes >> Planned maintenance Page: [1] 2   next >   >>
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.235