Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Exporting Execution Plans - SQL Spackle Expand / Collapse
Author
Message
Posted Monday, October 28, 2013 11:55 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:20 PM
Points: 18,064, Visits: 16,099
Comments posted to this topic are about the item Exporting Execution Plans - SQL Spackle


Thanks to Adam Machanic for pointing me to the fix for the special character problem (code with all the replaces) related to pulling out the code to dump it in the [processing-instruction] where I had been victim to it's bug in the past (see my previous article on sp_Who2 ).

Adam pointed out that he had that bug fixed in his sp_whoisactive script which can be downloaded here.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1509182
Posted Tuesday, October 29, 2013 12:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:56 AM
Points: 6,748, Visits: 8,545
How about some Powershell love to help with this: Export top n SQLPlans

Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1509188
Posted Tuesday, October 29, 2013 8:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, November 28, 2014 3:16 AM
Points: 203, Visits: 624
Might be me, but not sure where 'Second' is?
Post #1509366
Posted Tuesday, October 29, 2013 8:23 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 18, 2014 6:23 AM
Points: 107, Visits: 962
Jason,

Thanks for taking the time to post this article. One question though: What is the purpose of the WHERE clause:
WHERE st1.text like '%sys.sql_modules%'

Thanks again,

Lee
Post #1509377
Posted Tuesday, October 29, 2013 8:32 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:20 PM
Points: 18,064, Visits: 16,099
ALZDBA (10/29/2013)
How about some Powershell love to help with this: Export top n SQLPlans


Thanks Johan. That is a welcome addition.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1509383
Posted Tuesday, October 29, 2013 8:33 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:20 PM
Points: 18,064, Visits: 16,099
Michael.Beeby (10/29/2013)
Might be me, but not sure where 'Second' is?


I'm checking now to find where that section of the article disappeared to.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1509386
Posted Tuesday, October 29, 2013 8:36 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:20 PM
Points: 18,064, Visits: 16,099
Lee Linares (10/29/2013)
Jason,

Thanks for taking the time to post this article. One question though: What is the purpose of the WHERE clause:
WHERE st1.text like '%sys.sql_modules%'

Thanks again,

Lee


st1.text in this example was used to filter down to queries that I knew had that text I wanted to query. Replace that with the text of a known string (such as the name of a stored procedure or a table involved in the query) in the query you are trying to find.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1509391
Posted Tuesday, October 29, 2013 8:39 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 18, 2014 6:23 AM
Points: 107, Visits: 962
Makes sense. Thanks again. This is a very useful query.

Lee
Post #1509393
Posted Tuesday, October 29, 2013 8:41 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:20 PM
Points: 18,064, Visits: 16,099
Lee Linares (10/29/2013)
Makes sense. Thanks again. This is a very useful query.

Lee


You're welcome.
Glad it could be of use.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1509394
Posted Tuesday, October 29, 2013 10:59 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:11 PM
Points: 31,368, Visits: 15,837
There was a problem with some information missing in the article. My apologies for that. I have corrected the text.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1509475
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse