Microsoft SQL Server Performance Monitoring and Tuning

New & Notable

Download this free guide

Free Resource: Hive vs. Spark vs. Presto

While SQL is the common langue of many data queries, not all engines that use SQL are the same—and their effectiveness changes based on your particular use case. So what engine is best for your business to build around? Compare Hive, Spark, and Presto to see which is best for you.

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

October 31, 2018 31 Oct'18
PASS Summit 2018 spotlights new demands on SQL Server DBAs

This year's PASS Summit comes as SQL Server 2019 looms and the cloud becomes a bigger factor. PASS board member Tim Ford talks about key trends ahead of it.
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.
October 23, 2007 23 Oct'07
Q&A: Create and tune indexes in SQL Server 2000

DBAs can build a SQL Server index best designed for their database environments by learning about columns, clustered indexes, and more.

Microsoft SQL Server Performance Monitoring and Tuning Get Started

Bring yourself up to speed with our introductory content

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered advice on how to make that happen. Continue Reading
Check SQL Server Query Store performance impact before using

Many IT teams hesitate to use SQL Server Query Store due to performance concerns. Consultant Andy Warren offers tips on how to test and get started with Query Store. Continue Reading
Azure Data Studio (formerly SQL Operations Studio)

Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems. Continue Reading

Evaluate Microsoft SQL Server Performance Monitoring and Tuning Vendors & Products

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

Pros and cons of using SQL Server audit triggers for DBAs

Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases. Continue Reading
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

Manage Microsoft SQL Server Performance Monitoring and Tuning

Learn to apply best practices and optimize your operations.

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs. Continue Reading
Key features to create a SQL Server audit trail in databases

SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database activities easier for database administrators. Continue Reading
SQL Server performance tuning best practices for DBAs

Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning best practices that can make it easier. Continue Reading

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.

How to resolve and avoid deadlocks in SQL Server databases

Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and stop them from recurring. Continue Reading
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