DBA Tools

SQL SERVER Activity Monitor Tool:

To analyze the wait time for running a query and to identify whether the query is blocked; SQL Server activity monitor tool is used.

An operational server contains a default SQL Server 2005 instance. DBA needs to install a SQL Server 2008 instance for a new application on an existing operational server. She also needs to ensure that certified third-party applications have access to their respective database instances.

The client requires: 

1- The existing application environments will not be changed

2- Administrative efforts are minimal

Best solution for above scenario is to install SQL Server 2008 as a named instance and configure the new application to use the new instance.

Further Reading:

a- http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=233

b- http://technet.microsoft.com/en-us/library/ms175518(v=sql.110).aspx

c- http://sqlascent.blogspot.ca/2012/02/performance-analysis-using-sql-server.html