Viewing 15 posts - 4,621 through 4,635 (of 9,253 total)
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...
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...
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
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
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 😉
November 15, 2012 at 3:07 pm
test a couple of smaller arrays too as well as RAID5 vs RAID10
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...
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...
November 15, 2012 at 1:06 pm
SQLSACT (11/15/2012)
The moment your recover the secondary database in a Log Shipping setup, a restore is required to re-start the session again.
this is incorrect, role switching in log shipping...
November 15, 2012 at 12:01 pm
TheSQLGuru (11/15/2012)
November 15, 2012 at 11:55 am
jswong05 (11/14/2012)
November 14, 2012 at 1:30 pm
chandan_jha18 (11/14/2012)
Thanks for replying.
The server uses VMWare and the sysadmin wrote the following to me:
'All of these drives are situated on the same set volume on the NetApp'.
He also wrote...
November 14, 2012 at 8:30 am
yes, so you'll need to filter for your particular group then won't you 😉
Check the link below for more info
November 14, 2012 at 6:31 am
sql-lover (11/14/2012)
Thanks Perry,I'll take a look today
It will help you understand better 😉
sql-lover (11/14/2012)
November 14, 2012 at 6:16 am
Check the following system catalog for listener info
select * from sys.availability_group_listeners
November 14, 2012 at 5:33 am
Viewing 15 posts - 4,621 through 4,635 (of 9,253 total)