OK then, which Perfmon Counter will tell me the Stalls ?

Any comparable ones. What I am trying to determine is what times of the day does the TempDB...

See, what I am trying to get is, the DBs that I have been asked to fine tune are going to TempDB quite a bit.

And the TempDB is located on...

I inherited some DBs and was asked to find Queries That are Slow and Fine Tune them.

I do run the CPU and IO Intensive Query off of DMVs.

But it is...

Thanks again Gila.

Yes your blog post might make me break thru the boundary wall I was so looking for.

I did a search myself -- did not find it. Was...

Thanks Gila.

Will use this to dig it out.

Sorry, I should have been a little bit more explicit in my question

I do not know which query uses which index to run the execution plan.

I know there is

Index1...

Actually they do vanish

This is what BOL says

The counters are initialized to empty whenever the SQL Server (MSSQLSERVER) service is started. In addition, whenever a database is detached...

Good Point Gila.

Now if I detach and reattach the DB -- do you think the rows -- in the DMV/DMF sys.dm_db_index_usage_stats will vanish ?

Column3 is part of NC Index -- hence rightfully gets incremented.

Technicalities aside -- Clustered Index is a seperate entity and hence its count should not increase (IMO).

Putting another simple question...

But why would the count for Clustered Index increase by 1 if I update a NC index?

As usual you make sense Gail.

In my opinion it is misleading. Mind you this is the very number that led me to think that Clustered Index was...

You are correct I think Gail.

Nicely explained.

Thanks makes sense.

I guess the short answer would be -- IT DEPENDS 🙂

Depends on the number of clustsred index values getting updated. But it definitely does make the NC...

No I am not talking about Rebuilding. What I am talking about is say a column SSN has a clustered Index on it, And I change the SSN (update...

I got the answer, it is a Yes :hehe:

For more information

http://msdn.microsoft.com/en-us/library/ms187016.aspx