"Working with SQL Server 2008 and I cannot find Activity Monitor. It appears to have gone missing."

No wonder if you were asking this and landed on this page. When you begin working with SQl 2008, you may find yourself searching for Activity Monitor. I spent few minutes searching for Activity Monitor. Luckily, I manage to find it somehow.

Report processing engine of Reporting Services 2008 works significantly different compared to previous releases. One of the important architectural changes in SSRS 2008 is on demand processing behaviour of the service engine.

What is on demand processing?

Earlier versions of reporting services, i.e. 2000 and 2005 processing engine processed the report as a snapshot, evaluating all expressions exactly once.

Microsoft SQL 2005 came up with lot of features supporting requirements of business intelligence and data warehousing technologies. Brief note on some of the components of Microsoft BI suite.

What is Business Intelligence?

Business intelligence is a method of storing and presenting key enterprise data so that anyone in your company can quickly and easily ask questions of accurate and timely data. Effective BI allows end users to use data to understand why your business go the particular results that it did, to decide on courses of action based on past data, and to accurately forecast future results.