Troubleshooting Physical Server Performance

When troubleshooting the performance of your physical server, you are going to be relying more on your operating system and hardware knowledge than on your SQL Server 2005 knowledge. That's why we have always tried to keep abreast of at least the basics of every version of the Windows operating system as it has been released. The same goes for hardware.

In most enterprises, a DBA will typically pass on operating system– and networking-related tasks and problems to specialized infrastructure information technology (IT) professionals, but the DBA still needs to be conversant with operating systems and networking at some level. Troubleshooting a physical server's performance where SQL Server 2005 is installed ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.