You searched for the word(s):
Showing page 1 of 51 (505 total posts)
< 1 second(s)
I think it has to do with parameters used to generate the data set.
it would seem to me that the refresh is using partsupp keys out of bounds, perhaps the refresh was for higher SF?
Back in Feb, I went on a diatribe-rant against the standard SAN Vendor configuration practice.
Problem with Standard SAN Configuration IO Performance,
article and accompanying post,
showed IO performance metrics for a batch driven transaction processing workload
on a SAN managed by a data center/cloud company.
The only option ...
Michael Frandsen had a session at SQL Rally on this. I am inclined to think that Windows Server 2012+, and Infini-Band is the way go. Violin apparently has the Windows Flash Array. I convinced a client to purchase Infini-Band infrastructure, unfortunately I have not had time to get it configured.
I don't think it is a matter of being ...
Some of my top SAN configuration items for mission critical DB are:
1) dedicated physical disks for logs (high volume tx processing)
2) multiple FC IO channels, 4-8 (8 or 16Gbps) multiple data LUNs, no FCOE or iSCSI shit
prefer to have dedicated IO path for each LUN, not MPIO
3) 10K or 15K if HDD, no 7.2K for critical data, SSD if they are ...
didn't bill gates say that business is not war, but a knife fight in a dark alley. Its better in business to take chances, win at the risk of paying a civil liability later, than lose, winning a civil liability later?
The state of Virginia fiasco was the fault of the EMC engineer (not sure if he was a direct employee or VAR) who replaced the unit ...
You have to make a decision whether it is your responsibility to do exactly what and how your client asked even if would failure to accomplish their mission. Or you can do whatever is necessary to accomplish the mission despite their expectations of how it would be done. Usually I put this up front, but not always.
As much as you want to have ...
Time to market is extremely important. I hope DBA, or rather the data architect does not become a severe impediment. I would rather people put together a SQL Server db quickly, and correct over time. As I understand it, LinkedIn was slapped together. As they grew, it became apparent that any change would break many things, so they took time to fix ...
The charts provided here illustrates my complaints against SAN vendor doctrine,
obstinately adhering to the concept of one large pool of disks
from which all volumes are created for any purpose (data, log, and junk non-DB stuff).
There is no consideration for the radically different characteristics of hard disks
in random versus sequential ...
build now has legend font size 8, settable in the config file
It has been over 7 years now that I have made my
(current version Exec Stats 2015-02-18)
tool publicly available (late 2007), with prototype versions going back to 2006. The two distinguishing elements of ExecStats is 1) the emphasis on cross-referencing a) query execution statistics to b) index usage via the c) execution ...