Browse by Tags

Performance Dashboard for SQL 2008

Just in case you haven't seen this http://sqlblogcasts.com/blogs/thepremiers/archive/2008/06/20/sql-server-2008-performance-studio.aspx then have a read. As I actually create dashboards and performance reporting for sql 2000 and sql 2008, and have been for many years, I'm seeing some of my work...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-23-2008
Disappointing Review.

It's not very often I'm provoked into making a criticism of a respected publication, however there's nothing like being grumpy! I've published a number of posts about baselines, trending and performance analysis and I've been quick to remark when published examples don't really...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 04-17-2008
Bug in UK SSUG 2008

It was discovered earlier today that SSUG 2008 was unable to distinguish a Thursday when it fell before a bank holiday friday and as a consequence SSUG would be unable to function on March 20th. It's not thought that other Thursdays that fall before a Friday bank holiday will cause similar problems,...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-19-2008
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 work on the analysis of the operational stats and...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 02-18-2008
Custom Reports for the DBA without SSRS

Creating Custom Reports for the DBA ( You can find this and other information at http://www.grumpyolddba.co.uk/ ) 1. You don’t need SQL Server Reporting Services to do this 2. You don’t need IIS installed 3. You do need SQL Server 2005 Service Pack 2 on your client tools e.g. management studio 4. You...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 02-12-2008
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
Perfmon Counters thresholds

Just in case you missed the link to The Premier's blog http://sqlblogcasts.com/blogs/thepremiers/archive/2008/01/23/monitoring-sql-server-using-performance-monitor.aspx they've just posted details of a perfmon trace viewer. But what is more important is the attached documentation on perfmon counters...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-24-2008
Creating a baseline for P & O part 3

The most important part of performance tuning is to be able to establish a baseline. Without a baseline and on-going statistics and trending information you just cannot make informed judgements concerning performance degredation or improvement or on future growth. The three parts presented here allow...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 11-28-2006
Creating Baselines for P & O part 2

The most important part of performance tuning is to be able to establish a baseline. Without a baseline and on-going statistics and trending information you just cannot make informed judgements concerning performance degredation or improvement or on future growth. I have three standard sets of data I...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 11-28-2006
Creating Baselines for P & O

The most important part of performance tuning is to be able to establish a baseline. Without a baseline and on-going statistics and trending information you just cannot make informed judgements concerning performance degredation or improvement or on future growth. I have three standard sets of data I...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 11-24-2006

Page 1 of 1 (10 items)