Microsoft SQL Server Performance Monitoring and Tuning

New & Notable

Download this free guide

Download: 60-Page Expert RDBMS Guide

Trends come and go, but your DB strategy shouldn’t be a flavor of the month. Learn why you shouldn’t get distracted by new DB technology, how Facebook is using a RDBMS to do the data slicing and dicing they can’t in Hadoop, and more.

Corporate E-mail Address:
You forgot to provide an Email Address.
This email address doesn’t appear to be valid.
This email address is already registered. Please login.
You have exceeded the maximum character limit.
Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Microsoft SQL Server Performance Monitoring and Tuning News

January 17, 2018 17 Jan'18
Meltdown and Spectre fixes eyed for SQL Server performance issues

Microsoft has responded to the Spectre and Meltdown chip vulnerabilities with patches and other fixes. But IT teams need to sort out SQL Server performance issues they may create.
September 09, 2015 09 Sep'15
SolarWinds Database Performance Analyzer gets MySQL support

The latest version of SolarWinds Database Performance Analyzer works with MySQL, giving users of both Oracle and MySQL support with a common performance management interface.
March 14, 2012 14 Mar'12
SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing

With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are.
March 02, 2012 02 Mar'12
Microsoft bulks up SQL Server scalability to rival buff competition

Better SQL Server scalability and lower costs have furthered Microsoft’s reach in recent years, industry observers say, and that’s good, because the competition is big and knows the turf well.

View All News

Microsoft SQL Server Performance Monitoring and Tuning Get Started

Bring yourself up to speed with our introductory content

Tips and tricks to cut your SQL Server cloud costs

Running SQL Server in the cloud can be expensive, but it doesn't have to be. These tips show you where wasteful spending happens and how to keep your database cloud bill low. Continue Reading
In-Memory OLTP

In-Memory OLTP is a Microsoft in-memory technology built into SQL Server and optimized for transaction processing applications. Continue Reading
The SQL Server 2012 Fast Track Data Warehouse reference architecture

Microsoft has released guidelines for a hardware-software configuration that maximizes SQL Server 2012 performance. Learn about what it entails. Continue Reading

View All Get Started

Evaluate Microsoft SQL Server Performance Monitoring and Tuning Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

A quick tutorial on SQL Server maintenance plans

SQL Server maintenance plans get a bad rap, but for DBAs who need a simple way to maintain databases, Microsoft's built-in tools are a good place to start. Continue Reading
Four free SQL Server tools every DBA can use

Various performance issues can arise in the day-to-day grind of managing databases. We've rounded up four free SQL Server tools that can help make DBAs lives a little bit easier. Continue Reading
Determine which database performance tools best mitigate bottlenecks

This buyer's guide provides detailed insight to help you determine if your organization could benefit from a database performance tool and how to navigate the tool-buying process. Continue Reading

View All Evaluate

Manage Microsoft SQL Server Performance Monitoring and Tuning

Learn to apply best practices and optimize your operations.

Five SQL Server maintenance steps you should take -- ASAP

Putting off SQL Server administration tasks can lead to problems. Do these often-neglected database maintenance items to help keep your systems running smoothly. Continue Reading
Microsoft technology refresh touches SQL Server, integration tooling

Microsoft is at work on a delicate technology refresh affecting database tuning and architecture, as well as data integration and business intelligence. Continue Reading
Configure SQL Server at database level with new scoping syntax

SQL Server 2016 adds ALTER DATABASE SCOPED CONFIGURATION to its new T-SQL statements. The statement lets DBAs control database configuration at the level of a single database. Continue Reading

View All Manage

Problem Solve Microsoft SQL Server Performance Monitoring and Tuning Issues

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

Troubleshoot SQL Server database performance with T-SQL

Basit Farooq provides eight tips for optimizing T-SQL code to prevent SQL Server database performance bottlenecks and to tune database applications. Continue Reading
The top three SQL Server third-party tools

Basit Farooq presents his top three SQL Server third-party tools for identifying and resolving SQL Server bottlenecks. Continue Reading
Five tips to avoid a performance bottleneck or other SQL Server snares

Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design. Continue Reading

View All Problem Solve