NJ-DBA (7/26/2012)

---

Jeff Moden (7/25/2012)

---

NJ-DBA (7/25/2012)

---

Please excuse the double post for very similar question- I think I was on the wrong track with my previous post and want to pose a...

NJ-DBA (7/25/2012)

---

Vikrant S Patil (7/25/2012)

---

As A.J. suggested have you ruled out index fragmentation by running a DMV query ( even though the table has not changed as per your feedback)...

Jeff Moden (7/25/2012)

---

NJ-DBA (7/25/2012)

---

Please excuse the double post for very similar question- I think I was on the wrong track with my previous post and want to pose a more...

Vikrant S Patil (7/25/2012)

---

As A.J. suggested have you ruled out index fragmentation by running a DMV query ( even though the table has not changed as per your feedback) ...

Thanks for this valuable input. If I were free to include...

Definitely not a plan issue- it's reusing the same plan over time. Table is not changing.

It runs in a loop from a connection that remains open and...

Gail- I dont suppose you know where I could find detailed information about the differences in how the query processor treats dbs in 8.0 compatability- besides the syntax related differences?

SQLKnowItAll (6/27/2012)

---

Personally, I think the main benefit is that the compatibility will disappear and you need to make sure that your code can run on new versions. It is the...

NJ-DBA (6/27/2012)

---

I've used the blocked processes trace in the past. You can use it without other events being traced. The load is dependent upon how many events you...

I've used the blocked processes trace in the past. You can use it without other events being traced. The load is dependent upon how many events you are...

I guess the only way to do this is to add multiple daily subscriptions which run at X hour, so for 8-5, I would have 1 subscription that runs daily...

If anyone else is encountering this issue, I resolved the problem by reloading the perf counters as described here:

http://blogs.msdn.com/b/psssql/archive/2009/03/03/troubleshooting-sql-server-2005-2008-performance-counter-collection-problems.aspx

Some additinoal info:

this is a 2008 R2 single node cluster. it previously hosted a SQL 2000 cluster. when I raiserrror, the event log show a problem decoding errors...

Why would operators or email profiles have...

The errors appear in the errorlog, but the alert does not get fired.