New & Notable
Microsoft SQL Server Performance Monitoring and Tuning News
March 14, 2012
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
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.
May 19, 2011
Maintaining a SQL Server business intelligence (BI) system may be challenging for many database administrators, but there’s a lot you can do to ensure top SQL Server BI performance.
April 07, 2011
There’s been a slew of new Microsoft products lately, including an upgrade for Project Atlanta. A company expert discusses this development, third-party tools and more.
Microsoft SQL Server Performance Monitoring and Tuning Get Started
Bring yourself up to speed with our introductory content
Microsoft has released guidelines for a hardware-software configuration that maximizes SQL Server 2012 performance. Learn about what it entails. Continue Reading
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
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.
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
In this expert answer, Michael Steineke from Edgenet talks about what to consider when deploying In-memory OLTP in SQL Server 2014. Continue Reading
IntelliSense in SSMS is Microsoft’s answer to developer pleas. But there is competition from a third-party tool for SQL Server -- SQL Prompt. Continue Reading
Manage Microsoft SQL Server Performance Monitoring and Tuning
Learn to apply best practices and optimize your operations.
Basit Farooq provides five tips for SQL Server users, from avoiding a hardware performance bottleneck to dealing with database design. Continue Reading
Probably the biggest feature of the upcoming release, SQL Server 2014 in-memory OLTP has benefits that DBAs should know about. Learn how to set it up. Continue Reading
Of course SQL Server database size matters, but there are steps DBAs and IT managers can take to mitigate growing data and maintain good performance. 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.
Basit Farooq presents his top three SQL Server third-party tools for identifying and resolving SQL Server bottlenecks. Continue Reading
Being a SQL Server DBA means you have a lot on your plate. Find out six of the most important DBA responsibilities you should be doing every day. Continue Reading
Learn how to implement and configure contained databases in SQL Server 2012. Continue Reading