SQL Server Performance

News

These postings are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/ info/cpyright.htm.

Performance

SQL Server Document Links

SQL Server Team Blogs

Browse by Tags

All Tags » SQL Server 2005 (RSS)

What's swimming in your bufferpool?

When doing a performance investigation a useful thing to do is look at what data is present in the buffer pool. This can be used to analyze impact of running a query on the state of data pages in buffer pool. By collecting the pre and post picture of Read More...

Posted: Friday, May 18, 2007 10:19 AM by Data & SQL Storage Performance Team | 3 Comments

Filed under: SQLOS DMVs, SQL Server Performance, SQL Server 2005

OBJECT_NAME enhancement and OBJECT_SCHEMA_NAME addition in SQL Server 2005 SP2

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 Read More...

Posted: Friday, March 23, 2007 4:23 PM by Data & SQL Storage Performance Team | 0 Comments

Filed under: Troubleshooting, SQL Server 2005

Two handy papers on common database performance considerations

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 through Read More...

Posted: Friday, March 23, 2007 9:51 AM by Data & SQL Storage Performance Team | 0 Comments

Filed under: Troubleshooting, SQL Server Performance, SQL Server 2005