I haven’t ran into this much, as it seems it is optional component that can be installed when configuring Microsoft Windows. The reason I say
Multi-path I/O (MPIO) does not work for disk with identifier … on node …
How to configure MPIO in Windows 2008 Cluster
Getting file usage stats
You can use this DMV to see what SQL Server thinks about the I/O stall times. I don’t rely on it 100% but it helpful
Queries execute slow what is the issue?
This is a very loaded question, there is no simple answer. But few things to make sure before you go crazy on PTO, make sure
Cannot Administrator SQL Server 2008 Reporting Services on Windows 2008 R2
http://technet.microsoft.com/en-us/library/cc512639.aspxI just finished installing SQL Server 2008 Reporting Services on Windows 2008 Server R2. After all the settings were configured in Report Configuration Manager. I
CREATE FILE encountered operating system error 5(Access is denied.)
Operating System Error 5 while Attaching/Creating Database
SQL Canada (SQLCAN) 