Performance Tuning - Category Archive
The following is a list of all entries from the Performance Tuning category.
Help Design a New SQL Server Monitoring Tool
DBA Career, Database Administration, Database Maintenance, Performance Tuning | September 3, 2009 | 9:25 amIn an experiment in SQL Server community involvement, the members of Red Gate Software’s software development usability team have created a new website called www.thefutureofmonitoring.com. This team, among other teams at Red Gate Software, are working Version 2 of its popular SQL Response software.
The goal of the new website is to get your input on ...read more
SQL Server 2008: Performance Data Collector
Performance Tuning | August 8, 2009 | 3:23 amSQL Server 2008’s Performance Data Collector lets us create a central repository to store performance data and includes three built-in Data Collection sets that can be used to collect and store this data. Three built-in reports can then be used to access the stored data, so we can identify and troubleshoot SQL Server performance problems. ...read more
Reasons Why You May Not Want to Use a Heap
Indexing, Performance Tuning | February 27, 2009 | 4:41 pmI have started compiling a list of reasons why heaps aren’t usually a good choice when designing a database. Now, I didn’t say that heaps are always bad, but in most cases, I think they should be avoided (read the list to see why).
As I compiled the list, in some cases I have had the ...read more
Check Out the Free Performance Analysis of Logs (PAL) Tool
Database Maintenance, Performance Tuning | December 23, 2008 | 4:23 pmTraditionally, analyzing Performance Monitor data has not been an easy task. It often involved viewing Performance Monitor logs in graph view, seeing what was happening, and hoping that your knowledge and background in SQL Server and the Windows OS provided you with enough information in order to help you to be able to pinpoint specific ...read more
How to Script a Profiler Trace for Use as a SQL Trace Data Collection Set for the SQL Server 2008 Performance Data Collector
Database Maintenance, Performance Tuning | September 25, 2008 | 4:53 pmIn SQL Server 2008, a new feature called the Performance Data Collector was added. It has the ability to collect SQL Server-related performance data, store it in a database called the Management Data Warehouse, and then produce various performance reports based on the collected data.
By default, the Performance Data Collector includes three different data collection ...read more
Twitter
Linked In