Hi Toby,

I would hope the output from this utility is much easier to read and interpret, with consolidated results for a batch of SQL. Additionally, the ‘Actual Executing Plan’ option...

Hi Mathew,

The utility records all index activity on the database, not just that which belongs to the SQL you’re running.

So it might be better to schedule the utility to...

Hi Jonathan

Thanks for your question.

In a word... “simplicity!”

I wanted the code to be simple and understandable to a wide audience. Not everyone will be familiar with using XML and XQUERY,...

Hi Gregory,

Thanks for the updated routine. The derivation of the database from the plan attributes is very useful!

Thanks

Ian

Hi mishaluba

Yes, the columns represent an index with multiple columns, and the columns should be created in the order listed. The Column group ‘usage’ will inform you if the index...

Hi Paul,

Thanks for the information about the performance dashboard, its reports are very useful for tracking down a variety of performance problems. They work off the underlying DMVs, to explore...

Hi,

Typically the usecount represents the number of times the plan has run since it was last recompiled (maybe due to stats changing, environment variables changing, etc), or since the sql...

Hi Brian,

I think it is the same. For indexes you won’t see much difference other than it shows you what is missing from the all plans that have been run...

Hi,

The code in the article seems to run ok (just run it in myself). But the code in the resources section (perftips.sql ) has formatting errors!

Remember the routine only...

Hi,

I’m glad you liked the article, it’s quite interesting to see what is happening with SQL Server and SQL.

I hadn’t really thought about creating a view, I typically create utilities...

Hi,

from the feedback, I’m not sure if people have understood this article completely.

The article discusses how to identify queries that are running slower than normal i.e. ones that seem to...

Hi Andy,

Impedance is a measure of how slow the query is performing in terms of CPU usage, taking into account the amount of IO used. Sorting the results on Impedance...

Hi Jereme,

I agree with your thoughts completely. I think this article is a new and interesting look on a familiar problem. Unfortunately it has been let down by bad editing....

Hi Ray,

Thanks for your feedback.

About your caution… it should not be a problem here. This is because the utility is measuring at the individual SQL statement level, the active...

Hi,

For SQL Server 2000, you can use SQL Server Trace (that contains a Duration column) to determine what SQL is running slowly (this is different from this article, which is...