Browse by Tags

All Tags » Indexes (RSS)
10 June 2008 20:30

Tracking problem indexes in SQL 2000

It’s all so easy(ish) to work within SQL 2005 but the reality is that there are still more SQL 2000 databases than SQL 2005, so I’m told, and I’m supporting one of them right now. I’ve been contemplating on how to get a handle on which of my indexes are...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
26 May 2008 15:07

Covering Clustered Indexes

I’ve noticed that of late I’ve become a bit more critical of a well known publication that I suspect many DBA’s read. I have subscriptions to a number of publications and for the ones that I pay for I’m generally quite content. I like paper / hard copy...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: ,
18 February 2008 19:53

Analysing Indexes Summary

· I’ve put the work I’ve done on using the dmvs to analyse indexes onto my web site – the links to the pages are underneath. Trying to post large documents to the blog is very difficult, and probably not what a blog was intended for! · I need to do more...
Posted by GrumpyOldDBA | 3 comment(s)
Filed under: ,
22 October 2007 20:54

sys.dm_db_index_physical_stats

It seems my comments in my SQLBits presentation about dropping sys.dm_db_index_physical_stats into a table valued function so it can be used within queries caught the eye of an important person. Now I'd not really given much thought to what I did, I was...
Posted by GrumpyOldDBA | 3 comment(s)
Filed under: ,
27 September 2007 08:19

Analysing Indexes Part 4 - Size does matter - 3

11. dropping the clustered index shows all secondary indexes at + 9 bytes ( integer index replaced with guid index ) Index id index_typec Index depth Index level Page count Record count avg_record size_in bytes 0 HEAP 1 0 153847 2000000 579 datetime 2...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
27 September 2007 08:17

Analysing Indexes Part 4 - Size does matter -2

4. Replacing the clustered Primary Key with a non clustered Primary Key on the integer column gives us two secondary indexes, each entry being + 9 bytes The primary key is index 3 Index id index_typec Index depth Index level Page count Record count avg_record...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
27 September 2007 08:12

Analysing Indexes Part 4 - Size does matter

( can't post this in one go so it's going to be a few parts ) v I’ll say now that this is a whole lot of figures and values, I’ve attempted to summarize what I can at the end of the article; for those who want to cut to the chase. o ( The naming used...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
13 September 2007 10:14

Analysing Indexes at SQLBits

Seems I've been selected to present at SQLBits on my work on Index Analysis. So a thankyou for those who voted for my presentation. I just noticed this post http://blogs.msdn.com/sqlcat/archive/2007/09/12/sqlcat-tracks-at-2007-sql-pass.aspx?CommentPosted...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
22 July 2007 22:38

Analysing Indexes Part 2

Here's the next instalment, expect there to at least another two or three. I’m still only working with basic indexing No partitioning I’m not looking at xml indexes. 14.0 Collecting Raw Index usage data Collects table name, index name , reads and writes...
Posted by GrumpyOldDBA | 3 comment(s)
Filed under: , ,
12 July 2007 16:17

Analysing Indexes Part 1

Actually what started as a small document has continued to grow. I'm working on performance tuning a well known application and as I document as I work so others can follow what I'm doing I thought I'd add it to my blog. There's nothing particularly startling...
Posted by GrumpyOldDBA | 3 comment(s)
Filed under: ,