Specs depend on your environment and workloads. Regarding RAID level, I would recommend RAID 10.

Pls check these to get a basic idea ..

http://msdn.microsoft.com/en-us/library/hh918452.aspx

http://searchcrm.techtarget.com/answer/Datawarehousing-hardware-requirements

http://software.dell.com/documents/quickstart-data-warehouse-appliance-datasheet-24616.pdf

http://h71019.www7.hp.com/ActiveAnswers/us/en/sizers/sql-sizer-fast-track.html

--

SQLBuddy

Yeah just use Network path and grant permissions to the agent or SSIS Proxy Credential.

--

SQLBuddy

VM is definitely not the way to go.

These are best ones ..

http://www.amazon.com/The-Data-Warehouse-Toolkit-Dimensional/dp/1118530802/ref=pd_sim_b_5?ie=UTF8&refRID=1D8GA5JQC7W2V1WXYAK8

http://www.amazon.com/Building-Data-Warehouse-Examples-Experts/dp/1590599314

--

SQLBuddy

I think you can do that by changing the Replica Mode for the Availability Replicas and by the preferred owners properties.

http://blogs.msdn.com/b/alwaysonpro/archive/2014/02/28/sql-availability-group-ag-resource-and-possible-owners-and-preferred-owners.aspx

--

SQLBuddy

DKY (3/10/2014)

---

The output of that query shows 2,680. I don't know how to check the others.

Task manager shows that sqlservr.exe is currently consuming 4,266,016k on the "Processes"...

Keith Tate (3/10/2014)

---

It is true for both cases. When the Lazy Writer task runs it checks the value for Max and Min and adjusts the targets and the notifies the...

DKY (3/10/2014)

---

Actually, yes and no. I inherited this install without the password for the initial instance. I've since stopped the service (a long time ago) and am unable...

What are your Memory Settings right now ? How much memory is SQL Server consuming in the Task Manager ?

What is the SQL Server Build number ?

Check the...

GilaMonster (3/10/2014)

---

Max server memory...

DKY (3/9/2014)

---

I have an instance of SQL Server 2008 R2 installed on a VM with 4 cpus and 16 GB of RAM. It currently uses 15.5GB of memory and...

vsamuel (3/10/2014)

---

We have a system which is used for data management and is on local area network. I have been accessing it without problems. Just Friday has been given me...

webrunner (3/10/2014)

---

I've tested out the replay trace and have a couple of follow-up questions I hope you can help me with.

1. The trace (TQL Replay) template that has the settings...

I think these would be a good starting point ..

http://support.microsoft.com/kb/184974

https://support.microsoft.com/kb/196776

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

--

SQLBuddy

Minaz (3/8/2014)

---

Hi ,

We are having very big tables in TBS and wanted to setup a strategy for index maintenanace. PLease suggest best practices and approachees for this.

Thanking you for...

muthyala_51 (3/9/2014)

---

I am trying to find the exact reason behind why the server behaved like...