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
Actual value was -1. (Microsoft.SqlServer.GridControl) Error when attaching database.
When attaching a database in SQL Server 2008, a user might get the following error. TITLE: Microsoft SQL Server Management Studio —————————— Cannot show requested
Performace Tuning Stored Procedures
I been performance tuning an OLTP system which is built with Visual Basic Front end, Microsoft Components middle tier and SQL Server back-end for DBMS.
SQL Canada (SQLCAN) 