Browse by Tags

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 working on the index analysis and tried to join...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 10-22-2007
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 where there is a value for reads or writes Collect...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 07-22-2007
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 in here but if you want to drill into index...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 07-12-2007

Page 1 of 1 (3 items)

SQL Server Community Blogs