SQL Server Performance Archives

SQL Server Identity Values Check on GitHub

December 21, 2016December 21, 2016 by Thomas LaRock

Last year I blogged about a script that Karen López (blog | @datachick) and I wrote together to help you determine if you were running out of identity values.

Crosstown Traffic and the Future of Monitoring

November 2, 2016 by Thomas LaRock

When it comes to monitoring data, the are only five possible resource bottlenecks (disk, memory, cpu, network, locking/blocking).

8 Ways To Be Successful With Microsoft Azure SQL Database

August 4, 2016 by Thomas LaRock

When I hear stories about folks that tried to migrate to Microsoft Azure SQL Database with a brute-force-single-click and failed, I ask several follow up questions. I have found a common pattern in the answers: lack of strategy.

SQL Server Trace Flags

June 22, 2016 by Thomas LaRock

Nobody likes surprises when it comes to upgrading or migrating SQL Server instances. Trace flags get set and forgotten. I’m hoping that this post will help people to remember.