Remove 2008 Remove Cache Remove Database
article thumbnail

Performance Hero: Annie Sullivan

Speed Curve

But my original version was slow, because I queried the database for every page load. Of course writes were much less common than reads, so I added a caching layer for reads, and that did the trick. Then in 2008, Google issued a code yellow for application speed, and I was the code yellow lead for Google Docs.

article thumbnail

Tuning SQL Server Reporting Services

SQL Performance

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. SSRS 2008 brought that component into the reporting service module. Unlike the system database tempdb, ReportServerTempDB is not recreated at startup.

Tuning 67
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

The Lock Escalation Threshold – Part 1

SQL Performance

Let’s look at some examples using a fresh database. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. USE master ; -- Create a new test database. -- COLLATE clause only to remind people it exists. GOTO Start.

article thumbnail

Minimal Logging with INSERT…SELECT into Empty Clustered Tables

SQL Performance

The following script should be run on a development SQL Server instance in a new test database set to use the SIMPLE or BULK_LOGGED recovery model. spt_values AS SV ; Plan Caching. The DMLRequestSort property is saved as part of the cached plan. Trace Flag.

Cache 67
article thumbnail

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

“SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster. The following table is taken from an ASP.NET, session state cache, stress test. SQL 2016 – It Just Runs Faster: In-Memory Optimized Database Worker Pool.

article thumbnail

Common SQL Server Mishaps

SQL Performance

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49
article thumbnail

Minimal Logging with INSERT…SELECT and Fast Load Context

SQL Performance

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. The test table schema is such that 130 rows can fit on a single 8KB page when row versioning is off for the database. GO. -- Clear the plan cache. GO. -- Clear the plan cache. GO. -- Clear the plan cache. DETAILED'. )

Cache 64