No way that I know of. You can easily point reports and code to the readonly replica with the app intent switch but SSMS also requires the additional parameters....

yb751 (5/6/2016)

---

Did you just try right clicking on a job and select 'Script Job as' option?

It won't help you with synching jobs but that's not something I would normally want...

Hi everyone, I forgot reply the final solution to this problem... sorry...

The reason of all this mistery, was a bad configuration on the hypervisor, in this case VMware. The machine...

opc.three (3/15/2012)

---

What did I wander into with this thread? 😛

My best guess is you have something running that has a memory leak. Can you restart the server after disabling each...

Sure...

opc.three (3/15/2012)

---

Sorry, I see no evidence of 98% memory use. SQL is using 1.94GB and is the largest consumer of the 2.83GB being used by all processes collectively.

From your original...

opc.three (3/15/2012)

---

Please run this from a PowerShell prompt and post the results:

This will show us the list of all processes running on...

opc.three (3/15/2012)

---

From your original post:

Why if I have the max memory limited to 4 GB... the VM Reserved shows 8 GB... and the physical memory used by the process is...

opc.three (3/15/2012)

---

juanc.aguirre (3/15/2012)

---

opc.three (3/15/2012)

---

Run this one too please and post the results, this one includes multi-page allocations:

-- top 10 consumers of memory

SELECT TOP 10

...

opc.three (3/15/2012)

---

Run this one too please and post the results, this one includes multi-page allocations:

-- top 10 consumers of memory

SELECT TOP 10

type,

...

opc.three

What does this return on your instance:

-- top 10 consumers of memory

SELECT TOP 10

type,

CAST(SUM(single_pages_kb)...

Hello... thanks for you quick answer, so... I really don't know if any CLR object exist on the DataBase, the application was not designed by me.

The question is... is...