http://msdn.microsoft.com/en-us/library/hh226085.aspx
This white paper describes how operations engineers can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2.
As a sql server user we all are aware of Activity monitor.
But in SQL Server 2008 its enhanced with more features
Lets see how to use it
How to open activity monitor
Below image is self explanatory for how to open activity monitor
It shows 4 graphs
which has 4 performance counters
1.%processor time (% processor time used by sql server)
2.Waiting Tasks
3.Data File I/O
4.Batch Requests per second
Now we can get this info from SSMS instead of going to performance counters
Processes
It shows all current processes running on the server and its related details
We can also sort them and filter it.
We can see its providing rich information from our perspective
Resource Wait
It gives idea when operations has to wait for resources. It can give a idea to troubleshoot resource bottleneck. High wait indicate some bottleneck for that operations ,
Data File I/O
If some data file heavily affected by disk I/O we can get this info from here
Recent Expensive queries
It shows all queries running on the server. Which we can use to get idea which queries are taking high resources or expensive queries
As a part of backup routine or server migration we have to script jobs and then move them to other server. We all are used to SSIS for moving jobs from one server to other server
Another option is to
script all jobs. Then replace necessary login and server name in the script and execute them at the target server
Lets see how to do it
In SSMS in go to jobs. Open object explorer details window at the right side of SSMS
Then select jobs which we want to script right click it and script it. So simple !!!
What’s In the Training Kit
The training kit is divided into four sections:
Here is a breakdown of each section and its associated content:
Lets SQL 