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
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
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

Page 1 of 1 (3 items)

SQL Server Community Blogs