Viewing 15 posts - 4,606 through 4,620 (of 9,241 total)
what was done to the database in between the restore to the secondary server and then the new backup, got any maintenance tasks\scripts running?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2012 at 11:15 am
ah ok, to be honest i've never just sat there and watched it. Incidentally why do you have all 22 instances installed across all 5 nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2012 at 9:21 am
I usually use 256KB for data and backup drives and 64KB for log files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2012 at 3:25 pm
jfogel (11/15/2012)
Much appreciated. I thought I knew a lot more about this stuff but as I'm digging in I'm finding some surprises.
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2012 at 3:24 pm
do you have an AD Global Catalog configured on the remote site?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2012 at 6:59 am
the stripe size specifically, the optimal stripe sizes for SQL Server are 64KB and 256KB.
As i mentioned above you need to vary your tests as data files are typically 8KB...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2012 at 6:28 am
MyDoggieJessie (11/16/2012)
Again as mentioned above this storage array will only be used for data and index files (NO log or tempdb files)
in that case for data and index files you'll...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2012 at 6:08 am
you need to benchmark for a little more than 4KB sequential even for the T-log. Test for the following
8KB random read and write
4-60KB sequential write
64KB sequential read and write
up to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2012 at 5:38 am
MyDoggieJessie (11/15/2012)
Running some tests using IOMeter (preferred the GUI to this one over SQLIOsim)
Errm, for benchmarking your I\O capacity (which is what you're doing here) you need to be using...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2012 at 3:42 pm
how exactly are you installing the updates?
The most efficient way is to run the patch with the AllInstances switch to update in one run.
This article details the switches used
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2012 at 3:34 pm
what are the status' of the arrays, check for dead disks, etc first. This may degrade RAID performance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2012 at 3:12 pm
jfogel (11/15/2012)
Thank you. I will work with this tonight.
OK sure, post back if you're still stuck 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2012 at 3:07 pm
test a couple of smaller arrays too as well as RAID5 vs RAID10
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2012 at 2:03 pm
jfogel (11/15/2012)
This stuff throws a wrench in how I'm used to backing up my DBs and transaction log backup schedules too. Gotta get more practice with this stuff.
These are the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2012 at 1:54 pm
the best bit is, providing the differential base LSN is in sync between the primary and secondary you can use a differential backup to bridge LSN gaps when resuming log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2012 at 1:06 pm
Viewing 15 posts - 4,606 through 4,620 (of 9,241 total)