SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / DMV for capturing all SQL Statements instead of just the last / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 01:58:29 GMT20RE: DMV for capturing all SQL Statements instead of just the lasthttp://www.sqlservercentral.com/Forums/Topic1404899-391-1.aspxGood to know. Thanks for posting back.Thu, 10 Jan 2013 10:26:14 GMTopc.threeRE: DMV for capturing all SQL Statements instead of just the lasthttp://www.sqlservercentral.com/Forums/Topic1404899-391-1.aspxSorry, no just the defaults.Thu, 10 Jan 2013 10:10:01 GMTDanielPRE: DMV for capturing all SQL Statements instead of just the lasthttp://www.sqlservercentral.com/Forums/Topic1404899-391-1.aspx[quote][b]DanielP (1/10/2013)[/b][hr]We had to set up Management Data Warehouse (MDW) to monitor. I was able to trace the SQL Code that was causing the blocking by drilling down the Server Acitviy Report for that time frame. There was a spike in 'locks', just had to drill down on it.[/quote]Sorry if I was not clear. I meant within MDW, is this info available to you via the information collected by the Default Data Collector or do you have some Custom Data Collectors setup as well that makes this research possible?Thu, 10 Jan 2013 10:07:51 GMTopc.threeRE: DMV for capturing all SQL Statements instead of just the lasthttp://www.sqlservercentral.com/Forums/Topic1404899-391-1.aspxWe had to set up Management Data Warehouse (MDW) to monitor. I was able to trace the SQL Code that was causing the blocking by drilling down the Server Acitviy Report for that time frame. There was a spike in 'locks', just had to drill down on it.Thu, 10 Jan 2013 09:38:05 GMTDanielPRE: DMV for capturing all SQL Statements instead of just the lasthttp://www.sqlservercentral.com/Forums/Topic1404899-391-1.aspxNice. Thanks for posting back. Do you know if that was part of the default collection set, or a custom one you setup?Thu, 10 Jan 2013 09:30:29 GMTopc.threeRE: DMV for capturing all SQL Statements instead of just the lasthttp://www.sqlservercentral.com/Forums/Topic1404899-391-1.aspxThanks. I actually found it in our MDW report when drilling down on Locks.Thu, 10 Jan 2013 09:25:09 GMTDanielPRE: DMV for capturing all SQL Statements instead of just the lasthttp://www.sqlservercentral.com/Forums/Topic1404899-391-1.aspxWhat you see with the DMVs is the input buffer, i.e. the last batch. If you did not have a Trace or Extended Events session running then the information is no longer available.Thu, 10 Jan 2013 05:44:59 GMTopc.threeDMV for capturing all SQL Statements instead of just the lasthttp://www.sqlservercentral.com/Forums/Topic1404899-391-1.aspxIs there a way to get from a DMV not the last statement executed by a Session but all statements executed by that Session I am trying to capture what the Connection was running with blocking occurred earlier. It currently isn’t blocking and our MDW didn’t capture any transactions at that time.Wed, 09 Jan 2013 10:43:08 GMTDanielP