Once you have identified the queries that are running slowly on your server, you can often improve the top 3 to 5 most slowly running ones to see a significant performance improvements. An easy way to identify your slowest running SQL Server queries is to use our baseline reports tool. Here are two ways to… Continue reading Two ways to tune your SQL Server queries
Blog
Migrate your SQL Server database to Amazon RDS
This tutorial assumes that you already have your SQL Server Amazon Relational Database Services (RDS) database up and running. You will need the following: 1. Your RDS Endpoint: “trai.cjss4rqkzige.us-east-1.rds.amazonaws.com” in the example below 2. Your Master Username: “sa” in the example below 3. Your password 4. Install SQL Server Management Studio and connect to… Continue reading Migrate your SQL Server database to Amazon RDS
Licensing Microsoft SQL Server 2012
With the proliferation of virtual machines and powerful multi-core servers, it is no surprise that Microsoft has introduced a per-core licensing model with SQL Server 2012. I hope to make the various ways of licensing SQL Server 2012 a little easier to understand. First, lets discuss the SQL Editions that will be available. SQL Express,… Continue reading Licensing Microsoft SQL Server 2012
SQL Server IO performance on Amazon Web Services
When running your databases on an Amazon server instances, the disks on which your databases run are what Amazon calls “Elastic Block Storage” (EBS) volumes. EBS volumes are networked attached (NAS) disks. This means that data moved to and from the disks goes through the network interface card along with all the network traffic. This… Continue reading SQL Server IO performance on Amazon Web Services
4 Performance Counters for SQL Server
A good approach to use when investigating a SQL Server performance problem is to start at a high level and then zoom in on the problem area. If you start your investigation with these 4 counters you will have a good idea of whether the problem is memory, disk, or CPU. SQL Server:Buffer Manager Page… Continue reading 4 Performance Counters for SQL Server