[Looking for Charlie's main web site?]

Helpful info on SQL Server Diagnostics

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.
Here's a useful blog entry, "What if I suspect that my performance problem is in SQL server?". It's easy to blame CF for performance problems, but sometimes the problem is in the database--and it could be configuration, or database setup, all in addition to your own (or someone else's) SQL coding.

The entry focuses on using the tools known variously as PSSDIAG and SQLDIAG, either built-into SQL Server 2005 or available for free download for older editions, and it does a nice job of walking through it in a friendly way, with screenshots and more.

The entry is on the blog of Tess, a Microsoft support engineer, called If broken it is, fix it you should. While the majority of her entries are on .NET, this was a guest blog entry with a SQL Server support engineer. Despite her blog being mostly about .NET, there are occasional gems like this which are of equal value to CFers.

For more content like this from Charlie Arehart: Need more help with problems?
  • If you may prefer direct help, rather than digging around here/elsewhere or via comments, he can help via his online consulting services
  • See that page for more on how he can help a) over the web, safely and securely, b) usually very quickly, c) teaching you along the way, and d) with satisfaction guaranteed
Related Blog Entries

Copyright ©2024 Charlie Arehart
Carehart Logo
BlogCFC was created by Raymond Camden. This blog is running version 5.005.
(Want to validate the html in this page?)

Managed Hosting Services provided by
Managed Dedicated Hosting