SQL Performance Archives - Page 24 of 31

Hekaton with a twist: In-memory TVPs – Part 3

SQL Sentry's Aaron Bertrand (@AaronBertrand) talks a little more about in-memory table-valued parameters, and explains why some scenarios you test may not demonstrate the power of this technology.

Aaron Bertrand ◆ January 17, 2014

3

Cardinality Estimation for Multiple Predicates

Paul White (@SQL_Kiwi) talks about multiple predicate cardinality, including some new and undocumented trace flags in SQL Server 2014.

Paul White ◆ January 15, 2014

22

Performance Issues: The First Encounter

Erin Stellato (@erinstellato) of SQLskills.com gives some insight into how she initially approaches SQL Server performance troubleshooting.

Erin Stellato ◆ January 9, 2014

5

VMware CPU Hot Plug vNUMA Effects on SQL Server

Jonathan Kehayias (@SQLPoolBoy) shows how VMWare's vCPU hotplug technology can cause serious performance problems in certain vNUMA configurations.

Jonathan Kehayias ◆ December 30, 2013

7

A couple of small issues with Hekaton samples

SQL Sentry's Aaron Bertrand (@AaronBertrand) highlights a couple of potential problems discovered in various AdventureWorks-based In-Memory OLTP samples out there, and how to work around them.

Aaron Bertrand ◆ December 17, 2013

0

Hekaton with a twist: In-memory TVPs – Part 2

After an initial look at in-memory TVPs at small scale proved promising, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a closer look at trying to match more values against a much larger table.

Aaron Bertrand ◆ December 11, 2013

8

Hekaton with a twist: In-memory TVPs – Part 1

SQL Sentry's Aaron Bertrand (@AaronBertrand) investigates a new possibility in SQL Server 2014: creating and using memory-optimized table-valued parameters.

Aaron Bertrand ◆ November 25, 2013

5

Transaction Log Monitoring

Paul Randal (@PaulRandal), CEO and owner of SQLskills.com, discusses monitoring the transaction log, as he rounds out his series on transaction log configuration and management.

Paul Randal ◆ November 21, 2013

6

A couple of quick things on PASS feedback

Aaron Bertrand (@AaronBertrand) has a "soft" post on the PASS Summit 2013 speaker feedback, which was released earlier this week.

Aaron Bertrand ◆ November 8, 2013

2

SQL Server Database Server Hardware Upgrade Case Study

Glenn Berry (@GlennAlanBerry) of SQLskills.com compares the performance metrics and benchmarks between a handful of different SQL Server systems.

Glenn Berry ◆ October 31, 2013

1

Slide decks and samples from #SQLintersection

SQL Sentry's Aaron Bertrand posts his and Kevin Kline's slide decks and sample code from this week's #SQLintersection conference in Las Vegas.

Aaron Bertrand ◆ October 30, 2013

0