I'm very excited about the new Management Data Warehouse coming in SQL Server 2008 (which was called

These existing SQL2005 tools are fine and useful. But one problem with them is that they are not a coherent bunch of tools--they are rather ad hoc, developed by different people, coming from different directions, targeting slightly differnt problems, and not systematically related to each other. In this respect, the SQL Server community can learn a lot from Oracle 10s' Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM). I'm not here to promote Oracle, but it would be a mistake not to learn from others' experience. These Oracle tools have been around for about 5 years, and have accumulated quite a bit of community experience. We can gain a lot from their experience--good, bad, and ugly.

I have not had a chance to study SQL2008 Management Data Warehouse in any depth, so I can't comment on where it is compared to Oracle 10g/11g. If anybody knows, I'd very much like to hear.

Link Listing - May 19, 2008

ASP.NET Integrated social networking in ASP.NET [Via: 100muses ] Sharepoint When to dispose of objects...

Hi Kalen,

I would add PAL which I've used a few times recently. Not a Silver Bullet but helps out when u get a little bogged down in a Perfmon.

Takes a perfmon and performs analysis / recommedations based on rule of thumb for various workloads (ie SQL Server / Exchange / Web etc)

http://www.codeplex.com/PAL

cheers,

Andy.