Viewing 15 posts - 1 through 15 (of 963 total)
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....
June 19, 2017 at 7:59 am
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...
June 14, 2017 at 7:29 am
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...
June 14, 2017 at 6:58 am
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?...
January 1, 2016 at 7:17 am
You do realize you replied to a post that is 7 years old and completely predates SSISDB in SQL 2012?
December 31, 2015 at 7:29 pm
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...
August 19, 2015 at 9:00 am
Msg 9436, Level 16, State 1, Line 7
XML parsing: line 5, character 15, end tag does not match start...
April 29, 2015 at 3:26 pm
How do I delete previous deadlock report?
They're coming from a DMV (Dynamic Management View) so you cannot delete them, per se. All DMVs retain their data until either...
April 29, 2015 at 3:23 pm
SQLSentry Plan Explorer Pro already does this. You have to have a pro edition license though
October 20, 2014 at 10:39 am
The deadlock XML from Extended Events in 2008/R2 is not compatible with SSMS being able to graphically display the deadlock graph.
October 20, 2014 at 10:01 am
December 24, 2013 at 11:58 pm
I would recommend that you start off by doing a comprehensive read of the following two links:
Your nullable parameters are most likely a big part of the problem and this...
December 22, 2013 at 11:04 pm
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...
December 20, 2013 at 8:36 am
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...
December 17, 2013 at 12:48 pm
The ONLY difference is that I'm attempting to use an existing database during the Testing Event...
December 11, 2013 at 2:16 pm