Browse by Tags

All Tags » Code Tuning » Diagnostics (RSS)
28 July 2010 13:28

An interesting annecdote

A while ago I blogged about using the dmvs to identify lookups and scans on tables http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/19/analysing-indexes-reducing-scans.aspx Well continuing on from this I had discovered that two of the top scanning...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
23 March 2010 19:33

Cursors 1 Sets 0

I had an interesting experience with a database I essentially know nothing about. On the server is a database which stores session state, Microsoft provide the code/database with their dot net, so I'm told. Anyway this database has sat happily on...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , , ,
30 January 2008 19:18

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...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , , ,