The more I work with Microsoft the I am in awe of the many resources that are available if you just know where to look. My company Ntirety is very lucky to have a wonderful relationship with the Northeast Microsoft office. When we are not sure what is availble to us, we have a team of people who can help us. Not everyone is so lucky.
This latest white paper is a great example. Here is a white paper on how to troubleshoot Performance problems in SQL Server 2008. Its a great database and this paper will go a long way to help you better understand how to make it perform toits full capabilites.
Say good bye to performance issues in SQL Server 2008 with the aid of this whitepaper…
A new white paper on SQL Server 2008 performance troubleshooting is now available and linked from our Technical Articles node in the MSDN Library. This paper is about 100 pages and covers the following in depth:
- CPU Bottlenecks
- Memory Bottlenecks
- I/O Bottlenecks
- Slow-Running Queries
- Extended Events
- Data Collector and the MDW
You can find the paper at: