Monday, September 24, 2007

Sql Server 2005. Save and display query plans and statements for all spids - Author Nigel Rivett

 

When you run the sp s_GetQueryPlans it will create a file of every statement (or a single spid) that is running on the system. It will also create other files of associated query plans. Double click on the files and they will open in management studio showing the query or query plan diagram. This is useful for diagnosing problems on a system.

Source: Sql Server 2005. Save and display query plans and statements for all spids - Author Nigel Rivett

No comments: