locked
SharePoint 2007: How to trace query SELECT TOP 2147483648? RRS feed

  • Question

  • Hi All,

    I've an application build on top of SharePoint 2007, however, I noticed there is a performance issue on the application such as slowness, CPU usage high and etc.

    Further study on the back end query in DB via sp_who3 stored procedure from this article (http://sqlserverplanet.com/dmv-queries/a-better-sp_who2-using-dmvs-sp_who3),  sometime there is query like "SELECT TOP 2147483648" occurred, and I unable to narrow down what actions or which page load has triggered the "SELECT TOP 2147483648".

    Therefore, I looking for tool can to capture the back query simultaneously, such as when I load a page, what is the query been execute on back end.

    Please help, thank you in advanced.

    Friday, May 4, 2012 8:26 AM

Answers

  • Hello,

    I hope this should help you for your requirement: http://sqlblog.com/files/folders/beta/entry42453.aspx

    It was mentioned on the same page that you were referring.

    If you have queries on SQL query, then please post this to SQL forum.

    Hope this helps,


    -Regards, Rohan Chittyal --------------------------------------------------------------

    Friday, May 4, 2012 3:01 PM

All replies

  • Hello,

    I hope this should help you for your requirement: http://sqlblog.com/files/folders/beta/entry42453.aspx

    It was mentioned on the same page that you were referring.

    If you have queries on SQL query, then please post this to SQL forum.

    Hope this helps,


    -Regards, Rohan Chittyal --------------------------------------------------------------

    Friday, May 4, 2012 3:01 PM
  • Hi,

    If you want to analyze performance related issues from SQL end I would suggest you to try using SQL profiler for the same.


    Thanks, Rahul Rashu

    Sunday, May 6, 2012 3:18 AM