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 51 (505 total posts) < 1 second(s)
  • re: TPC-H Benchmarks on SQL Server 2014 with Columnstore

    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?
    Posted to Joe Chang (Weblog) by jchang on April 22, 2015
  • Transaction IO Performance on Violin

    Back in Feb, I went on a diatribe-rant against the standard SAN Vendor configuration practice. The 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 ...
    Posted to Joe Chang (Weblog) by jchang on April 20, 2015
  • re: SAN Configuration Performance Problems

    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 ...
    Posted to Joe Chang (Weblog) by jchang on March 6, 2015
  • re: SAN Configuration Performance Problems

    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 ...
    Posted to Joe Chang (Weblog) by jchang on March 4, 2015
  • re: SAN Configuration Performance Problems

    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 ...
    Posted to Joe Chang (Weblog) by jchang on March 4, 2015
  • re: SAN Configuration Performance Problems

    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 ...
    Posted to Joe Chang (Weblog) by jchang on March 4, 2015
  • re: SAN Configuration Performance Problems

    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 ...
    Posted to Joe Chang (Weblog) by jchang on March 3, 2015
  • SAN Configuration Performance Problems

    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 ...
    Posted to Joe Chang (Weblog) by jchang on March 2, 2015
  • re: ExecStats update - automating execution plan analysis

    build now has legend font size 8, settable in the config file
    Posted to Joe Chang (Weblog) by jchang on February 18, 2015
  • ExecStats update - automating execution plan analysis

    It has been over 7 years now that I have made my ExecStats (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 ...
    Posted to Joe Chang (Weblog) by jchang on February 16, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement