Troubleshooting Performance Problems in SQL Server 2008
There is a new withe paper on SQL Server 2008 performance troubleshooting and covers the following in depth:
- CPU Bottlenecks
- Memory Bottlenecks
- I/O Bottlenecks
- Slow-Running Queries
- Extended Events
- Data Collector and the MDW
Download from the Microsoft Download Center: http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/TShootPerfProbs2008.docx
CU tosc
| Print article | This entry was posted by tosc on 2009-04-21 at 08:52:41 . Follow any responses to this post through RSS 2.0. |
-
-
backup «best practices» books bug configuration ctp «cumulative update» demo denali dmv ebook humor index indexoptimize integrity kbfix maintenance «ms sql server 2008» performance php reviews «service pack» «service pack 2» «service packs» sharepoint «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack t-sql «technical note» tempdb tools whitepapers
Tag cloud
backup «best practices» books bug configuration ctp «cumulative update» datetime demo denali dmv ebook humor index indexoptimize integrity kbfix loginproperty maintenance «ms sql server 2008» performance php profiler «reporting services» reviews «service pack» «service pack 2» «service packs» sharepoint «sql 2012» «sql pass» «sql server» «sql server 2005» «sql server 2008 r2» «sql server 2012» «sql server 2014» sqlcat sqlpass «sqlpass franken» ssms ssmstoolspack sysadmin «system views» t-sql «technical note» tempdb tools troubleshooting upgrade whitepapers