in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » Code Tuning (RSS)

Browse by Tags

  • Things I learned today

    I'm involved with some tuning as usually tends to be the case and amongst the work I've been doing a couple of interesting points arose. Firstly we upgraded the memory in the production cluster, what was unusual for me was that we added more memory than we had databases, I've never worked a production...
    Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-30-2008

  • 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

  • Maxdop hint for Views

    With the advent of multi core processors the issue of parallelism is likely to cause more problems than before – the usual posted answer on forums to resolve parallelism ( CXPACKET ) locks is to disable or severely restrict processors. I’m sure this is a discussion that could run and run but I’m not...
    Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-15-2007

  • Secondary Index Quick Fix

    Sometimes it is necessary to take a blanket approach to tuning when initially faced with a poorly performing production system, for example just adding lots of memory! The rationale behind this is that it is more risky to modify code than the database and or hardware and "quick fixes" are often the order...
    Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 10-05-2006
Page 1 of 1 (6 items)
Powered by Community Server (Commercial Edition), by Telligent Systems