Browse by Tags

All Tags » Diagnostics » Trending and Statistics (RSS)

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

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

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

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

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