and no...im not talking to myself :crazy:

Posted out to #sqlhelp and thanks to @SQLHA, @Kendra_Little and @SQLSoldier I was able to fix the issue.

The SIDs were different across the servers, so as a quick fix I...

Negative, because the user or...

One thing I'm noticing is that when I set this up, the user(s) in question were created after the AG was configured. So user1 on the primary was able...

Thanks Matt.

Yeah I'm a bit skeptical as to whether this can be done or not myself, but I was hoping someone with more experience would have good news for me...

We should start a new thread for discussing SQLIO (totally didn't mean to hijack the original) 🙂

I run SQLIO for read and write, sequential and random, and 8k and 64k....

First, recognize the appropriate dbareaction

Here is a good chance for you to some science. Setup your lab, and run through the scenario. Maybe using HammerDB you can run...

I would check the uptime of the server. Lot's of indexes might seem unused shortly after a reboot. I'm usually hesitant to do any index changes like this...

Nadrek (3/17/2014)

---

sql4gnt (3/17/2014)

---

We ran some tests just at the storage level and the RamDisk was 13x faster. Here are the CrystalDiskMark results

8x15k SAS Drives configured as RAID 1+0 and...

We ran some tests just at the storage level and the RamDisk was 13x faster. Here are the CrystalDiskMark results

8x15k SAS Drives configured as RAID 1+0 and 100 Write...

I've been using Red Gate SQL Monitor for about 5 years. The price point is great, and it has never let me down.

I've come from days where...

+1 for Poor Man's T-SQL Formatter. Free is affordable. I use a combination of tools.

When I'm writing code in SSMS I use Red Gate SQL Prompt which is...

Here is my favorite. Written by SQLDenis

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1/#2

If you are doing it strictly for development purposes, then there shouldn't be any problem with just running a local instance of sql server.

Personally, I run everything inside virtual machines...

Along the lines of what Jeff suggested, maybe you can implement your fix and publish it as a "fix" to a security hole in their api? At the very...