S3OLV March 2011

Tags: , ,
Comments: No Comments
Published on: March 2, 2011

The Ides of March are upon us and that means that we have another opportunity to learn some stuff about SQL Server.  We have that opportunity because it is time for the monthly S3OLV User Group meeting.

This month, Glenn Berry of SQL Server MVP fame has volunteered to present to our group via Livemeeting.  Glenn will be teaching us how to properly Select and Size database hardware in regards to OLTP performance.  Here is the abstract for this presentation.

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.


We will be holding this learning opportunity March 10, 2011 between 6:30 PM PST and 8:30PST.

Livemeeting Connection Information can be found as follows:

  • Copy this address and paste it into your web browser: https://www.livemeeting.com/cc/UserGroups/join
  • Copy and paste the required information: Meeting ID: 3DPBZQ
  • A little about our Presenter

    Glenn works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure.  He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University – University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.

    Contact Info
    Twitter: GlennAlanBerry

    No Comments - Leave a comment

    Leave a comment

    Your email address will not be published. Required fields are marked *

    March 2011
    M T W T F S S
    « Feb   Apr »


    • @PLucas87: Anyone come across SCD treating derived columns as changes despite data being the same in SSIS 12? Errors on Fixed Atts #SSISHelp #SQLHelp
    • @JanosBerke: Anyone has experience (good or bad) w/ jTDS and connection pooling? #sqlhelp
    • @NaineshBabariya: #sqlhelp I want to move my distributor server to a brand new server. Can some one help me with the steps having minimal downtime.
    • @arcticdba: One table, 1M rows/day, ever-increasing BIGINT+other col as key. Needs to be stored for 10 years. Partitioning? Other ideas? #sqlhelp
    • @MrACutler: Can I swap package conns for project conns in SSIS 2014? Ive conv a project to project-deployment but can only do the first package #sqlhelp
    • @SQLHA: @SivassqlG Assuming FCI and one of 'em, why do you care about setting preferred owners (which is how it's done)? #sqlhelp
    • @SQLHA: @SivassqlG FCI? AG? SQL Server clustering is not specific enough. And one instance? More than one instance? #sqlhelp
    • @SivassqlG: #sqlhelp how to set node priority in SQL server clustering..means we have 3 node cluster active-A,passive-B,passive-C
    • @soteark: Datalength() on xml variable shows half the size of the same xml data in an xml file without formatting. Why and how to solve? #sqlhelp
    • @BrentO: @EvoDBA No, databases in an AG can’t be restored. #SQLhelp

    Welcome , today is Friday, November 27, 2015