SQL Server Performance

The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SQL Server 2005 SP2 release of SQL Server Management Studio. The reports allow a database administrator...

SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. I will first describe the old functionality to give some context and demonstrate how the new features help a lot. Please...

Len posted recently the link to the new Analysis Services performance guide. If you also care about SQL Server engine performance, these two papers are worth a quick read: Troubleshooting Performance Problems in SQL Server 2005 , which takes you...

SQL Server 2005 Service Pack 2 has been released. You can find more information from the service pack 2 page . This service pack extends the functionality of SQL Server in many ways. The What's New document highlights the major changes in the Database...

SQL Server does a great job of optimizing processing across a wide range of runtime scenarios, while also providing a flexible configuration and execution environment. One of the tradeoffs associated with this level of flexibility is that different configurations...

Why did we only use the MOLAP storage mode in Project REAL? There is also ROLAP and HOLAP storage, but they weren’t used at all. Also, why doesn’t Project REAL illustrate pro-active caching? The Analysis Services 2005 Performance Guide contains...

Introduction As we started Project REAL , we were fortunate to be able to use multiple machines and SAN devices to test different configurations. At the same time, this presented a challenge in that we needed to keep track of what information was on...

Do you want to know how to get the best performance out of Analysis Services? Whether you have an immediate performance issue or just want to know more about what’s going on in there, this guide will be a valuable resource. Many people used the...

We are conducting a survey to better understand SQL Server workloads. Please consider providing your workload characteristics and hardware configuration to help us better understand the workloads that run on SQL Server. This is a detailed survey...

Welcome to the new bloggy home of Microsoft’s small but mighty SQL Performance Team! Lots of smart folks on the SQL team work on performance, as some part of their job. We do it every waking moment. We live and breathe performance & scalability, across...