also check you history on your select page this will give you the number of occurrences that have actually happen

did you check in the error log in order to make sure an alert was written to the the log? looks like your setting are right.

I am assuming you...

Not sure what you are looking for, Did you run a DMV that shows you that you are need indexes and now you want to find the SP or...

ok you have a couple of choices.

The index on B1, this is not needed, these should be picked up using the clustered index if you search on status,accountno then the...

Umar is correct check the target and total memory then add page life expectancy.....should be around 5000 sec.

This the amount of time a page stays in memory, if you are...

we need some more information, do mean you want to create 3 separate indexes.

col a

col b

col c

or

a composite index on a,b,c?

if its a,b,c always put the most...

Thanks Grant!

I will make sure to use the missing index as a starting point...sounds like I need to track down the Statements that are causing the missing indexes to show...

you will need third party tool for that idera, quest, ......

FYI if anyone needs to know this link will help

http://searchsqlserver.techtarget.com/news/article/0,289142,sid87_gci1102099,00.html

there is not much help on this out there. but its a good way to give developers a place to play...

hard to tell, we need the qry plan. The engine should run one then run the 2 sec one then add them together.

by the way good article Gail ....thanks

here are both plans..hope it helps

I found the problem...thanks folks

As I was getting ready to post the table info I noticed the both the inner and outer tables are both heaps. Both have unique non-cluster...

Doubled checked that...but no luck although the table is a heap the it has a PK and a (unique) non clustered index on the PK...my only thought is the sort...

Please try SQL TUNNING.....one of the best books I have read....and I have read all of the above mentioned whch are very good as well.

The Book describes how to...