SQLSACT (9/25/2012)

---

Hi all

I have a quick question regarding pages moving from disk into memory

If I select * from a table, are all pages that make up the table and indexes...

The point...

opc.three (9/25/2012)

---

I didn't think locked pages were part of the working set which is why Task Manager lies to us but maybe locked_page_allocations_kb is not what I am thinking it...

What new principal?

The mirror session is created against the clustered...

If the cluster fails over and the failover time exceeds the mirror timeout (default is 10 seconds) the...

Kishore-132325 (9/25/2012)

---

I have 2 SQL Servers in HA set up in Active / Active cluster where we have one DB - named XYZ. Versions : Windows Server 2008 R2 and...

No, it's not. This value

locked_page_allocations_kb

is a part of

physical_memory_in_use_kb

saidapurs (9/24/2012)

---

Hi All,

I configured SQL cluster configuration successfully as Active /Passive but i am not understand how do i configure...

if you use the detach\attach method no you can't.

If you use the object method trnasfer it might work as it reads the...

Jason Marshall (9/24/2012)

---

We restore Production backups to our UAT server nightly to keep data refreshed. The devs are given access through a local server group. When the restores...

if it were me i would separate SSRS and SSIS to one box and put SSAS on its own

braju (9/24/2012)

---

From what I have seen as reponses, I think we should set the MAXDOP to default to 0 and adjust cost threshold of parallelism if needed or even ahve...

No problem, the main thing is...

look closely at the cost threshold parameter and also check for rogue queries and tune them 😉

You could certainly consolidate the database engine instances to one box, whether or not you have a box that's capable of providing the level of performance you'll require from the...