Thanks Paul.

Agreed that this is not an optimal solution. But if I want to know where an error is, and quickly, this method does seem fastest for most IO related...

Hi Preet,

below is a version that uses only DMVs/DMFs, from section 5.9.1 of the book (http://www.amazon.com/SQL-Server-DMVs-Action-Management/dp/1935182730)

Thanks

Ian

SELECT

es.session_id, es.host_name, es.login_name

, er.status, DB_NAME(database_id) AS DatabaseName

, SUBSTRING (qt.text,(er.statement_start_offset/2) + 1,

((CASE WHEN er.statement_end_offset = -1

THEN...

Hi,

Your results suggest, for the passed parameters, only certain indexes are being used. I'm sorry I can't give a more detailed answer, but I don't know the specifics of system...

Hi,

I’m glad you liked the article. I’m wondering if the reason why the output doesn’t match the cached plan is because the plan contains information about all paths of execution....

Hi,

Nice article.

You can discover a lot more about DMVs in this forthcoming book http://www.manning.com/stirk. Chapter 1 can be downloaded for free and includes scripts for:

A simple monitor

Finding your...

Hi,

Nice article.

You can discover a lot more about DMVs in this forthcoming book http://www.manning.com/stirk. Chapter 1 can be downloaded for free and includes scripts for:

A simple monitor

Finding your...

Hi,

You might also want to look at “SQL Server DMVs in Action”, the first chapter is available free at: www.manning.com/stirk

Thanks

Ian

Hi,

Nice article.

You can discover a lot more about DMVs in this forthcoming book www.manning.com/stirk. Chapter 1 can be downloaded for free and includes scripts for:

A simple monitor

Finding your slowest queries

Find...

Hi Terry,

I think you've raised an important issue here. Sometimes, when we have planned the indexes, rather than blindly impliment the 'missing' index, we should revisit our query instead e.g....

Hi Jason,

I'm glad you liked the article.

There is an updated version of this script, without the deprecated objects, given in the book I am writing "SQL Server DMVs in...

Hi dbowlin,

Have a look at http://www.manning.com/stirk I'm working on a book containing about 100 sample scripts similar to the one in the article. You can download the first...

Hi,

What index does it say is missing? You should be able to see it's definition in the cached plan.

Thanks

Ian

Hi,

What is the error you're getting?

Do you have access to the DMVs? You need VIEW SERVER STATE permission.

Thanks

Ian

Hi,

please see a previous discussion entry by jacroberts, he has the relevant code to prevent the divide by zero error.

thanks

Ian

Hi,

yes the code uses sys.indexes, which is database specific, so it needs to run in each database separately.

Thanks

Ian