A read-scale (or clusterless) Availability Group is for read scale out and not HA.  There are very specific steps required to even use a read-scale AG for DR purposes:

Fail...

Querying one of the DMVs requires access to resources. Reading the target state for an event session in the case of PREEMPTIVE_XE_GETTARGETSTATE and it's having to wait for that resource....

Is it showing that wait type for it's own queries?  Why do you think that it needs troubleshooting?  Unless something changed with how Solarwinds collects it's data, it's constant polling...

What monitoring tools are being used for the environment?  I've seen this wait type happen frequently with DMV query execution, specifically often with sys.dm_exec_requests, and consider it to be a...

And how exactly does an off topic tirade on a forum post that predates the feature you are advocating the use of by more than four years help change things?...

You do realize you replied to a post that is 7 years old and completely predates SSISDB in SQL 2012?

Duran (8/18/2015)

---

I'd love a bit of guidence in getting this cleared up. I'm not sure what way to turn as this point, and the box is critical. Obviously I am...

Tac11 (4/28/2015)

---

when I run your query on my laptop getting this error:

Msg 9436, Level 16, State 1, Line 7

XML parsing: line 5, character 15, end tag does not match start...

AnthonyR (4/28/2015)

---

They're coming from a DMV (Dynamic Management View) so you cannot delete them, per se. All DMVs retain their data until either...

SQLSentry Plan Explorer Pro already does this. You have to have a pro edition license though

The deadlock XML from Extended Events in 2008/R2 is not compatible with SSMS being able to graphically display the deadlock graph.

GilaMonster (12/23/2013)

---

It may be worth looking through the codebase for other similar procedures. I've typically found that if this kind of pattern is used in one place, it's used in...

I would recommend that you start off by doing a comprehensive read of the following two links:

http://www.sqlskills.com/blogs/kimberly/stored-procedure-parameters-giving-you-grief-in-a-multi-purpose-procedure/%5B/url%5D

http://www.sommarskog.se/dynamic_sql.html

Your nullable parameters are most likely a big part of the problem and this...

GilaMonster (12/20/2013)

---

william.rees.howells (12/20/2013)

---

Well, if I use my load testing tool and load it up with about 20-30 concurrent queries running this SP then I can reliably recreate a load of...

Other key considerations that factor into consolidation:

Security - do any apps have fixed server roles like sysadmin as requirements, those usually have to be segregated

Tempdb Usage - in a consolidated...