Marios, what version of SQL Sentry are you using? With 6.x you should certainly be able to dig deeper into the individual queries where IO_Completion is high - for example...

Usually you should avoid going backwards when at all possible. One issue you may come across is if you apply SP2, enable 15K partitions, then try to move that...

Full disclosure: I work for SQL Sentry. I couldn't pass up the opportunity to work for a company whose products I believed so strongly in, and whose people I've...

I was actually suggesting that the DTA might have created some indexes you do not need. You need to be very careful about the recommendations it makes and ensure...

So what are the other 14 rows in sysindexes? Did you ever run the index tuning wizard against this database?

Is it possible this table has 19 indexes?

Assuming there are rows in the table, this should show each stat for the table:

SELECT name, *

FROM sysindexes AS i

WHERE i.id = OBJECT_ID('mytable')

AND [first] IS NULL;

How many rows...

Happy to help. Sadly it's not going to help the OP using 2000. 🙁

Ad hoc batches in 2000, IIRC, are inspected differently. They actually inspect the entire query batch, and it is case and white space sensitive as well. Since your...

Also CU 10 for RTM incorrectly has SP1 as the label.

This is clever and a little more flexible than some of the other techniques - and useful if all you need to do is return the output directly to the...

Phil Factor (1/25/2010)

---

For quickly finding database object according to their category, use, or object type, you might find the extended properties invaluable, especially if you use the sys.extended_properties catalog view....

You will need to classify based on the job name, and no you cannot customize what appears under APP_NAME() - I thought I filed a Connect item for this but...

sp_reset_connection will trigger re-classification.

At least that's what this blog post seems to imply (I haven't tested it):

http://blogs.msdn.com/psssql/archive/2009/02/23/how-it-works-resource-governor-internal-group.aspx

You can't use DB_NAME() in the classifier function, since classification happens after login but NOT before assigning database (or determining default), user options, etc. As a workaround you could...