Azure Data Factory: Hub Not Found

You can use the new Azure portal to create or edit Azure Data Factory components. Once you are done you may automate the process of creating future Data Factory components from PowerShell. In that case you can use the JSON files you edited in the portal GUI as configuration files for the PowerShell cmdlets. ForContinue reading “Azure Data Factory: Hub Not Found”

Data Gathering – SQL Server Setup Problems

Data Gathering – SQL Server Setup Problems Cindy Gross, Dedicated Support Engineer   Gathering the right data during a problem can get you a long ways towards resolving the problem. When you ask the right questions and clearly define the problem it changes the way you approach the remaining steps. Sometimes the answer to aContinue reading “Data Gathering – SQL Server Setup Problems”

Windows storport enhancement to help troubleshoot IO issues

For Windows 2008 and Windows 2008 R2 you can download a Windows storport enhancement (packaged as a hotfix). This enhancement can lead to faster root cause analysis for slow IO issues. Once you apply this Windows hotfix you can use Event Tracing for Windows (ETW) via perfmon or xperf to capture more detailed IO informationContinue reading “Windows storport enhancement to help troubleshoot IO issues”

SQL Server Performance Tools – Boise Code Camp Presentation

Today I am presenting about SQL Server Performance Tools at the Boise Code Camp. You can download the slides and supporting files here on this blog (at the bottom it says Attachment(s): PerformanceTools.zip ). The basic agenda of items covered is:   ¢  Methodology ¢  SQLDiag ¢  PSSDiag ¢  SQLNexus ¢  Profiler ¢  PerfMon ¢ Continue reading “SQL Server Performance Tools – Boise Code Camp Presentation”

What do those “IO requests taking longer than 15 seconds” messages on my SQL box mean?

You may be sometimes seeing stuck/stalled IO messages on one or more of your SQL Server boxes. This is something it is important to understand so I am providing some background information on it.   Here is the message you may see in the SQL error log: SQL Server has encountered xxx occurrence(s) of IOContinue reading “What do those “IO requests taking longer than 15 seconds” messages on my SQL box mean?”

Professional SQL Server 2008 Internals and Troubleshooting

Our new book, Professional SQL Server 2008 Internals and Troubleshooting, will be shipping soon! Order now! 🙂 Christian Bolton, Justin Langford, Brent Ozar, and James Rowland-Jones have each written several chapters in this book. Steven Wort, Jonathan Kehayias and I each contributed a chapter as well. The 1st half of the book introduces you to how thingsContinue reading “Professional SQL Server 2008 Internals and Troubleshooting”