Viewing 15 posts - 976 through 990 (of 1,583 total)
8KB random read and write - 90% read, 10% write ratio
TOT IO/sec: 2245.5
Total MB/sec: 17.6
Average IO Response Time: 7.22
MAX IO Response 153.3
CPU: 30.9
64KB sequential read and write - 90% read,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 16, 2012 at 6:26 am
Perry Whittle (11/16/2012)
Despite the advances in RAID5 i would expect a well defined RAID10 array to have superior write performance. I'm sure others will jump in here.
You've mentioned this before...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 16, 2012 at 6:14 am
Again as mentioned above this storage array will only be used for data and index files (NO log or tempdb files)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 16, 2012 at 5:45 am
Sorry, I did mean SQLIO - but for these tests I am only using IOMeter.
Results below for RAID 5
MAX IOPS - uses 4KB transfer request size, 100% reads, 100% sequential...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 15, 2012 at 7:59 pm
Well this depends...Can you use a linked server? If so, it's quite simple
EXECUTE [YOURSERVER].msdb.dbo.sp_start_job 'TESTJOB'
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 15, 2012 at 7:46 pm
Running some tests using IOMeter (preferred the GUI to this one over SQLIOsim) and using some of the predefined options here's the results:
ON a 12-disk, RAID 5, 1 hot-swappable spare,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 15, 2012 at 3:32 pm
Yes, this is the option I am going with first (lumping all disks into a single RAID 5 array). I believe keeping one as a hot spare leaves me...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 15, 2012 at 12:30 pm
Another quick note on what Charles has offered:
Depending on how many rows these "mini" queries will yield and if you have a beefy server with ample RAM, consider using parameter...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 14, 2012 at 1:55 pm
Please supply the execution plan for this exact query
"I know this is a bad query but I don't know why"
Press Ctrl-"M" before running the query, then when it completes you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 14, 2012 at 11:20 am
I spoke with our Tech Services guy and he said there'd be no issue using a RAID5 with 12 disks, it would give us ample space and yield 11 available...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 14, 2012 at 10:40 am
That should work.
Was thinking to place the 12-disks into one large RAID 5 (so that should leave me with 11 spindles) - I will place Data files and Index files...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 12, 2012 at 4:50 pm
90% reads, 10% writes...
Reading a couple of chapters from the link you posted pretty much narrows things down to a RAID5 or 10 (which is pretty much were I got...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 12, 2012 at 11:43 am
Just out of curiosity, how much data is being replicated? Please describe your architecture...for instance, how many articles are in the publication? When you created your publication, what options did...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 9, 2012 at 6:54 pm
I've seen this issue when attempting to obtain and execution plan from a procedure that had a cursor/loop in it and it have to process a set of statements several...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 9, 2012 at 11:45 am
muthyala_51 (11/9/2012)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 9, 2012 at 11:38 am
Viewing 15 posts - 976 through 990 (of 1,583 total)