Oh, one more thing. What blocksize do you have those drives set to? I have seen that make a difference in speed. Find out what your mean...

chandan_jha18 (11/14/2012)

---

Perry,

Thanks for replying.

The server uses VMWare and the sysadmin wrote the following to me:

'All of these drives are situated on the same set volume on the NetApp'.

He also wrote...

Markus (11/7/2012)

---

scogeb (11/7/2012)

---

Markus (11/7/2012)

---

Very difficult to tell you... if fluctuates.....

The left side of the graph from 0 to 100 goes up and down but if I highlight one of the...

I would do 4 seperate dbs for sure. Restores would be easier and the segregation would allow for easier managment. The initial setups of jobs is a one...

Markus (11/7/2012)

---

Very difficult to tell you... if fluctuates.....

The left side of the graph from 0 to 100 goes up and down but if I highlight one of the lines below...

Markus (11/7/2012)

---

So I am using PerfMon to monitor

physical disk performance Obj

avg dis sec/read counter

avg disk sec/write counter

avg dis sec/transfer counter

based on this article:

http://blogs.technet.com/b/askcore/archive/2012/02/07/measuring-disk-latency-with-windows-performance-monitor-perfmon.aspx

but I cannot figure out...

Could you disable all logins except one, and use that login for this maintenance?

Perry Whittle (11/5/2012)

---

OK, just tested it myself. If your mirror instances all run as the same service account leaving the boxes blank is fine, you won't see any GRANTs as...

GSquared (11/3/2012)

---

scogeb (11/2/2012)

---

I like to think there is always an exception to every rule. Take for instance a table that ALWAYS has inserts and NEVER has any selects. ...

Perry Whittle (11/5/2012)

Yes, that's what I'm expecting 😉

Are the SQL server services all running under the same account?

Just out of interest, the wizard directs you to enter the service account...

Perry Whittle (11/2/2012)

---

scogeb (11/2/2012)

---

That is intersting. When I run that query, I get no results. When I take out the where clause, I see that the only class_desc...

That is intersting. When I run that query, I get no results. When I take out the where clause, I see that the only class_desc of Endpoint I...

Well, from what I can tell, Microsoft really wants to make it difficult to determine what credentials are used for the mirroring connections. Even in sys.dm_exec_connections the session_id is...

Michael Valentine Jones (11/2/2012)

---

scogeb (11/2/2012)

---

I like to think there is always an exception to every rule. Take for instance a table that ALWAYS has inserts and NEVER has any...

I like to think there is always an exception to every rule. Take for instance a table that ALWAYS has inserts and NEVER has any selects. Putting a...