dajonx (1/27/2016)

---

Hi,

I was wondering if someone could help me understand the licensing correctly. We have an active/active Windows cluster with two instances of SQL Server using database mirroring to...

How do you know SQL Server is taking 55 GB out of 64 GB, even if that's about how much should be allocated to the sql instance anyways.

I was able to solve this. I was using only 1 NIC and it was connected to iSCSI source,in the validation there was a warning ( who reads warnings ;-)...

Forgot to mention,validation comes back clean

Data access pattern on Drive, someone asked me this question " What is your data pattern on K drive, is it more like random or sequential", i know typically for...

domain admin

Perry Whittle (1/19/2016)

---

Yes you specify the listener name and the database name...

I think i am missing something here.I am trying to connect using listener name, is that even right?

No luck 🙁

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is...

GilaMonster (1/19/2016)

---

I'm going to assume the answer to the question you keep ignoring is 'No', in which case Perry explained above why you're not seeing the read-only routing

Are you specifying...

Looks like there is bit of confusion here, may be i wasn't clear.

I have two servers DB4 and DB5 set in AAG. DB4 is primary and DB5 is secondary. As...

GilaMonster (1/19/2016)

---

Are you specifying the database name in...

krypto69 (1/19/2016)

---

If you are using SSMS you...

I think i do have routing configured, attached is the image.

I am using listener to connect through SSMS, i do have ApplicationIntent = ReadOnly, still it connects to primary? Am i missing something here?