balasach82 (4/8/2014)

---

Awesome. A job ws running which was running the query. Thanks for pointing to the problem.

So, its 100% sure that an sp_execsql does not pass control untill the query...

There is no right answer for this. It's very subjective. Also, you'll not find any tool that monitors all those services equally well. Further, some of the best tools for...

Performance is most often related to the code or the structure. But, sometimes it can be other things. For example, do you have any process for maintaining statistics on your...

Extended Events can be used to audit just about anything... BUT, if you have 'sa' privs on the server, you can turn off ex events. If you absolutely have to...

Shrinking the file or the database is reclaiming space that was allocated in the database, but is not currently in use. Compression is taking a value and making it smaller...

Are you sure the log backups and the full/differential are from the same database on the same server? There has to be a log that overlaps with the LSN on...

You could try doing the insert into the new table without having the key in place and then apply the key after the data is loaded. In some situations you...

sys.dm_exec_requests will show the execution of the query and any waits that it's experiencing as well as any blocks.

I'd suggest looking at the combined execution plan. It might be different...

If you aren't using them, cleaning them up isn't going to hurt anything.

Is the book by Denny Cherry? If so, I'd take it's word as pretty near to gospel.

sdownen05 (4/4/2014)

---

Keith,

First, thanks for pointing me to the other scripts. I will definitely start using them instead.

As to your query, it shows that the table exists. However, when I do...

It's also not a question of web servers vs. something else. Query behavior is query behavior. Nothing all that special about queries coming from a web interface vs. queries coming...

I'd suggest using extended events for this. They're more light weight than trace events and their filtering is much, much better, so you'll only be capturing the data you want....

If you have the clustered index key value in the WHERE clause and you're still getting a scan, the suggestion is that you must have one of two situations, your...

That's one way, sure. I'd probably use extended events, or, on a 2008 system, trace....

But you can see an aggregation of the queries currently in cache in sys.dm_exec_query_stats. It shows execution times, counts, other stuff like that, but not who did the executing or...