Enterprise Database Performance

Posted on Dec 26, 2013 in SQLSaturday | 0 comments

Eddie Wuerch discusses database performance at ExactTarget, one of the largest email vendors in the world.  Eddie is a SQL Server DBA Specializing in SQL Server tuning and design and leadership for very large, high-transaction, high-uptime database environments. He and his team design and manage the many multi-terabyte 24×7 SQL Server database clusters that form the foundation of the ExactTarget application.

In this video, Eddie discusses Temp DB and VLDB/Enterprise Performance, High Availability, and Troubleshooting. He focused on many of the hidden issues that can kill server performance.

Eddie spoke at SQL Saturday Silicon Valley. The next SQL Saturday Silicon Valley is coming up on March 15, 2014 in Mountain View, California. Learn more and register here

Read More

Joe Sack On Connecting At SQLSaturday

Posted on Dec 9, 2013 in SQLSaturday | 0 comments

We were lucky that Joe Sack was able to join us at SQL Saturday Silicon Valley in March 2013.   Joe is an well-known SQL Server author and consultant with with SQLskills.  Previously he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customers.

The next SQL Saturday Silicon Valley is coming up on March 15, 2014 in Mountain View, California.  Learn more and register here

 

Read More

Don’t miss SQL Saturday Silicon Valley on Feb 23rd!

Posted on Feb 11, 2013 in Business Intelligence | 0 comments

SQL Saturday Silicon Valley is coming up soon.

SQLSatBanner 4 300x70 Dont miss SQL Saturday Silicon Valley on Feb 23rd!

 

 

 

SQL Saturday is a free one-day training and networking event for SQL Server and Business Intelligence professionals.  There will be six concurrent tracks:

  • SQL Server 2012
  • Database Administration
  • Database Development
  • Business Intelligence (two tracks)
  • Microsoft Big Data

Register today and let your friends and colleagues know about this fantastic learning opportunity too.  See you on February 23rd!

Organizers: Mark Ginnebaugh and Ross Mistry.

Read More

Flash Memory Update from Fusion-io

Posted on Oct 13, 2012 in SQL Server 2012 | 0 comments

Sumeet Bansal, Principal Solutions Architect at Fusion-io returned to the Silicon Valley SQL Server User Group recently.  It’s exciting to see the ongoing innovations at Fusion-io and the broad range of problems we can solve using Fusion-IO’s ioMemory and associated software.

Fusion-io is the market leader for use of Flash memory for IO-intensive tasks.  The company was founded in 2006 when its founders recognized that spinning disk-era storage could no longer keep up with modern data demands. Since then their capacities have increased, along with improvements to speed and reliability.  They have also broadened their product line to address more use cases – situations where organizations can utilize Fusion-io‘s technology to solve additional problems faced by enterprise IT.

Here are some SQL Server deployment scenarios Sumeet discussed:

  1.  Stand Alone.  This configuration is for maximum acceleration.  This can be used for Mirroring, and also with SQL Server 2012 Always On for High Availability.
  2. Virtual.  In this scenario, you can dramatically improve  the performance of virtual servers by using ioMemory with software from Fusion-io called ioTurbine.
  3. Clustered.  These deployments use optional software called ION Data Accelerator.  This allows the ioMemory to be accessed via Fibre Channel, IB, and iSCSI.  Clustered deployments see large (2X-20X) increases in application performance, and higher IOPS, delivered at a very low cost, all while providing High Availability.

Read More