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 (510 total posts) < 1 second(s)
  • re: Heading to SQL Sat NYC!

    Hope you don't mind if I piggy back off your announcement, as I was too lazy to do my own, I will be there too. The schedule shows Jimmy May, Thomas Grosher. Holy cow!, 13 sessions in each time slot.
    Posted to Rick Heiges (Weblog) by jchang on May 21, 2015
  • re: GHz and MHz-BIOS updates and Amdahl Revisited

    I am of the opinion that MS will not attempt to push per core to HT, but I do not deal much of MS account reps. I would want HT for transaction processing, i.e., high volume calls that execute quickly. If done right, HT should almost double performance, otherwise, maybe 50%. I would guess that you could forgo HT on column store queries, which ...
    Posted to Joe Chang (Weblog) by jchang on May 11, 2015
  • GHz and MHz-BIOS updates and Amdahl Revisited

    Last week, a routine performance test ran about twice as long as expected. A check of dm_exec_query_stats showed that CPU bound statements (worker time roughly equal to elapsed time) were approximately 3 times higher than previous tests for matching SQL statements. Almost all of the SQL involved single or few row index seeks, usually ...
    Posted to Joe Chang (Weblog) by jchang on May 11, 2015
  • re: TPC-E and TPC-C Comments

    please email to explain in more detail what you are looking for.
    Posted to Joe Chang (Weblog) by jchang on May 7, 2015
  • re: Transaction IO Performance on Violin

    I did not have input on the SAN-based storage configuration. One group within the client organization advocated the argument that they should not be staffing deep &quot;infrastructure&quot; expertise, hence they should outsource to a managed datacenter hosting provider (who shall remain nameless for now). The datacenter provider said they ...
    Posted to Joe Chang (Weblog) by jchang on April 28, 2015
  • 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement