Viewing 15 posts - 1 through 15 (of 507 total)
You can go down sector sizes but you can't go up.
If your storage is a 4k sector you cannot restore a database that is a 512 byte sector to it.
November 14, 2013 at 7:47 am
If you have multiple log files on a single drive that effectively makes it random I/O and a good candidate for solid state. If, however you have dedicated spindles...
March 9, 2012 at 7:20 am
When this article was written FusionIO was pretty much the main player in the enterprise space. I have covered several of the topics you are looking for on my blog...
March 9, 2012 at 7:17 am
I would say this is a known error in 2008. Is the plan making use of any temporary objects at all? An eager spooler for example?
August 24, 2011 at 8:09 am
I prefer to use a two column approach to build a tree instead of the single column style that you have to split, it doesn't scale well. For smaller stuff...
March 10, 2011 at 3:39 am
you have to use a trace flag to enable mounting database files on a network share. It isn't recommended at all. http://support.microsoft.com/kb/304261
September 3, 2010 at 7:56 am
Gail didn't post an opinion. Her conclusion is based on fact.
Having build backup tools and log readers for a living she is 100% correct. You have gone as far...
May 17, 2010 at 8:46 am
if you set the size of tempdb it will default to that size on restart. It doesn't report the sizes properly in 2008 in some parts of the GUI you...
April 28, 2010 at 9:08 am
I'd seriously think about calling MS support on this one.
April 28, 2010 at 8:10 am
run dbcc on master.
Check to make sure that nothing else is trying to access the database files process monitor from sysinternals will tell you 100% who is accessing the files.
April 28, 2010 at 7:48 am
Paul White NZ (4/11/2010)
Wesley Brown (4/9/2010)
If you are using Standard Edition like I am you don't get the full benefit of SQL Servers read-ahead feature.
Wesley Brown (4/9/2010)
Well that is true to some...
April 11, 2010 at 8:25 pm
Just some personal observations:
1. On larger queries SQL Server read-ahead kicks in and it reads 512KB blocks at a time. In my observations disks are much better at...
April 9, 2010 at 6:28 pm
Get a quote for 5TB on the dsi3600 or a comparable TSM RAM-SAN. 8 Fusion-IO 640 Duo's get you 5.1TB of raw space. will retail at 124k. another 10k for...
April 9, 2010 at 10:46 am
"The sector size can be changed between 512(default) and 4k (4096) (not 8k). I think this is only...
April 9, 2010 at 7:43 am
With the INTEL drives did you have the same memory overhead as what is described by Wes in this article?
I'm trying to determine the scope of this additional memory requirement....
April 8, 2010 at 10:03 pm