You can.

I wouldn't necessarily base it on PLE though. What kind of wait statistics are you seeing?

Another way would be to launch SSMS (or whatever you're using to run you queries) using "Run As" inside of Windows. Right click on the icon.

TomThomson (3/30/2016)

---

Can someone who knows how Microsoft has chosen to implement snapshot Isolation take a lppk here? I've answered as best I can, but my answers are based on...

the version numbers are strictly internal management mechanisms for SQL Server. They're not something you need to worry about under normal conditions. Why are you so focused on this level...

Yep. That's it. The WSFC has the management interface that AG needs to do what it does.

szejiekoh (3/30/2016)

---

Grant Fritchey (3/30/2016)

---

Availability Groups require the clustering service to be running, but they don't require an actual failover cluster to be created. So no shared storage is required. Just...

dajonx (3/30/2016)

---

As far as I understand it, AlwaysOn is built on top of WSFC so WSFC needs to contain both nodes. You do have the option to share the...

Right there with you. If it's not acknowledging the URL as a name, it's likely an error.

Reading through "all" the documentation, the suggestion is that the URL should just work. I guess the question would be is the distribution server up to the same service pack...

Availability Groups require the clustering service to be running, but they don't require an actual failover cluster to be created. So no shared storage is required. Just the service that...

It depends on what the target of the session was. If you output it to a file, then that file should be there. And yes, you should be able to...

Are the databases online? Do they pass a consistency check? Those are my primary concerns.

RECOMPILE might not be the right hint to use here. If a local variable is used and performance is better than when a parameter is used, then the problem is...

Hmmm.... yeah, you'd think. As I say, I haven't tried setting that up, so I don't have a good suggestion. What is the error message that you get? Be sure...

szejiekoh (3/29/2016)

---

Grant Fritchey (3/28/2016)

---

If you set up your backups to go to multiple files, you will need those files for the restore. Using multiple files, on multiple drives, is a...