Within the Configuration are both servers possible owners of the resources within the SQL Resource Group? Also are there any errors being reported within the windows event logs that indicate...

You shall need additional Disk resources for each of your new instances Log, data, tempdb.

You shall also require additional IP addresses both Private and Public, as well as ensuring there...

You also need to understand what is using tempdb. Shrinking the file may sort the problem sort term but does not mean this shall not happen again

SELECT TOP 10 session_id,...

If you are trying to run a shrink on the tempdb you must be in single user mode and ensure no other activity is occurring in the tempdb database. If...

you need to look in sys.dm_os_memory_clerks using a query such as

SELECT SUM(multi_pages_kb)

FROM sys.dm_os_memory_clerks

The sizeMB is for the size of the data file

The following from a post on SQLSkills will help you find the size of the plan cache

SELECT objtype AS [CacheType]

, count_big(*) AS...

Have a look at this article http://www.sqlservercentral.com/articles/Memory/74867/

The MPA resides in the windows system cache

For a starter in relation to DB_Name, Create date and size the following will work. This looks only at the 1st data file and ignores the log files but can...

What you need to ensure is that you have a suitable back-up policy in place.

If the Database is in Full recovery then you need to ensure that you run regular...

Best Practice for a Production Environment suggests a value of 1. Just remember that if you change the Max DOP to 8 for maintenance then the plan cache shall be...

This is also the Same for SQL Server 2012

In a SQL server 2008/2008 R2 clustered environment it is not possible to add and remove features.

Please look at http://support.microsoft.com/kb/2547273

This is handled by the LazyWriter process by using a clock algorithm to sweep thru the buffer pool. This then frees up and clean buffer to make sure there is...

There is a good post in relation this at

and