SQLServerCentral Runs sp_Blitz - Performance Part 1
The third article that examines the output of the sp_Blitz script™ run against SQLServerCentral's database servers.
2013-01-22
9,590 reads
Performance Tuning
How Come the Hourglass? Why Database Applications Slow Down
It is frustrating when you hit 'submit' and you get the hourglass big-time. Is it the database to blame? It could be, but there are other suspects that should be considered. Feodor Georgiev describes where, in the long route, to and fro', that a data request makes before returning, that things can get snarled up.
2013-01-07
4,716 reads
Viewing VMware Counters in PerfMon for SQL Server
I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more.
2012-11-12
3,272 reads
Single User Performance of SQLite v. SQL Server
A look at the performance of SQL Server compared to SQLite for single user applications.
2012-07-19
7,040 reads
ETL Performance Auditing - Part 2: Auditing Data Staging Phase
Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
2014-11-07 (first published: 2012-06-12)
10,177 reads
The Real World: Implementing AWE
Describes the gains experienced in my environment by implementing AWE.
2012-05-16
8,144 reads
Performance Test of New Date Manipulation Functions (SQL Spackle)
Performance test of new SQL 2012 functions DateTimeFromParts and Format
2012-05-10
6,187 reads
Get Top Queries Taxing SQL Server CPUs
Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.
2012-03-10
2,882 reads
Database Performance Transparency
Describes the benefits of publishing instance performance metrics including a script to generate HTML-based Performance Snapshot.
2012-02-08
6,945 reads
2012-02-02 (first published: 2012-01-20)
3,902 reads
Blogs
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers