Welcome to MSDN Blogs Sign in | Join | Help

SQL Server Performance

Best Practices, Tips, Benchmarks, Troubleshooting and Monitoring - SQL Server, ADO.NET, Analysis Services, and SSIS

March 2007 - Posts

New MSDN Books Online search functionality
Check out the new Books Online search functionality online. The link below provides a scoped search of Books Online that returns a more precise and targeted result set. You can use it to search Books Online content quickly. http://search.live.com/macros/sql_server_user_education/booksonline Read More...
Posted: Friday, March 30, 2007 11:52 AM by Data & SQL Storage Performance Team | 1 Comments
Filed under:
SQL Server 2005 Performance Dashboard Reports
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 Read More...
Posted: Thursday, March 29, 2007 12:23 PM by Data & SQL Storage Performance Team | 2 Comments
Filed under: ,
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: ,
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: , ,
Page view tracker