Infrastructure
This area is about all those other things a DBA should consider when managing a SQL Server. Topics here will include storage, raid, SANs, Operating Systems, memory, cpu's and so on. It's very important to realise that the performance of a database application may be affected by many external factors, such as a switch being set to half duplex. This will explore the wonderful world of infrastructure.
- Dude where's my disk space?
- NTFS Fragmentation for the DBA
- HP Lights Out Storage Bug
- Windows Services
- Windows file copy bug
- Benchmark tests
- Approach to SAN Contention
There may be more free space than you think on that disk or lun.
Fragmentation degrades performance
Storage bug which affect SQL Server, esp x64.
Do you really need all those services? Probably not!.
This bug can cause the working set for SQL to be paged out - not good..
Details of tests that can be used to benchmark the storage performance for SQL Server.
One of the most denied aspects of a SAN, what is it and an approach to find it.