• Home
  • Q & A

SQLPerformance.com

powered by SQL Sentry
  • About
  • Contact
  • RSS Feed

SQL Server Database Server Hardware Upgrade Case Study

 Posted by Glenn Berry on October 31, 2013  No Responses »
Oct 312013
 

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

Continue Reading »
 Tagged with: benchmarks, hardware, TPC

Slide decks and samples from #SQLintersection

 Posted by Aaron Bertrand on October 30, 2013  No Responses »
Oct 302013
 

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.

Continue Reading »
 Tagged with: AlwaysOn, presentations, samples, slides, sqlintersection

What Virtual Filestats Do, and Do Not, Tell You About I/O Latency

 Posted by Erin Stellato on October 23, 2013  11 Responses »
Oct 232013
 

Erin Stellato (@erinstellato) of SQLskills.com shows us why I/O latency or high I/O-related waits are not always indicative of slow storage.

Continue Reading »
 Tagged with: I/O latency, wait stats

PASS Summit 2013 : A success in Charlotte

 Posted by Aaron Bertrand on October 21, 2013  8 Responses »
Oct 212013
 

Aaron Bertrand (@AaronBertrand) reflects on PASS Summit 2013, which was held in Charlotte this past week.

Continue Reading »
 Tagged with: PASS; PASS Summit;

SQL Server 2014 : Native backup encryption

 Posted by Aaron Bertrand on October 16, 2013  7 Responses »
Oct 162013
 

SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a quick look at performance of encrypted backups in SQL Server 2014, and points out a couple of other things you'll want to know before implementing the feature.

Continue Reading »
 Tagged with: backup, encrypted backup, encryption

Parallel Execution Plans – Branches and Threads

 Posted by Paul White on October 7, 2013  3 Responses »
Oct 072013
 

Paul White (@SQL_Kiwi) dives deep into new execution plan information introduced in SQL Server 2012; specifically, thread reservation and usage information for parallel plans.

Continue Reading »
 Tagged with: branches, exchanges, parallelism, threads

How Much RAM Does Your New Database Server Need?

 Posted by Glenn Berry on October 2, 2013  7 Responses »
Oct 022013
 

Glenn Berry (@GlennAlanBerry) of SQLskills.com talks about memory limits on certain versions and editions of SQL Server, and ways to determine the optimal amount of memory to put in your servers.

Continue Reading »
 Tagged with: memory, Standard Edition

Search SQLPerformance.com

Authors

  • Aaron Bertrand
  • Erin Stellato
  • Glenn Berry
  • Jason Hall
  • Joe Sack
  • Jonathan Kehayias
  • Kevin Kline
  • Paul Randal
  • Paul White
  • Rick Pittser
  • Tim Radney
  • Guest Posts

Categories

  • Database Design (12)
  • Error Handling (1)
  • Extended Events (12)
  • Installation (6)
  • IO Subsystem (31)
  • Monitoring (8)
  • Service Broker (2)
  • SQL Alert (1)
  • SQL Indexes (42)
  • SQL Job (1)
  • SQL Lock/Block/Deadlock (5)
  • SQL Maintenance (7)
  • SQL Memory (6)
  • SQL Optimizer (41)
  • SQL Performance (167)
  • SQL Plan (70)
  • SQL Server 2016 (8)
  • SQL Statistics (14)
  • SQL Trace (5)
  • System Configuration (49)
  • T-SQL Queries (95)
  • Transaction Log (12)
  • Virtualization (1)
  • Waits (14)

Archives

  • March 2016 (2)
  • February 2016 (4)
  • January 2016 (4)
  • December 2015 (6)
  • November 2015 (5)
  • October 2015 (6)
  • September 2015 (3)
  • August 2015 (7)
  • July 2015 (6)
  • June 2015 (5)
  • May 2015 (5)
  • April 2015 (6)
  • March 2015 (5)
  • February 2015 (4)
  • January 2015 (4)
  • December 2014 (5)
  • November 2014 (3)
  • October 2014 (5)
  • September 2014 (5)
  • August 2014 (5)
  • July 2014 (5)
  • June 2014 (7)
  • May 2014 (6)
  • April 2014 (6)
  • March 2014 (7)
  • February 2014 (5)
  • January 2014 (9)
  • December 2013 (5)
  • November 2013 (5)
  • October 2013 (7)
  • September 2013 (6)
  • August 2013 (6)
  • July 2013 (7)
  • June 2013 (6)
  • May 2013 (5)
  • April 2013 (8)
  • March 2013 (7)
  • February 2013 (9)
  • January 2013 (6)
  • December 2012 (4)
  • November 2012 (7)
  • October 2012 (7)
  • September 2012 (4)
  • August 2012 (9)
  • July 2012 (2)
Logo and site design © SQL Sentry, LLC
User contributions are licensed under cc-sa with attribution required.
Suffusion theme by Sayontan Sinha
ZW5kZW5yYWhheXU5QGdtYWlsLmNvbQ==