ScaleOut Software
MAY 15, 2014
Given all this, we thought it would be a good opportunity to see how we are doing relative to the competition, and in particular, relative to Microsoft’s AppFabric caching for Windows on-premise servers. Testing Scale-Up Performance. So our comments will be confined to what testing we felt was valuable and how well SOSS performed.
SQL Performance
MAY 16, 2019
Both of the following tests must pass for SQL Server to choose to set DMLRequestSort to true when inserting to an empty clustered index with table locking specified: An estimate of more than 250 rows at the input side of the Clustered Index Insert operator; and. Test ; END ; GO. DMLRequestSort Conditions. DROP TABLE dbo. DEFAULT ''. )
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
MARCH 22, 2022
In this first part, after a quick introduction, I look at the effects of simple parameterization on the plan cache. The aim is to reduce compilations by increasing cached plan reuse. configname = 'cost threshold for parallelism' , @configvalue = 50 ; RECONFIGURE ; Example code: -- Clear the cache of plans for this database.
All Things Distributed
JUNE 21, 2017
Today, I'm excited to announce the general availability of Amazon DynamoDB Accelerator (DAX) , a fully managed, highly available, in-memory cache that can speed up DynamoDB response times from milliseconds to microseconds, even at millions of requests per second. Adding caching when your app is already experiencing load is not easy.
Tim Kadlec
JUNE 21, 2022
HTTP/3 work started in 2012 with Google working on QUIC, adopted by IETF in 2017, RFC’s published in June 2022. The browser stores alt-svc info in alt-svc cache. Testing the Performance of HTTP/3. Because of the alt-svc process, testing to compare HTTP/2 and HTTP/3 is tricky. Here are my notes. What and Why?
SQL Performance
APRIL 18, 2022
The low estimated cost of my test queries means we need to lower the cost threshold for parallelism to 1: EXECUTE sys. It’s important to remember the plan must be cached. Requesting an estimated plan from SSMS does not cache the plan produced (since SQL Server 2012). Parallel Parameterized Plan. sp_configure.
SQL Performance
MAY 20, 2022
Let’s look at the plan cache: SELECT. [ text ] LIKE '%SomeValue%Test%'. The parameter data types are still different, so separate plans are cached and no plan reuse occurs. CLEAR PROCEDURE_CACHE ; GO. DROP TABLE IF EXISTS dbo. CREATE TABLE dbo. ( SomeValue decimal ( 19 , 8 ) NOT NULL. ) ) ; GO.
Expert insights. Personalized for you.
40 
Let's personalize your content