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

• Oracle GoldenGate vs. Oracle Active Dataguard

  Powered by IT Central Station

  As an Oracle DBA, while working upon high availability of your database you may come across various Oracle strategic capabilities that fall into...Continue Reading

  Rating:

• It's our primary means of publishing data models, but it needs to use more modern standard dialogs.

  Powered by IT Central Station

  Valuable Features: Flexible and complete compare/merge facility Exposure of its automation object model which allows custom programming outside...Continue Reading

  Rating:

• We can run macros on logical and physical model, but registration always seemed difficult and time consuming.

  Powered by IT Central Station

  Valuable Features: Running macros on logical and physical models Compare and Merge • Improvements to My Organization: I am able to...Continue Reading

  Rating:

Manage Microsoft SQL Server Performance Monitoring and Tuning

Learn to apply best practices and optimize your operations.

• Built-in tools for monitoring and optimizing OLAP cubes

  Optimizing online analytical processing performance is critical. Fortunately, tools are available to help monitor and improve how OLAP cubes perform. Continue Reading

• 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