You searched for the word(s):
Showing page 1 of 57 (567 total posts)
< 1 second(s)
changing the default CTOP is nice, but the most important matter is for the cost model to correctly model IO cost in parallel execution, i.e., scale IO cost with parallelism. Second most important is probably parallelism and NUMA, scaling is great with all threads on single socket, questionable over multiple sockets - redistribute streams having ...
It would be a cold day in hell before MS allows the cost model to be tunable, but MS said the same thing about PAE (used by AWE) back in 1997/8. There is a trace flag for the CPU/IO ratio, see Paul White's posts? But I do not think this is helpful because neither the current cost model CPU or IO components constitute a reasonable representation of ...
hello Glenn, that is correct, I endorse single socket with the Xeon E5 v4 processor that is capable of 2-way. You could buy either a UP or DP motherboard from Supermicro with 1-socket populated. Or you could buy a Dell or HP server with 1 E5v4.
Of course the E3 is not chump change, 16 PCI-E lanes is workable if I could get 4 x4 + the DMI equiv ...
The model for the cost of operations used by the SQL Server query optimizer
to produce an execution plan
is rather simple.
It has been largely unchanged since SQL Server version 7, RTM in 1998.
Back then, SQL Server had not yet achieved tier 1 status with commensurate
Some adjustments were made in version ...
The key to Hyper-Threading is in there being significant round-trip memory access no-op cycles. For transactions, this is very true. In other posts, I have suggested that this might be around 5% of instructions, meaning that perhaps only 12% of cycles are actually used by a thread. Hence scaling with HT is almost linear in the absence of ...
In principle, Azure, AWS etc. are good options to have. Very few companies have the resources to hyper-optimize IT infrastructure administration. Some have fallen into the trap of gold-bricking, using "enterprise" SANs, i.e. about $6K per HDD. Other have become obstructors of IT.
The problem is that every time something good comes ...
There are a number of interesting questions in parallel execution performance
that can be investigated using the TPC-H kit, which has a data generator.
There are also supplemental files that accompany published results.
Important questions in parallel execution are:
scaling versus degree of parallelism (DOP) on physical cores, ...
change the order to
DROP TABLE dbo.Table2, dbo.Table1
to avoid the foreign key constraint
Server system memory capacities have grown to ridiculously large levels
far beyond what is necessary now that solid-state storage is practical.
Why is this a problem?
Because the requirement that memory capacity trumps other criteria has
driven system architecture to be focused exclusively on low cost DRAM.
DDR DRAM, currently in its ...
There is an article on
that a new Intel processor architecture to succeed the lake processors
(Sky, Cannon, Ice and Tiger)
will be ''faster and leaner'' and more interestingly might not be entirely
compatible with older software.
The original source is
I suppose it is curious that the Lake processors form a ...