THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 55 (541 total posts) < 1 second(s)
  • re: Server Sizing Comments: the case for 1-socket in OLTP

    SQL Server 2005 forward may try to schedule all threads on the same node but does not guarantee it. I do remember situations where 7 threads were on one node and the 8th was on another. I am of the opinion that when MAXDOP is set to N, N being the number of physical cores on one node or less, that the DOP strategy should be to give me up N with ...
    Posted to Joe Chang (Weblog) by jchang on April 14, 2016
  • re: Server Sizing Comments: the case for 1-socket in OLTP

    no I have not read it until you pointed it out. I do know that older versions of SQL Server, 2008, not sure about R2, that a parallel execution plan might get some threads on one socket and some on another when MAXDOP is less than the total number. But back then, perhaps MS was not fully up to speed on such strategies. It does seem that 2008R2, ...
    Posted to Joe Chang (Weblog) by jchang on April 13, 2016
  • Server Sizing Comments: the case for 1-socket in OLTP

    Long ago, almost 20 years, there was legitimate concern on whether servers had sufficient capability to drive transaction processing requirements for large businesses. Then for a long period, perhaps from the late 1990s to 2012, the better choice for most mid to large businesses was to simply buy a 4-way (socket) system. Larger systems were ...
    Posted to Joe Chang (Weblog) by jchang on April 12, 2016
  • re: PDW Concept on NUMA

    it has been a long time since I have looked at PDW, is it APS now? I lost interest when they went 7.2K HDD only. I think MS has become dominated by marketing types who become enamored with paper specifications, in this case, the size of the database, rather than how it is used. I am of the opinion that there are situations in which we want massive ...
    Posted to Joe Chang (Weblog) by jchang on January 7, 2016
  • re: SSD Form Factor and interface

    My opinion is that the cloud is a response to IT infrastructure practices. Too many buy gold bricked systems, mandate standard configurations that do not suit databases etc, implement procedures that obstruct the ability to do information technology. There have times I have spent several weeks trying to negotiate with the infrastructure team on ...
    Posted to Joe Chang (Weblog) by jchang on December 29, 2015
  • re: Data Tales #5: The Case of the Rogue Index

    hello Greg Not that I think it is a smart idea to disable row locks willy nilly, but if you want to speculate why, in my slide from CMG2004, slides 50-53 in query performance of the key lookup operation versus rows, there is a major collapse in the neighbor of 3000-5000 ...
    Posted to Greg Low (The Bit Bucket: IDisposable) (Weblog) by jchang on December 17, 2015
  • re: Computers without ECC memory are crap - no exceptions

    thanks donaldvc, I will read this when I get a chance. That ECC for single/double bit errors is necessary has be known for a long time. From a quick skim, I think this article is stressing the importance of correlated multi-bit errors, given the organization and high density of DRAM. My comments will be a the bottom of the main post.
    Posted to Joe Chang (Weblog) by jchang on December 10, 2015
  • re: SSD Form Factor and interface

    Good question. Sorry about the long winded answer, but life is complicated. I do agree with shared storage concept in HDD days, having a common pool of HDD so that each host can access the aggregate IOPS capability when needed. This and managing the complex storage system alone would have justified a good profit margin. But storage felt the ...
    Posted to Joe Chang (Weblog) by jchang on December 7, 2015
  • re: Join and Query hints – serious DBAs need to learn this

    (Santa?) Claus: Sommarskog is a stud! 4.8 When OPTION (RECOMPILE) Hurts You and people say I am over analytical, heck I'm a hip shooter by comparison. Cartman: nice,
    Posted to Joe Chang (Weblog) by jchang on December 4, 2015
  • re: Join and Query hints – serious DBAs need to learn this

    If you want to say that if the recompile cost is low, then use the OPTION(RECOMPILE) because it is simplest, then that's fine. I do not agree that this works best in all but the highest throughput system, 1-2%. I have seen compile issues sink what I consider middle-high systems, perhaps in the 10% range. I recall one site where they were at 2000 ...
    Posted to Joe Chang (Weblog) by jchang on December 3, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement