Microsoft SQL Server Performance Monitoring and Tuning

Microsoft SQL Server Performance Monitoring and Tuning Get Started

Bring yourself up to speed with our introductory content

• 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

• Step 1: Invest in good application design

  To get the most from your hardware, spend your up-front resources on solid SQL server application design and an exhaustive QA process. Continue Reading

• Tutorial: Performance tuning SQL Server via queries, indexes and more

  If you are looking to tune your SQL Server in the hopes of improving performance, this tutorial has the expert advice you need. Learn how to optimize queries, employ the best indexing practices, utilize the best storage or memory configurations and ... 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.

• Enbridge Inc. to virtualize all its servers

  Energy company Enbridge Inc. is in the process of virtualizing all of its servers to increase flexibility and cut costs. Not everyone is happy with this new direction. Continue Reading

• Mavis Tire goes SANless with SIOS DataKeeper

  With DBAs rewarded for server performance and SAN specialists rewarded for server capacity, there can be a tug of war. Mavis Tire goes SANless with SIOS DataKeeper. SIOS Technology releases a survey about high availability and SAN. Continue Reading

• The dark side of Microsoft SQL Server Express

  Don Jones explains why Microsoft SQL Server Express can be more dangerous than you'd think and why it might be worth it to invest in the paid edition. Continue Reading

Product Reviews

• Gives us the real monitoring and alerting we need to monitor our database ecosystem from one tool

  Powered by IT Central Station

  Valuable Features: Real-time monitoring we can quickly find the session or queries that are causing issues. • Improvements to My...Continue Reading

  Rating:

• Very useful for infrastructure related tasks. Great real time performance tuning of SQL queries.

  Powered by IT Central Station

  Valuable Features: Overall monitoring of Oracle databases and operating systems. Real time performance tuning of SQL queries. • Improvements...Continue Reading

  Rating:

• We have found that OEM has improved significantly the monitoring and tuning of our databases

  Powered by IT Central Station

  Valuable Features: Monitoring and tuning of Oracle databases. • Improvements to My Organization: It has improved significantly...Continue Reading

  Rating:

Manage Microsoft SQL Server Performance Monitoring and Tuning

Learn to apply best practices and optimize your operations.

• Built-in tools troubleshoot SQL Server memory usage

  Having enough memory is critical to SQL Server's performance. To ensure optimum SQL Server performance, you need to monitor SQL Server memory usage regularly. This article describes built-in tools that can make the job easier. Continue Reading

• When it comes to database security, beware lazy developers

  Don Jones discusses how database developers are taking the easy road for database security and going with the lowest common denominator instead of taking into account the unique security of each database platform. 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