I'm both happy and sad to report we found this issue!

"The session-timeout period is a replica property that controls how many seconds (in seconds) that an availability replica...

hehe - one or the other Brandie, no shared san for AG, no - as you say - that's madness...

unless each node of the AG is on...

Sorry for confusion, i just meant using AG groups and local storage with sync method for 2 nodes in 1 DC - sounds like we are the same there.

Thx for taking time to reply Beatrix Kiddo!

I was afraid this was the expected/norm 🙁  My only hope now is there is some sort of timeout value we...

I've figured this out... Same deal as here: http://sqlblog.com/blogs/aaron_bertrand/archive/2011/10/28/getting-graphical-showplan-back-in-sql-server-2008-r2.aspx

Our issue was that it was remote clients that this stopped working on, so I simply went a server we...

Ok, so maybe no one knows how to fix this so how about:

Can anyone confirm they have a SQL 2014 SP2 instance where the graphical query plan viewer still works?

thanks for the script, very handy!

One request/suggestion... Be mindful of CASE as this doesn't work on case-sensitive instances (only requires minor find/replace)

whats the wait type when you are running the select?

can you do select top 100

are you doing this from the server, or from a client?

I realize this thread is very old, but i just wanted to thank everyone all the same...

I had an insanely stupid moment earlier today and deleted the sql cluster resource...

Correct...

Perry Whittle (12/5/2012)

---

Jeff Kelly-310227 (12/5/2012)

---

Are there a recommended number of files per Filegroup –some mathematical formula to # of cores/etc…?

We understand that typically multiple files are used to spread...

Hi Gail,

thanks for the quick reply, i'll try to talk to each of your points.

1) IO throughput

We're more interested in IOPS, so large pools of disks offer...

GilaMonster (8/10/2012)

---

Jeff Kelly-310227 (8/10/2012)

---

The quick (hack/non proper way) way to solve this in the past for me has been to flip to full, backup db to nul, backup log to...

These are DB's that have been in simple recovery mode, the log gets full for some 'unknown' reason and we could not shrink it or get it back under control.

The...

i've had siutations like this where a simple recovery DB has its log get out of control and i need to flip to full recovery in order to do log...