How can SQL Server 2005 help me evaluate and manage indexes?

re: How can SQL Server 2005 help me evaluate and manage indexes?

Terry Grignon — Mon, 19 Dec 2005 19:21:16 GMT

I think this is a very useful article. Thanks for posting it (although I agree with Paul that the font is a little odd).

The 3 report and other examples mentioned in item 4 after "the average block time is 15.7 seconds." are completely blank with my version of IE. Did anyone else notice this?

re: How can SQL Server 2005 help me evaluate and manage indexes?

Terry H — Wed, 28 Dec 2005 19:43:59 GMT

Very useful article. I wish more developers knew how to evaluate index usefulness. I administer some databases created by software that include indexes on bit value columns ...

I cannot see the items that Terry Grigon reported missing either ... tried IE, Netscape, Firefox, and Opera. Perhaps they are not there?

re: How can SQL Server 2005 help me evaluate and manage indexes?

Dis4ea — Tue, 14 Feb 2006 15:05:53 GMT

This is a great article! Keep posts like this coming ;-)

I too see indexes on completely useless fields but the problem is that sometimes indexes may seem usefull but in reality they might be unused. This is very hard to capture in SQL Server 2000. The new DMV's make this a very easy job.

re: How can SQL Server 2005 help me evaluate and manage indexes?

MikeI — Wed, 15 Mar 2006 00:02:32 GMT

Good article .. same problem .. cannot see the graphics ..

re: How can SQL Server 2005 help me evaluate and manage indexes?

PP — Mon, 29 May 2006 22:44:34 GMT

Very nice article; I wish article(s) like these are directly linked from SQL BOL.

re: How can SQL Server 2005 help me evaluate and manage indexes?

SQL MInds — Mon, 11 Dec 2006 07:36:25 GMT

Would you like to know more about what the inner workings of your MS SQL Server 2005 box?

There are a 50+ reports. Some of them address basic questions such as slowest queries, missing indexes, and most expensive queries (Note: while this information is basic, it is still NOT available in the other software packages on the market, who are claiming to “monitor”, “optimize” and “tune” MS SQL database deployments.)The software also provides variety of other information via its UI such as hardware configuration, NUMA node presence, scheduling details, low level session information, database objects storage and usage details, etc.

www.sqlminds.com

re: How can SQL Server 2005 help me evaluate and manage indexes?

bendover — Thu, 28 Dec 2006 03:59:13 GMT

SQL Minds, out of North Carolina, is claiming many things, but not admitting their relaltionship to a STOCK SCAM called Vision Technology Corp. Plamen Slavov (Product Manager) is a realtor from Florida, not an SQL guy, or even an IT guy.

Ivan Ivanov, CEO of SQL Minds is also the CTO and board member of Vision Technology Corp (VSTC), and is also the CEO of Data Consulting Group (SQL Minds one and only testimonial and the "beta" customer announced by VSTC.. meaning they are beta'ing their own stuff) THIS IS A SCAM. Read all about it here

http://gtxcthegangthatcantshootstraight.blogspot.com/

cites, facts, research, analysis.. over 9 months of inside information. INVESTOR AND SQL COMMUNITY BEWARE. SQL Minds is a scam.

Analysing Indexes Part 1

Grumpy Old DBA — Thu, 12 Jul 2007 18:34:38 GMT

Actually what started as a small document has continued to grow. I'm working on performance tuning a

sys.dm_db_index_operational_stats

Louis Davidson — Mon, 27 Aug 2007 00:12:16 GMT

This object provides very useful stats on how many times an index has been used, locked, waited on, etc.

Joe Sack’s SQL Server Blog - Silver Bullet DMV - sys.dm_db_index_usage_stats

Joe Sack’s SQL Server Blog - Silver Bullet DMV - sys.dm_db_index_usage_stats — Wed, 26 Dec 2007 01:35:12 GMT

PingBack from http://joesack.com/WordPress/?p=96

Index et Optimisation - Page 2 | hilpers

Index et Optimisation - Page 2 | hilpers — Thu, 22 Jan 2009 18:30:21 GMT

PingBack from http://www.hilpers.fr/918538-index-et-optimisation/2