Category: Database

author:

Database

Analysis of PayPal’s Node-vs-Java benchmarks

December 9, 2013

I was interested in the data shown in PayPal’s blog post on switching from Java to Node.js, for two reasons. First, at a glance both sets of benchmark data looked very clean and fittable to the Universal Scalability Law to assess where the bottlenecks …



author:

Database

How to write Go packages coders will love

December 3, 2013

This post was featured in our July 2015 anthology of most popular SolarWinds Database Performance Monitor (DPM) blog posts of all time. One of the patterns I’ve found in the standard Go library is what I call package-and-object. (That’s my own name; maybe I’m …


author:

Database

5 Things You Didn’t Know About SQL Agent

November 27, 2013

Microsoft SQL Server comes with a boatload of additional components. One component is the SQL Agent. The purpose of the SQL Agent is to serve as a job scheduler. Many experienced DBAs use jobs running inside the SQL Agent to perform routine tasks such …



author:

Database

Big-O Notation Made Simple

October 23, 2013

If you’re a programmer or computer scientist, you’re probably familiar with Big-O notation. It’s part of your foundational understanding of how complex a problem and/or algorithm is. But most explanations of Big-O notation [overcomplicate][1] what’s actually a very simple subject, and make it inaccessible …


author:

Database

Improve SQL Server Performance by Looking at Plan Cache (Part 3)

October 3, 2013

You can use the information in the SQL Server plan cache to research performance issues and investigate opportunities for performance improvement. In this three-part article series, we’ve examined several important opportunities you have in mining information from the plan cache, including eliminating single-use plans …




author:

Database

100% Reproducible Builds in Go

September 10, 2013

This post was featured in our July 2015 anthology of most popular SolarWinds Database Performance Monitor (DPM) blog posts of all time. One of the nice things about Go is statically compiled binaries, which don’t have external dependencies. There are lots of reasons this is …