While fixing SQL Server configuration I ran into some rather interseting/unique errors: Server local connection provider failed to listen on [ \\.\pipe\sql\query ]. Error: 0x50
Month: May 2010
Listing blocking chain by tasks
References: #20
Windows Internal Database
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
SQL Canada (SQLCAN) 