Helpful info on SQL Server Diagnostics: Part II
Note: This blog post is from 2008. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.Last week I pointed out a useful blog entry on SQL Server troubleshooting. Now there's a Part II, which addresses such things as:
- Are there SQL batches that actually run for a long time?
- Is there blocking in the database?
- Are there any problems in the configuration options of SQL Server?
- Is there a disk IO problem?
- Are there any indications of memory problems?
Good stuff that even we CFers can benefit understanding. Again, while it's from a Microsoft support engineer who focuses on .NET debugging in her blog, there's really nothing about this blog entry or the last that's .NET specific.
There are no comments for this entry.
[Add Comment]